Select rows/right click/delete selected row(s)
At not so many selected rows HSQL, say 50-100+ selected rows on remote server, hangs.
It does come out of hanging after work is done.
I think instead of:
delete from table where a = 'foo' and b = 'foo1';
delete from table where a = 'foo3' and b = 'foo4';
delete from table where a = 'foo5' and b = 'foo16';
...
this might help:
delete from table
where (a = 'foo' and b = 'foo1')
or ( a = 'foo3' and b = 'foo4')
or ( a = 'foo5' and b = 'foo16')
...