SKIP in tMySQL slower then in DBF?
Posted: Sun Sep 30, 2012 8:44 am
Hi,
When I run this code after a query with about 500 records
it take about 0.52seconds
When I run this in a DBF-file with the same records
it take about 0.1 seconds
Is there a faster way to read the result of a query?
Thanks
Marc
When I run this code after a query with about 500 records
- Code: Select all Expand view
- oQry:GoTop()
DO WHILE !oQry:eof()
oQry:Skip(1)
ENDDO
it take about 0.52seconds
When I run this in a DBF-file with the same records
- Code: Select all Expand view
- Go Top
DO WHILE !eof()
Skip
ENDDO
it take about 0.1 seconds
Is there a faster way to read the result of a query?
Thanks
Marc