Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
>An user of my software has a large invoices.dbf, and his computer is slow
>He asked me to delete older records or copy them to another table
>
>I will think about this later, but now I have to have quick solution
>
>If I limit it by filtering by date in cursor, will the GRID become faster, or
>will still be slow because of the filtering job ?
Filtered grids are slow, though I think the Optimize property added in VFP 9 improves matters. If you can use a view or a cursor that contains only the relevant records, that will be faster.
Tamar
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement