Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Alternating Colors in Grids
Message
 
À
24/02/2006 09:58:20
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 8
Divers
Thread ID:
01098730
Message ID:
01098921
Vues:
14
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
Fil
Voir

Click here to load this message in the networking platform