Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>>>>>>>>>>>>
But do not stop investigating, I still think Thomas' multiple SQL suggestion (or pure xBase) would be much faster. Somewhere along the posts I think I saw 50seconds as original timing and that means now around 20-25 which seems very slow to me. Probably you don't have right indexes ?
Cetin
I agree with you, query like this with records count
250x500000 cannot run with time > 1...3 seconds if data are load in cache
Fabio
Précédent
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