Re: [Hsqldb-developers] Most effective way to select much data

2002-12-24 Thread fredt
Yes, this has been an issue since Hypersonic days. If you look at the Patch Tracker you will even find a patch for version 1.61 to speed up a class of such queries. IMO, this patch was a bit complicated and I promised to try find a a more straightforward solution. The solution involves revamping t

Re: [Hsqldb-developers] Most effective way to select much data

2002-12-24 Thread fredt
Yes, this has been an issue since Hypersonic days. If you look at the Patch Tracker you will even find a patch for version 1.61 to speed up a class of such queries. IMO, this patch was a bit complicated and I promised to try find a a more straightforward solution. The solution involves revamping t

[Hsqldb-developers] Most effective way to select much data

2002-12-24 Thread Alex Kempkens
Hey, that's a little bit a performance topic. What do you think is the most effective way to select much data. I have a JSP based application and normally there is no problem with a sequencial data select. But I was thinking about if it might help to search in huge tables or with complex que