[thelist] Re: Relational DB Help

[John Handelaar]

> -----Original Message-----
> From: thelist-admin at lists.evolt.org
> [mailto:thelist-admin at lists.evolt.org]On Behalf Of rudy
> Sent: 23 February 2002 22:57
> To: thelist at lists.evolt.org
> Subject: Re: [thelist] Re: Relational DB Help
>
> >> I've been told repeatedly that we don't want to store the page content
in
> >> the db table itself, that it's better to store a link to the article in
the
> >> db table instead. This way, not only do you not weigh down the db with
these
> >
> >Forgive me but that's a crock of...
>
> from the point of view of database performance, i'd have to agree
>
> there's really no problem storing content in text/memo fields

True, but I also offer this advice if the DB you use is MySQL,
on account of how a planning mistake bit me on the arse last
month  after 18 months of trouble-free site usage:

Keep the text/memo fields the hell away from other fields
associated with them - chuck the BLOB or mediumtext fields in
a seperate table.  Makes no *logical* sense to me, but MySQL
really barfs badly on the complex tables when they start getting
a lot of rows on them.  For Win32 environments, multiply that
by about a thousand (which is the number of seconds some of
my queries were taking the other week :-)

------------------------------------------
John Handelaar

T +44 20 7209 4117       M +44 7930 681789
F +44 870 169 7657   E john at userfrenzy.com
------------------------------------------