I have a large amount of date that I need to select from in order to generate reports (might take 20 minutes). I also have data continuously being inserted.. I don't mind if the select results doesn't contain the recently added rows (or it can -- I don't care).
I've searched the archive and found some promising leads.. (relevant snippets quoted below) "There is one expection, later 3.23 versions under special conditions can insert and select concurrently, but this is done in such a way as to avoid dirty reads." and "Note that this patch will allow you to have concurrent inserts as selects are running, but only if there is no holes after deleted rows in the able. In this case the insert changes to a normal 'locked' insert until all holes are filled. I have alread updated the online manual about this!" I just can't figure out what the syntax is (or patch I need to apply) in order to do this. Any help in this area would be appreciated. Thanks, Eric Mayers database (spam filter got me the first time) --------------------------------------------------------------------- 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
