pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jesse <jesse@fsck.com>
To: mallah@trade-india.com
Cc: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL 7.4beta5 vs MySQL 4.0.16 with RT(DBIx::SearchBuilder)
Date: Wed, 29 Oct 2003 14:51:15 -0500
Message-ID: <20031029195115.GX7337@pallas.fsck.com> (raw)
In-Reply-To: <33288.203.145.130.142.1067456744.squirrel@mail.trade-india.com>
References: <33280.203.145.130.142.1067455363.squirrel@mail.trade-india.com>
	<33288.203.145.130.142.1067456744.squirrel@mail.trade-india.com>




On Thu, Oct 30, 2003 at 01:15:44AM +0530, mallah@trade-india.com wrote:
> Actually PostgreSQL is at par with  MySQL when the query is being Properly Written(simplified)
> 
> In mysql:
> mysql> SELECT DISTINCT main.* FROM Groups main join  Principals  Principals_1 using(id) join  ACL
> ACL_2 on (ACL_2.PrincipalId = Principals_1.id) 

Interesting, last time I looked, this syntax wasn't valid on mysql.
And I'm not familiar with the "using(id)" notation. Can you point me at
proper docs on it?


> 
> So its not just PostgreSQL that is suffering from the bad SQL but MySQL also.
> But the question is my does PostgreSQL suffer so badly ??
> I think not all developers write very nice SQLs.
> 
> Its really sad to see that a fine peice of work (RT) is performing sub-optimal
> becoz of malformed SQLs.  [ specially on database of my choice ;-) ]

Can you try using SearchBuilder 0.90? That made certain optimizations to
the postgres query builder that got backed out in 0.92, due to a
possible really bad failure mode. Thankfully, because all of this is
machine generated SQL we can just improve the generator, rather than
having to retool the entire application.


-- 
jesse reed vincent -- root@eruditorum.org -- jesse@fsck.com 
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

"If IBM _wanted_ to make clones, we could make them cheaper and faster than
anyone else!"  - An IBM Rep. visiting Vassar College's Comp Sci Department.



view thread (12+ messages)  latest in thread

Message-ID: <20031029195115.GX7337@pallas.fsck.com>
Permalink:  ../20031029195115.GX7337@pallas.fsck.com/
Also on:    postgresql.org/message-id/20031029195115.GX7337@pallas.fsck.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: jesse@fsck.com, mallah@trade-india.com
  Subject: Re: PostgreSQL 7.4beta5 vs MySQL 4.0.16 with RT(DBIx::SearchBuilder)
  In-Reply-To: <20031029195115.GX7337@pallas.fsck.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox