It is certainly true that performance with larger databases can be improved. If you want to work in this area, then fine, do it.
I have done some work to separate the indexing and persistence implementation from the rest of the code, so that alternative indexing and persistence schemes can be implemented. This work introduces iterators for index traversal. As a result, the Node class becomes part of the internal index implementation and is not exposed to Table, Select or TableFilter. The iterators return Row objects for processing. Another area I have worked on is the implementation of the memory cache. Although some changes were made for 1.7.2 to make the caching scheme more flexible and accurate, this area is still too closely linked with the rest of the code. My changes should allow using a separate file for each table or using one very large file for all the data. I am currently working on some other changes to the persistence scheme in order to allow an optimal integration with OpenOffice. I am hoping to commit a new version to CVS with some these enhancements in the next few weeks. Fred ----- Original Message ----- From: "Thomas Mueller" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: 29 September 2004 13:53 Subject: [Hsqldb-developers] BTree implementation Hi, I think one point where HSQLDB can be improved is performance for bigger databases (that don't fit in memory). What about a standard BTree index implementation. Is anybody working on a similar project? Do you guys think this would be a good idea? Thomas -- +++ GMX DSL Premiumtarife 3 Monate gratis* + WLAN-Router 0,- EUR* +++ Clevere DSL-Nutzer wechseln jetzt zu GMX: http://www.gmx.net/de/go/dsl ------------------------------------------------------- This SF.net email is sponsored by: IT Product Guide on ITManagersJournal Use IT products in your business? Tell us what you think of them. Give us Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more http://productguide.itmanagersjournal.com/guidepromo.tmpl _______________________________________________ hsqldb-developers mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hsqldb-developers ------------------------------------------------------- This SF.net email is sponsored by: IT Product Guide on ITManagersJournal Use IT products in your business? Tell us what you think of them. Give us Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more http://productguide.itmanagersjournal.com/guidepromo.tmpl _______________________________________________ hsqldb-developers mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
