General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
With a small table ( 100000 records , file size 95 MB ) I see no real difference running SELECT-statement on fields with index of without index.
knamn LIKE 'LARSEN%' ( indexed field )
0.538 seconds
adresse LIKE 'ATT%' ( no index )
0.509 seconds
gateadr LIKE 'KJ%' ( no index )
0.558 seconds
knr = '0315900' ( indexed field )
0.490 seconds
Rushmore does not show at all.
I double ( to 200000 records )
Now VFOLEDB is in real trouble.
knamn LIKE 'LARSEN%' ( indexed field )
65.701 seconds
adresse LIKE 'ATT%' ( no index )
66.215 seconds
gateadr LIKE 'KJ%' ( no index )
66.614 seconds
knr = '0315900' ( indexed field )
67.311 seconds
My conclusion so far is that VFPOLEDB does not use Rushmore technology.
And that the product is useless for real business.
I will report back after testing with VFP8 SP1.
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