Re: Re: performance with 10 million entries

2005-01-25 Thread MaFai
Dear Scott Haneda:   Thx. I also try add the key for 'server_name',it cost 3 hours,but it still not yet completed. For some reason, we have broken adding key process. >>_<<   We now engage on spliting table, hope

performance with 10 million entries

2005-01-25 Thread MaFai
[EMAIL PROTECTED] : When use query with 'like' condition,it would cost too much time. Mysql is using innodb structure ,but not myisam. We haven't test how diff between innodb & myisam. But now the performance is too low. We plan to separate the table group by date or specified flag. It seems ne