Hi All -
I'm considering inserting all of our web access information directly to a mysql table. We have a medium transaction rate, about 4.5 per second but at peak it can get a lot higher. We get about 140,000 hits per day on average for 1,500 visitors/day. I've never doubted MySQL's speed and reliability for a second (and definitely want to give thanks to all developers). BUT, I'm a little wary about adding this logging feature, which would add about 140k insert statements per day. This number will eventually grow to at least double or triple that. Would anyone advise just doing a batch insert every night of the entire daily log? Obviously I would prefer the real-time option if overhead is minimal... Thanks Chad Arimura AllDorm Inc. --------------------------------------------------------------------- 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
