Maybe you could get some speed increase for you queries by setting the record_buffer to a higher value. Because with fixed row length this buffer fills up faster too. Although I doubt that you will gain a lot...
/rudy -----Original Message----- From: Alexander Schulz [mailto:[EMAIL PROTECTED] Sent: dinsdag 15 juli 2003 17:06 To: [EMAIL PROTECTED] Subject: Re:Managing big tables Thanks for your efforts, and in rudys last mail he confirms what i have feared, the io-overhead for reading the extremely longer rows most probably causes these longer query-times. I think we will have to redesign our table-structure, because we're already working on a (hardware-)raid, so the mysql-raid-option won't really be an option. Perhaps the only way to get this damned big tables smaller in appropriate time will be a solution via merge-tables (if this does not slow down our productive queries on that table too much). alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]