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.
*/


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to