OT: why are LAMP sites slow?

[Steve Holden]

Lee Harr wrote:

> On 2005-02-06, Brian Beck <exogen at gmail.com> wrote:
> 
>>>Refactoring a database on a live system is a giant pain in the ass,
>>>simpler file-based approaches make incremental updates easier.
>>>
> 
> 
>>As much as I hate working with relational databases, I think you're 
>>forgetting the reliability even the most poorly-designed database 
>>provides. Continuing with the words example: assuming all words would 
>>otherwise be stored in a table, consider the process of updating the 
>>database schema--all entries are guaranteed to conform to the new 
>>schema.
> 
> 
> 
> Not only that, but with a well-design RDBMS you can put your
> schema changes inside of a transaction and make sure everything
> is right before committing.
> 
Bear in mind, however, that *most* common RDBMS will treat each DDL 
statement as implicitly committing, so transactional change abilities 
*don't* extend to schema changes.

> Isn't there a saying like ... those who create file-based
> databases are destined to re-create a relational database
> management system poorly?  ;o)

regards
  Steve
-- 
Meet the Python developers and your c.l.py favorites March 23-25
Come to PyCon DC 2005                      http://www.pycon.org/
Steve Holden                           http://www.holdenweb.com/