Hi Gabriel, Some of these issues have been discussed in the sourceforge site. The patch tracker and feature request tracker have at least a couple of items related to the second point. Re the first point, the main thing to do is issue the SHUTDOWN COMPACT command periodically. Using a compressed storage format is an also something we can do in the near future.
If you want to get involved in developing the software further and contributing your work, please say so and we'll help you get started. Fred Toussi ----- Original Message ----- From: "Gabriel Lawrence" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: 12 June 2002 21:55 Subject: [Hsqldb-developers] Performance Questions... Howdy, I'm using the 1.7.0 release embedded in our application. Its working really well thanx! I have two issues with it right now, first the files on teh filesystem seem to get pretty large relatively quickly. Looking at them in an editor they appear to be the kind of thing that would compress really nicely. I took a quick look at the persistence code and it looks like it would be pretty easy to compress the rows before they get written to disk and to uncompress them when they get read. Has anyone else looked at this? what would be the perf implications? Second, I'm running a couple of queries that seemt to take a really long time. I'm wondering if there is any way to get some insight into how the engine is deciding to process the request? I'd like to see if it is using my indexes or if there are other indexes I need to create? Can anyone point me to the logic in the code that decides how to process a request, I'd like to find out what the best way to create indexes is? If I have several items in a where clause should I create compound indexes? If this stuff is answered already somewhere sorry, please point me to the location. Thanx, =-gabe _______________________________________________________________ Sponsored by: ThinkGeek at http://www.ThinkGeek.com/ _______________________________________________ hsqldb-developers mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hsqldb-developers _______________________________________________________________ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas - http://devcon.sprintpcs.com/adp/index.cfm?source=osdntextlink _______________________________________________ hsqldb-developers mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
