Re: DBD::Pg performance bites compared to DBD::mysql?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: DBD::Pg performance bites compared to DBD::mysql?
Date: 2005-08-22 01:25:56
Message-ID: 5495.1124673956@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

"Greg Sabino Mullane" <greg(at)turnstep(dot)com> writes:
> I can't imagine that it was causing a factor of 2 difference, but I've
> changed the code in DBD::Pg to make do() a lot smarter, for brain-dead
> benchmarks such as MySQL's that use do() instead of prepare/execute
> like they should. In short, DBD::Pg will short-circuit a lot of the usual
> work and call PQexec directly if it can get away with it, which should
> make the profile Tom posted look a lot better. It also avoids overhead of
> going through Pg.pm, and is all C/XS code now. Hopefully, this should
> make the benchmarking results a little more fair. :) This is now in
> cvs, and will be part of the upcoming version 1.44 of DBD::Pg.

Cool. Thanks for doing that. Do you have an idea when 1.44 will
be out?

regards, tom lane

In response to

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Greg Sabino Mullane 2005-08-22 01:47:27 Re: DBD::Pg performance bites compared to DBD::mysql?
Previous Message Greg Sabino Mullane 2005-08-22 00:20:00 Re: DBD::Pg performance bites compared to DBD::mysql?