Sven Mueller wrote: >>>>It is also easier to be fast writing if you lock the >>>>whole table and prevent others from accessing it while you update >>>>things. Slows down reading to stopped while you do a write though. >> >>More like stops every other read and write. > > > for as long as the write takes.
If only that were true! But, instead, it blocks everything for as long as the write takes *plus* as long as all the reads that started before the write was issued take. (At least by default. I know about the low priority writes option, but that has its own problems, like the writes never happening.) -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]