SqlDbx Forum

SqlDbx

You are not logged in.

#1 2013-01-05 16:11:50

u01iz
Member

Row limit feature is slower than SQLs LIMIT x

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

#2 2013-01-06 18:54:59

sqldbxhelp
Administrator

Re: Row limit feature is slower than SQLs LIMIT x

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

#3 2013-01-07 07:43:59

u01iz
Member

Re: Row limit feature is slower than SQLs LIMIT x

Ok, thank you.

Offline

Board footer

Powered by FluxBB