Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Grid
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Titre:
Re: Grid
Versions des environnements
Visual FoxPro:
VFP 8
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01131496
Message ID:
01131528
Vues:
16
This is exactly waht I wanted to add too. Don't use filters and grids together. Use either local view or select SQL.

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
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform