Union Performance Question

2005-05-11 Thread Dan Salzer
Hi everyone, I have a question regarding the performance of UNION queries: I need to do a full-text search against a large number of rows. Is it faster to have one table with 10,000,000 text rows and perform one full-text search. Or, am I better off having 10 smaller more managable tables and

RE: Union Performance Question

2005-05-11 Thread Dathan Pattishall
- From: Dan Salzer [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 11, 2005 11:46 AM To: mysql@lists.mysql.com Subject: Union Performance Question Hi everyone, I have a question regarding the performance of UNION queries: I need to do a full-text search against a large number of rows

Re: Union Performance Question

2005-05-11 Thread Eric Bergen
. -Original Message- From: Dan Salzer [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 11, 2005 11:46 AM To: mysql@lists.mysql.com Subject: Union Performance Question Hi everyone, I have a question regarding the performance of UNION queries: I need to do a full-text search against a large

RE: Union Performance Question

2005-05-11 Thread Dathan Pattishall
. -Original Message- From: Dan Salzer [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 11, 2005 11:46 AM To: mysql@lists.mysql.com Subject: Union Performance Question Hi everyone, I have a question regarding the performance of UNION queries: I need to do a full-text search against a large

Re: Union Performance Question

2005-05-11 Thread Dan Salzer
speed over time. -Original Message- From: Dan Salzer [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 11, 2005 11:46 AM To: mysql@lists.mysql.com Subject: Union Performance Question Hi everyone, I have a question regarding the performance of UNION queries: I