Re: FN-FORUM: What's the best development platform for creating Web 2.0 business applications?

date posted 22nd November 2007 11:24



Tom Croft wrote:
>
> Ben Moxon wrote:
>>
>>
>>
>> [EMAIL REMOVED] wrote:
>>> Quoting Anthony Cartmell [EMAIL REMOVED]
>>>
>>>> Note to self: must investigate using new MySQL foreign key
>>>> handling, if
>>>> that's the correct term...
>>>>
>>>
>>> Works pretty well. MySQL 5 is almost looking like a real database.
>>> Of course, you need to put it into strict mode.
>>>
>>>
>> By the time you've put in real database features do you lose the
>> speed advantage that made MySQL so successful in the first place?
>>
>> At which point I guess Postgres could finally start getting some of
>> the attention it deserves.
>>
>>
> Mysql can handle huge datasets without problem, as long as you use the
> correct engine for each table and create the correct keys and indexes.
> Google use MYSQL, for pete's sake. (Apologies to pete).
But wasn't the whole point of MySQL originally that because it ignored
half of the SQL standard, missed out on transactions and everything else
it was really fast for people who only need basic functionality?

I wasn't saying it was bad, I was just wondering whether making it more
complete would lose some of it's edge over the competition.