Ok, I made all the changes suggested but it still wasn't as fast as I expected it to be.
I tried changing from SQLite to MySQL and the whole function is down to a few microseconds. So, I'm guessing part of the problem was due to SQLite. Probably should have checked that first. I'm sticking with the changes you guys suggested as it will probably help when the tables start growing. regards Tor ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier. Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ sqlobject-discuss mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
