Brent Baisley wrote:
> There will always be new requests, but many times you can store data
> "vertically" in rows instead of "horizontally" in columns. You would
> need a "label" column to indicate what type of data the row contains.
> It's more work on the front end, but a lot more flexible. It's
h if you are not using indexes.
- Original Message -
From: "Stefan Hornburg" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, July 11, 2006 9:51 AM
Subject: Re: Speedup of database changes
Brent Baisley wrote:
Changes to the database structure should be few a far between. I
Brent Baisley wrote:
Changes to the database structure should be few a far between. If you
are finding you need to change the structure regularly, you should
probably look at a redesign.
This customer regularly request new things, so I cannot avoid changes
to the database structure.
MyISAM
Changes to the database structure should be few a far between. If you are finding you need to change the structure regularly, you
should probably look at a redesign.
MyISAM locks the table when an insert/delete is occurring, during which time other requests are queue up. You can switch it to
In
