General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only