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:
01131527
Vues:
17
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform