SqlDbx
You are not logged in.
Pages: 1
I limit the returned row number with 100 and queried a table containing more than 1 million rows. It first read the whole table and returned 100 rows and query time took as long as the select result time without using the row limit. I tested it on Sybase ASE 15.0.2.
Offline
Thanks for pointing it out.
This will be fixed in a next release.
Offline
It would also be nice if there was a way to enter a custom row limit when you select it. Maybe a text box on the toolbar. You could enter 0 for no limit or enter a number for the limit.
Offline
There's a text box in Options->General to limit number of rows retrieved.
It's not associated with toolbar button, but it seems that it should.
Currently the way it works it unconditionally limits number of retrieved rows.
We probably can change the behaviour and use it for row limit number
Offline
this issue is still broken
Offline
It seems to be working fine.
What Open Client version you have installed.
Offline
Pages: 1