Re: help with making appropriate indexes.
| From: | Jason Wong | Date: | Fri, 16 Aug 2002 09:44:11 +0000 |
| Subject: | Re: help with making appropriate indexes. | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-112932@lists.php.net to get a copy of this message | ||
On Friday 16 August 2002 18:05, lallous wrote:
> But i'm not satisfied with your answer.
This is not the appropriate list for your question in the first place.
> I instinctly created indexes on
> every field that I'm using w/ conditions.
> But I feel that my script can be rewritten more efficiently using JOINTs or
> other things.
Possibly. The manual for your database should have tips on optimisation.
> Any site with reading material regarding how to index and make complex
> queries fast?
Possibly the website for whatever DB you're using and its associated
mailing-list?
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
/*
It's Like This
Even the samurai
have teddy bears,
and even the teddy bears
get drunk.
*/