full text search in multiple tables

[phil]

Hi frends

I have a database with 11 tables, each table stores somehow similar values, there's a field in each table called "name" which is full-text ...

I want to make a mysql_query that searches for a string in all the 11 tables and shows results in desc order by date (i have the date field)

what I'm thinking of is

Code:

mysql_query ("SELECT * from tbl1 WHERE match('name') against('$q') UNION SELECT * from tbl2 WHERE match('name') against('$q') UNION SELECT * from .........");

at peak time, mysql just craches, and errors start to appear on webpage (( too many connections )) ... So is there a better way to make the full-text search in the 11 tables ?

suggestions are welcomed
thanks -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[herbew]

You are doing OK, there is no better way because there are 11 tables

if you had made only one table, then it would be better. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --