From: Jonathan Gardner <jgardner@jonathangardner.net>
To: proghome@silesky.com (krystoffff), pgsql-sql@postgresql.org
Subject: Re: optimisation of a code
Date: Tue, 12 Aug 2003 09:42:08 -0700
User-Agent: KMail/1.5
References: <85898f7e.0308111419.2d770a9a@posting.google.com>
In-Reply-To: <85898f7e.0308111419.2d770a9a@posting.google.com>
MIME-Version: 1.0
Content-Type: Text/Plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Content-Description: clearsigned data
Content-Disposition: inline
Message-Id: <200308120942.10603.jgardner@jonathangardner.net>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Monday 11 August 2003 15:19, krystoffff wrote:
> Hi all
>
> I wrote a script in PHP with mysql (hum ... to be honnest, I wrote
> this script under PostGreSQL but we recently migrated to mysql, so I
> had to adapt my code to mysql ... sorry about that ... anyway, it is
> the same kind of query, with subqueries !) but this is a very very
> long script ...
>
> I was wondering if there is a way to optimize this one, by doing some
> JOIN (because the subqueries don't seem to be very powerful ...)
>

Take this to the postgresql-performance list. They love taking things=20
apart and getting it running faster. They'll want:

- - The tables
- - The indexes
- - The queries
- - The results of EXPLAIN and EXPLAIN ANALYZE on the queries
- - What you have already tried and what seems to work and what doesn't.

- --=20
Jonathan Gardner <jgardner@jonathangardner.net>
Live Free, Use Linux!
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQE/ORjgWgwF3QvpWNwRAszNAKDuIybxFQuXa9IwrqW0UQf+Iqyb9gCgxqaK
s/MPbNjorsXVMutSAiVEAk4=3D
=3DtiHM
-----END PGP SIGNATURE-----