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.