Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFPOLEDB is very slow
Message
From
11/11/2003 15:24:55
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00848633
Message ID:
00848869
Views:
15
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
Previous
Reply
Map
View

Click here to load this message in the networking platform