SqlDbx
You are not logged in.
Pages: 1
From a table with 400k rows:
- SELECT * FROM products LIMIT 10000; finishes in 0.2s
- SELECT * FROM products; (with row limit 10000) finishes in 3.5s
The same does not happen in Sybase.
I don't know if this can be fixed or is the way things work.
Thank you.
Offline
That makes sense. SqlDbx does not modify statement you submit to database.
It just stops processing results after retrieving 10000 rows and cancels remaining results.
Offline
Ok, thank you.
Offline
Pages: 1