Обсуждение: Re: Re: JDBC Performance
I did try out Peter's new JDBC driver on two very simple query-only applications. It was about 15% slower on one of the apps and 10% faster on the other, compared with jdbc7.0-1.2.jar. It worked correctly on both tests. Neither is particularly representative, but the fact that one's faster an one's slower is surprising. I have not had the time to dig into why the discrepancy. - Keith -----Original Message----- From: Peter Mount <peter@retep.org.uk> To: Gunnar R|nning <gunnar@candleweb.no> Cc: Bruce Momjian <pgman@candle.pha.pa.us>; PGSQL-General <pgsql-general@postgresql.org> Date: Monday, October 09, 2000 6:55 AM Subject: Re: [GENERAL] Re: JDBC Performance >On 9 Oct 2000, Gunnar R|nning wrote: > >> Bruce Momjian <pgman@candle.pha.pa.us> writes: >> >> > Applied, and new files added. >> > >> >> Scares me ;-) I just wanted to get some feedback and testers for this code >> before actually having it applied. I can also imagine Peter might have some >> comments on structure etc. since he got a lot better overview of the JDBC >> code as whole. > >There's going to be some structure changes happening, mainly with the >conversion/optimisation work Gunnar's working on, but also with the >Scrollable ResultSet and regression testing stuff I'm working on at the >moment. > >> Well did anyone review the changes or test them out ? The application I'm >> testing is hardly representative for all applications, so there may still >> be some bugs left in there. > >Which is why I need to get the regression stuff sorted out as soon as I >can. > >Peter > >-- >Peter T Mount peter@retep.org.uk http://www.retep.org.uk >PostgreSQL JDBC Driver http://www.retep.org.uk/postgres/ >Java PDF Generator http://www.retep.org.uk/pdf/ > > >
"Keith L. Musser" <kmusser@idisys.com> writes: > I did try out Peter's new JDBC driver on two very simple query-only > applications. It was about 15% slower on one of the apps and 10% faster > on the other, compared with jdbc7.0-1.2.jar. It worked correctly on > both tests. > > Neither is particularly representative, but the fact that one's faster > an one's slower is surprising. I have not had the time to dig into why > the discrepancy. > I assume you mean the driver the modifications I posted, unless Peter hasn't checked in anything to CVS recently that I am unaware off ? (I'm not online with my CVS snapshot at the moment...) I would sure like to see your applications(or the differences between them), so I can take a look at analyzing the discrepancies. Also platform information like jdk version, vendor and OS information is interesting. I suspect that the optimizations I did can have different effects depending on the cost of allocating new objects in a specific environment. Regards, Gunnar
On 10 Oct 2000, Gunnar R|nning wrote: > "Keith L. Musser" <kmusser@idisys.com> writes: > > > I did try out Peter's new JDBC driver on two very simple query-only > > applications. It was about 15% slower on one of the apps and 10% faster > > on the other, compared with jdbc7.0-1.2.jar. It worked correctly on > > both tests. > > > > Neither is particularly representative, but the fact that one's faster > > an one's slower is surprising. I have not had the time to dig into why > > the discrepancy. > > > > I assume you mean the driver the modifications I posted, unless Peter > hasn't checked in anything to CVS recently that I am unaware off ? (I'm not > online with my CVS snapshot at the moment...) I'm committing what I have shortly, but I've not actually committed anything for a few months... Peter -- Peter T Mount peter@retep.org.uk http://www.retep.org.uk PostgreSQL JDBC Driver http://www.retep.org.uk/postgres/ Java PDF Generator http://www.retep.org.uk/pdf/