SqlDbx Forum

jhjdhfurzs

Member

Rows Limit (how implemented)

Hi, when connected (to MySQL for example) and row limit 100 is activated it seems that all rows are retrieved and only the resultgrid is limited to display lets say 100 records. With large tables this takes quite a long time; SELECT ... LIMIT 100 (MySQL-Syntax) much faster. I guess this is true for all database types

Cheers
Robert

sqldbxhelp

Administrator

Re: Rows Limit (how implemented)

SqlDbx never alters statement send to database.
This is why SqlDbx does not use LIMIT. Not all databases have support for it and it does not work in all instances.
For example results returned from stored procedures.

jhjdhfurzs

Member

Re: Rows Limit (how implemented)

Hi,

well I only meant when using the dropdown menu on a table or view [SELECT *] (in this case this is "your" sql, not mine); of course my handwritten SQLs should never be changed. And you are right, these statements are different (SELEC TOP, SELECT ... LIMIT, ...). Another idea maybe would be to suppy an SQL-Statement per connection that is used when clicking on [SELECT *]-popup menu.

Just my ideas

Cheers
Robert