Posted by Markus on 07/13/07 19:58

Michael Fesser schrieb:
> .oO(Markus)
>
>> [handling a race condition]
>>
>> Which is the recommended way to handle this? I guess, as MySQL 4.0 and
>> MyISAM tables are a quite common configuration, there must be some
>> common practice about this, but I did not find anything by googling...
>
> Is it really necessary to keep the script compatible to outdated
> versions of MySQL? The current stable is 5, the old 4.0 is not even
> available for download anymore. If it still has to work on a series 4
> server, then I would make at least 4.1 a requirement.
>
> I would even drop support for MyISAM and use InnoDB instead, but that's
> just a personal decision. I simply need the features of a modern engine,
> so I can't take care of older installations. The same goes for PHP for
> example -- my scripts require PHP 5.2, PHP 4 is dead (it's official
> now). At some point you simply have to draw the line.

Thank you, I see the point; anyway the application is supposed to work
with shared hosting, where MySQL 4.0 is still around. Though, dropping
4.0 support is actually an issue - also because it is not natively
supporting UTF-8. And I use MyISAM simply because it is the only engine
that provides fulltext search.

[Back to original message]