From: Jonathan Gardner <jgardner@jonathangardner.net>
To: proghome@silesky.com
To: pgsql-sql@postgresql.org
Subject: Re: optimisation of a code
Date: Tue, 12 Aug 2003 09:42:08 -0700
Message-ID: <200308120942.10603.jgardner@jonathangardner.net> (raw)
In-Reply-To: <85898f7e.0308111419.2d770a9a@posting.google.com>
References: <85898f7e.0308111419.2d770a9a@posting.google.com>
-----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
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.
- --
Jonathan Gardner <jgardner@jonathangardner.net>
Live Free, Use Linux!
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
iD8DBQE/ORjgWgwF3QvpWNwRAszNAKDuIybxFQuXa9IwrqW0UQf+Iqyb9gCgxqaK
s/MPbNjorsXVMutSAiVEAk4=
=tiHM
-----END PGP SIGNATURE-----
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-sql@postgresql.org
Cc: jgardner@jonathangardner.net, proghome@silesky.com
Subject: Re: optimisation of a code
In-Reply-To: <200308120942.10603.jgardner@jonathangardner.net>
* 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