Hi, I have a big problem. I NEED to do a full table scan every month on a table. I really need all of the data in this table This table has about 1,2 GB of data. It takes mysql about 45 minutes to send the data.
I configured mysql with the my-huge.cnf and I also tried "record_buffer=50M" but nothing really changed Server: 2 GB RAM, 4 IDE Harddisks and IBM RAID Controller only mysql is running on this server What do i have to configure to get these huge amount of data faster? Or is mysql not the right database for such things? Thanks in advance Nico --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
