-
August 6th, 2010, 11:02 AM
#1
Access database size is huge due to memo field.
Hello everyone,
directly coming to the point,
Scenario:In my database, i have table questionMaster,
having fields
Qid (pk)
QName-memo
Opt1-memo
Opt2-memo
Opt3-memo
Opt4-memo
using .Net, i save rich text data into questionMaster.
The problem is it turns into huge size i.e.say for 3500 questions, database size is 900MB.
if i zip this database, it comes to 60-70 MB only.
Note: I have already tried compacting and repairing data utility.
Please let me know what is the solution to reduce the size.
i expect it to be 80 to 90 MB.
Thanx in advance for reply.
-
August 6th, 2010, 11:30 AM
#2
Re: Access database size is huge due to memo field.
Originally Posted by swaroopbhave
... using .Net, i save rich text data into questionMaster.
The problem is it turns into huge size i.e.say for 3500 questions, database size is 900MB.
if i zip this database, it comes to 60-70 MB only
....
Please let me know what is the solution to reduce the size.
Try first to zip your rich text data and then save it as binary.
Victor Nijegorodov
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|