STORE SQLSTRINGCONNECT('DRIVER=SQL Server;SERVER=server;DATABASE=master ;UID=sa;PWD=') TO gnConnHandle

SQLEXEC(gnConnHandle,'select * from dbo.sysobjects','cur1')
SELECT cur1
INDEX ON id TAG id
seco1=SECONDS()
for i = 1  TO  10000 
SQLEXEC(gnConnHandle,'select * from dbo.sysobjects where id='+STR(m.i),'cur2')
ENDFOR
seco1=SECONDS()-seco1

seco2=SECONDS()

SELECT cur1
for i = 1  TO  10000 
=SEEK(m.i)
a=name
ENDFOR
seco2=SECONDS()-seco2
MESSAGEBOX(seco1)
MESSAGEBOX(seco2)

SQLDISCONNECT(gnConnHandle)
USE IN cur1
USE IN cur2

SQLPrepare(gnConnHandle,'select * from dbo.sysobjects where id=?m.i'),'cur2')

for i= 1  to  10000 
SQLExec(gnConnHandle)
next

declare @i int , @a1 int , @dt1  datetime
set @dt1=getdate()
set @i= 1 
while @i< 10000  
begin 
 set @a1 = (select id from dbo.sysobjects where id=@i)
set @i=@i+ 1 
print @i
end
print @dt1
print getdate()