If you run HSQLDB as a server, you can access it from different processes. You can divide very large deletes or selects from CACHED tables into smaller ones using a range of values in an indexed column.
Fred ----- Original Message ----- From: "Alexandre Boaventura" <[EMAIL PROTECTED]> To: <hsqldb-developers@lists.sourceforge.net> Sent: 22 February 2005 13:22 Subject: [Hsqldb-developers] Another way to access a database Hello, I read the HSQLDB Documentation but I didn't find where explains how to access a HSQLDB Database outside my application. I mean, I'd like to know if it's possible and how. Another question: I've been testing a database with cached tables and I inserted 1 million records, but if I try to do something like DELETE FROM <mytable> or SELECT * FROM <mytable> it occurs OutOfMemory error. I tried to change some settings at .PROPERTIES file but it doesn't take effect. I know that these operations may sound weird when we're talking about 1 million record's table, but we never know... Can I improve the enrironment to make it possible ? Thanks. -- Alexandre Boaventura ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click _______________________________________________ hsqldb-developers mailing list hsqldb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hsqldb-developers ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click _______________________________________________ hsqldb-developers mailing list hsqldb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
