speed

[Jules Jacquot]

hi ruslan

classic question

i am using these code for to display 592 records on the listbox

inquery=mdatabase.SQLSelect("select * from usertable order by jnumeng")
assigncursor(inquery)

the duration is 41 sec

now go through Visql

the duration is 0,01sec

adapt to my app with VIsql

the duration is 1,60 sec

why ? and how to do for to improve the speed ?

thanks very much


jules

---------------------------------------------------------
Ne vous mettez pas en avant, mais ne restez pas en arrière