Folks- With the coming release of PostgreSQL 7.2, I've been doing checking with their JDBC driver for performance bottlenecks. One got solved recently, where calls to the driver's getObject() and any database meta data requests were slowed down since they required an additional call to the database. This has been fixed in the PostgreSQL cvs repository, and their new dev driver on their website (jdbc.postgresql.org) has the change. (I've also sent a j2ee version of the driver to Oleg to update in the Castor repository). This change created a significant speed increase for my stuff.
There is one performance bottleneck that I still find, but I'm not aware of the source, and I believe (but not sure) its specific to PostgreSQL. Its where, in the postgresql logs, I see the same querry being executed twice. I mentioned this before, and I think it was a known problem. I'm going to try to track down this bug, but I wanted to see if anyone had tried already, and wanted to know what they had looked at already. Any advice here would be helpful. Thanks. -- Virtually, Ned Wolpert <[EMAIL PROTECTED]> D08C2F45: 28E7 56CB 58AC C622 5A51 3C42 8B2B 2739 D08C 2F45
msg03520/pgp00000.pgp
Description: PGP signature
