I guess u had 2.5 million records splited into 1600 tables if iam not wrong :)
Why you split the tables to 1600 is there any specific count ? Why you moved to merge table reason behind ? Since 2.5 million records to 1600 is a huge count on nos of tables :( instead of one ;) --Praj On Tue, 14 Mar 2006 07:14:52 -0400 "Paul Halliday" <[EMAIL PROTECTED]> wrote: > Hi, > > One of the databases I use just switched to using merge tables and now > my queries are painfully slow. One table, initially had about 2.5 > million records and now with the change this information is spread > across about 1600 tables. A simple query, say select count(*) has gone > from .04 to about 30 seconds, sometimes even longer. > > The OS is FreeBSD on a 3.1 GHz machine with a 1GB ram. Mysql is > 4.1.15. My my.cnf currently has only one option: > > open_files_limit=24576 > > If anyone could provide me with some other options I might try I would > appreciate it. > > Thanks. > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]