FoxPro database connector - re:speed problems accessing a 700,000 record database

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

re:speed problems accessing a 700,000 record database

Dinesh

2005-06-30, 9:24 am

hi,

I would appreciate if anybody has any tips on how to speed up browsing a
database with 700k records. the file structure of this database is mostly
having all character fields except for 2 fields which are of memo type.

for eg, when i do BROWSE FOR EMPTY(COUNTRY) it takes a while for the browse
window to come up and if later when i press pgup or pgdn it slows down again.

thanks in advance.

rgds,
dinesh

Sponsored Links