Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Speeding up search on filter command
Message
 
 
À
05/05/2009 08:26:05
Brian O'Donovan
Crescent Computers
Cork, Irlande
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows Server 2003
Divers
Thread ID:
01397941
Message ID:
01397950
Vues:
48
>Hi All
>
>I have an Epos system that the users can search for products by either index or by the filter command. The filter command is very slow if more that one user is sharing the file at the same time. Is there anyting that I can do the speed up the filtering. Index searching is fine.
>
>thanks
>
>Brian

Brian,

If you're using grids and filters and you only select a small subset of records, the filter is going to be very slow. The alternative could be in using filtered indexes instead or SET KEY command.

My advice to forget about filters at all if grid is involved and your application is pre VFP9.
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