Information générale
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Craig:
Thanks. When I said "obscure way", I meant a function that I had never heard of which either 1) return grid row numbers for non-active rows (the way that ActiveRow and RelativeRow return the row number for active rows), or 2) return the record's position when indexed (the way that RECNO() does for the table's natural order).
I just ran a SQL SELECT on the table, using a dummy with the same structure and 300,000 records. I had the index set to TAG PhoneNumber, and did a simple "SELECT * FROM TableName ORDER BY PhoneNumber". It took nearly 6 minutes. SET TALK was OFF, and nothing big was running in the background. I need to be able to update the grid nearly instantaneously. Can it be optimized better?
Jerry
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