Hi Duncan, where are the files you've changed? There is no attachment ... did you attach a zip? Thanks, Peter
-----Original Message----- From: Duncan McLean [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 22:56 To: '[EMAIL PROTECTED]' Subject: some potential optimizations Hello. I've been playing with slide using MySQL as a structure store. I've been playing with a few optimizations. Could someone please evaluate these files I've changed? The highlights are: - JDBCDescriptorStore.storeObject - removed the deleting and re-adding of all child nodes. Now only new children are added. - MySQLDescriptorStore - added the database script to get the MySQL database automatically set up. - ObjectNode - added ability to track newly added child nodes that are not in the database. - Changed BindingList to use a TreeMap for faster searching. The simple test I was running would try to create 500 users named /users/user1, /users/user2/..... I found before the optimizations adding the users took ~35 seconds. After the optimizations they now take ~8.5 seconds. It seems that creating long lists of child keys was very expensive because when a new node was added the parent's complete list of children was deleted and re-inserted in the database . As an aside I have access to a large number of databases. Are there any in particular that you would like to get database scripts for? Sybase and Informix would be relatively easy. With a bit of effort I could also get DB2 and tera data. Thanks Duncan
