Re: Taking advantage of prepared statement performance

From: "Brett" <brettonator(at)excite(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Taking advantage of prepared statement performance
Date: 2002-10-10 18:39:50
Message-ID: 20021010183950.92FCA29A42@xmxpita.excite.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Another typo(slow day for me).. should have typed "slower thanpostgres." I don't want to confuse anyone, sorry for the spam--- On Thu 10/10, Brett &lt; brettonator(at)excite(dot)com &gt; wrote:From: Brett [mailto: brettonator(at)excite(dot)com]To: brettonator(at)excite(dot)comCc: pgsql-jdbc(at)postgresql(dot)orgDate: Thu, 10 Oct 2002 14:35:02 -0400 (EDT)Subject: Re: [JDBC] Taking advantage of prepared statement performance

I used it to basically poo poo the idea of using mysql.. Was lightingfast with selects.. 10x's faster than postgres. Then I started doingdeletes and performance fell 10 fold and it was actually slower thanmysql.. this was using mysql in a transactional way.
&gt; *Join Excite! - http://www.excite.com*&gt; The most personalized portal on the Web!

Join Excite! - http://www.excite.comThe most personalized portal on the Web!

------------------------------------------------
Join Excite! - http://www.excite.com
The most personalized portal on the Web!

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2002-10-10 23:07:32 Re: Time type error
Previous Message Brett 2002-10-10 18:35:02 Re: Taking advantage of prepared statement performance