dear all,

We're doing a database search where we have 9 tables. If we execute a query (1 table) it runs fast, only if the record is less than a hundred....when we execute a much complex query like

"select * from tbl1, tbl2 where $select Like $var And tbl1.Name Like tbl2.Name"....well the operation timed out!

is there a way to speed up my query performance...we've also done some indexing here but still not working....and in the future we'll be putting millions of records to it..!!!!

any suggestions will be appreciated!