I did attach a zip, is that a faux pas? I tried to attach the raw files, but they were too large to put on one message (the list server bounced the message for being larger than 200KB). Here are two of the files, I'll attach the next in another message.
Duncan -----Original Message----- From: Nevermann, Dr., Peter [mailto:[EMAIL PROTECTED] Sent: Friday, October 10, 2003 4:57 AM To: 'Slide Developers Mailing List' Subject: RE: some potential optimizations 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
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
