From: Wolfgang M. <wol...@gm...> - 2005-09-29 20:26:24
|
Jakob, if a single query does already take 30 seconds, it is likely that some long-running part of the query is blocking the entire database and concurrency will be getting worse with every additional user. So in order to improve concurrency, you will have to find out what exactly is slowing the query down. It is hard to give any advice without seeing the query and the data. You could try to increase the cacheSize setting in conf.xml, especially if you see a lot of disk activity. I'm always willing to do a bit of profiling if I have time, some real data and a few queries to test with. So if you can't find a way to speed it up, you may consider to send me a test package. > PS: BTW, it appears we're using a snapshot dated 08 September 2005 (I > am looking at the file dates, is there a more fool-proof way to find > out the exact version? we were switching frequently so I can't > remember which one ... and bin/client.bat -v only says this: The last snapshot was released on August 5, so maybe you're using a cvs bui= ld? Wolfgang |