Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Re: Grid
Environment versions
Visual FoxPro:
VFP 8
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01131496
Message ID:
01131527
Views:
16
João,
Beware using filters in a grid. If you have a thousand records you might be ok. If you have many records it will be so slow as to be unusable. We found this out the hard way. When a customer first installed our program it worked great. Three years, and the addition of many thousand records later, it took 30 seconds for the form to load with the filter on. With the filter off it loaded instantly. If you expect to have a large number of records I suggest you have the user enter the criteria for a subset such as a date or invoice number range and run a SQL to put the recs in a cursor for the grid.
John.

>Hi Tore,
>
>Thank's, so simple and i can't remember that.
>
>Have a nice weekend.
>
>João Batista
Beer is proof that God loves man, and wants him to be happy. - Benjamin Franklin
John J. Henn
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform