On Thu, Mar 29, 2001 at 08:30:41AM +0100, Piers Cawley wrote:
> Robin Szemeti <[EMAIL PROTECTED]> writes:
> > well .. since in most web based uses of MySQL the 99% of queries are
> > simple 'select * from blah where something=something_else' .. the
> > speed is all you need .. every now and again there is reason to add
> > a user or, very occasionally, someone buys something .. and those
> > bits have the pseudo-transactions in .. yeah .. its slow, but I'd
> > ratehr have that bit slow and the rest lightning quick than pretyy
> > much anything else ..
> But the *REALLY IMPORTANT* uses of the database are the ones where
> you're moving money about and doing order fulfillment. And guess what,
> those *must* be transactional.
Course, mysql does support transactions now... I believe with two
different types of table for some reason.
Foreign keys and subselects still no...
When it supports full text indexing I'll get excited.