From: Keith Gaughan <kmgaughan@...>
Date: 2006-09-13T04:11:36+09:00
Subject: Re: Joel Spolsky on languages for web programming

On Wed, Sep 13, 2006 at 01:57:02AM +0900, Austin Ziegler wrote:

> On 9/12/06, Keith Gaughan <kmgaughan@eircom.net> wrote:
>
> > That's with respect to table names rather than column names, and really 
> > only effects MyISAM tables. InnoDB tables don't have that problem, if I
> > remember correctly. BDB and others I'm not so sure about because I
> > haven't had need to use them myself.
> 
> IME, it is something with MyISAM (which is still the most common
> configuration because it offers pure speed) and it *does* affect
> column names as well even though it shouldn't for the stupid reasons
> that tables are affected.

Yup, that's what I said. I can't say I've had the same experience as you
with column names. Then again, I don't use MyISAM anymore, except when I
need fulltext search, don't need transactions and need COUNT(*) to work
quickly, or as a read cache. In practice, I find--and, of course, this is
anecdotal--that InnoDB's ability to do row-level locking more than compensates
for the performance difference between the two.

> MySQL is a big sticking pile that should be left in the scrapheap.

If it works fine for a project, it's fine. Personally, I'd prefer to use
something like PostgreSQL, Firebird, or SQL Server, but sometimes MySQL is
just fine.

K.

-- 
Keith Gaughan -- kmgaughan@eircom.net -- http://talideon.com/
It just seems to me that you are wilfully entering an arse-kicking
contest with a monstrous entity that has sixteen legs and no arse...