I've done some comparative TestSelf runs on an 1800MHz XP machine which has few services running and seems to give far more consistent results in repetitive tests than the machines I normally use.
Running TestSelf 100000 gives the following results (statements per second, rounded up or down to the nearest 100) in the second run: version 1.7.1 cached insert 8200 update 3700 delete 10000 memory insert 22700 update 13900 delete 32500 version 1.7.2 alpha G cached insert 7800 update 4500 delete 13300 memory insert 23300 update 13800 delete 33000 although overall cached table performance is higher with the latest code, the 5% drop in insert performance needs further attention. Is this related to the TestSelf code, or to something else that's causing a bottleneck? Anyone interested will be welcome to look into this as I will be dealing with some other issues in the next couple of weeks. Fred Toussi ------------------------------------------------------- This sf.net email is sponsored by: Influence the future of Java(TM) technology. Join the Java Community Process(SM) (JCP(SM)) program now. http://ads.sourceforge.net/cgi-bin/redirect.pl?sunm0004en _______________________________________________ hsqldb-developers mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
