FoxPro database connector - Re: 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: re:speed problems accessing a 700,000 record database

Fred Taylor

2005-06-30, 11:24 am

BROWSE and filtered conditions don't perform very well together. If it's a
read-only situation, use a SQL SELECT statement to get your condition before
doing the BROWSE on the resultant cursor. If you need to update the
records, you can use a parameterized view.

--
Fred
Microsoft Visual FoxPro MVP

"Dinesh" <Dinesh@discussions.microsoft.com> wrote in message
news:DBBDCD6D-D534-47BA-96BC- 09CC7A228AC7@microso
ft.com...
> 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