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.