Hi all, I have been using Mysql to power my online database search engine(CGI). IT contains more than 500K rows of records(12 columns). Is there a trick to optimize Mysql Table( by using Index , temporary table??) so that the search engine could get the result in shorter time? Should I consider using Java to replace existing CGI?? I appreciated if any one of you could provide a little suggestion, trick, or online tutorial. Have a Nice day :-) Tanpy