-----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 <[EMAIL PROTECTED]> Live Free, Use Linux! -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQE/ORjgWgwF3QvpWNwRAszNAKDuIybxFQuXa9IwrqW0UQf+Iqyb9gCgxqaK s/MPbNjorsXVMutSAiVEAk4= =tiHM -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
