Menu

#2 Threaded query execution

open
nobody
None
5
2004-09-29
2004-09-29
Anonymous
No

It would be great if you could have query execution run
in a separate thread, making it possible to cancel a
query at any time.
If you made a mistake on a query that should return
less than 1000 records, but instead returns 5.5
million... it would be nice to cancel it and fix your
query without having to kill JDBCManager and start again.

Setting the max rows to return also doesn't seem to
work perfectly. If you use postgresql and explicitly
add 'limit 50', its very fast. The same query using
JDBCManager to limit the results to 50 takes
considerably longer. Any way to fix that?

p.s. Great tool.

francoist@verang.co.za

Discussion


Log in to post a comment.