Re: left join optimization
Posted by:
webmaster
Date: September 05, 2004 05:50PM
Thanks for the suggestion of using EXPLAIN and such, it helped me catch a problem the original database designer had left in there, the table3.table1_id was a large varchar instead of an integer, and it really messed it up
I went from a 2 minute page load for 25,000 results down to 9 seconds just by changing the datatype from varchar to int.
It is much improved :D
Subject
Written By
Posted
September 02, 2004 02:54PM
September 03, 2004 02:20AM
Re: left join optimization
September 05, 2004 05:50PM
September 06, 2004 02:23AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.