If there are no holes in the data structure storing the MyISAM data,
this concurrency is possible but as soon as any real-world maintenance
kicks in, those holes will exists and the rules kick in:
on MyISAM you may have 1 writer OR many readers.
a write operation will wait for ongoing read
If your client has the bucks and you need the speed, why not use a MySQL
cluster which has row locks and transactions?
Mike
At 11:39 AM 5/15/2007, you wrote:
If there are no holes in the data structure storing the MyISAM data,
this concurrency is possible but as soon as any real-world