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