Slow Sort on a Document Database

[iamthegrey]

Hi All:

I could really use some help here. I have a set up of four databases for my business. One is customers, one is orders, one is estimates and one is other documents. The order database is pretty large. The customer database is 9000 records. The Documents database is 175 records. It takes like 10 times as long to sort the 175 records as it does the 9000.

It doesn't seem to make any difference what field I sort on and whether it is indexed or not. Some of the fields in the database do contain paragraphs of information, but none of these fields are indexed. Overall there are 132 fields in the database (which is not a huge number, right?).

The database itself is reading almost 18MB at this point which I don't quite understand either since it is almost entirely text.

What are my options here? Are there temp files being store that I need to flush. Should I compress the database? What can go wrong if I do the compact database thing?

Any help would be appreciated. Thanks!

[flapjacks]

Turn indexing on in the field you are sorting.

John

[flapjacks]

sorry, missed that. Did you see the post regarding similar problem. Do a search on large size. Maybe some help.

John