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
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
