Okay, i've build an application using the db a lot. Sometimes the db have 500-600 query per sec. avg. 400 concurrent connections.
On some scripts i do a select (where ready='Y'), update the records (set ready='N') in a way that a new select will not show the previous selected records. (uhh..) Sometimes this fails and records are selected 2/3 times. Will a simple LOCK IN SHARE MODE solve this problem, or do i need to upgrade to InnoDB ? ( i really dont want to do that right now) I run 3.23.39-log using MyISAM on a 2*pIII 1 ghz 1 gig of ram / raid 5 Thanks in advance... --------------------------------------------------------------------- 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