Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFPOLEDB is very slow
Message
De
11/11/2003 15:24:55
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00848633
Message ID:
00848869
Vues:
16
Yes, VFPOLEDB uses Rushmore....

For obvious reasons I normally use SET COLLATE TO "NORDAN"
After setting COLLATE to "MACHINE" , removing indexes and creating new indexes and removing 'Collating Sequence=NORDAN' from the connection string my numbers are like this:

knamn LIKE 'LARSEN%' ( indexed field )
0.455 seconds

adresse LIKE 'ATT%' ( no index )
39.277 seconds

gateadr LIKE 'KJ%' ( no index )
38.841 seconds

knr = '0315900' ( indexed field )
0.139 seconds

I'm happy with this result.
It's getting late in Europa, so further research will start tomorrow.

Rolf
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform