Hi Jeff,
You're confident, I'll give you that. But why can't you use seek()? I have a table with 100,000 records, an integer field that basically equals the record number, and an index on that field. When I do:
clear
go top
*Find early record using SQL
ns = seconds()
select number from sqlspeed where number = 1 into cursor temp
?seconds() -ns
USE
SELECT 1
goto top
*Find early record using SEEK()
ns = seconds()
=seek(1, 'sqlspeed', 'number')
?seconds() - ns
goto top
*Find late record using SQL
ns = seconds()
select number from sqlspeed where number = 99999 into cursor temp
?seconds() -ns
USE
SELECT 1
goto top
*Find early record using SEEK()
ns = seconds()
=seek(99999, 'sqlspeed', 'number')
?seconds() - ns
goto top
and after about 20 times, I notice a trend in the output kindof looks like:
0.035
0.001
0.006
0.000
I don't think your answer to Ed's question is very complete (Lol!), are you avoiding it?
Précédent
Suivant
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