[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Bug-gnupedia] Storing large data elements
From: |
Rob Scott |
Subject: |
Re: [Bug-gnupedia] Storing large data elements |
Date: |
Sun, 21 Jan 2001 15:27:12 +0000 (GMT) |
The default table type on MySQL is MyISAM, and it is
most commonly used as a static table, which is faster
than a dynamic table for most corcumstances, and
usually files arent spread all over the fs, unless you
use the dynamic system.
So to answer your question, i dont think they do.
--- Bob Dodd <address@hidden> wrote: > Most
databases I've come across have tended to deal
> with "large" data
> elements by treating them specially. In effect, they
> tend to say that
> after 256 (or some other small number) characters of
> text, and all
> binary data, are held externally to the database,
> and the db just
> references the external storage location. Depending
> on the
> sophistication of the db, you may or may not get
> versioning support for
> the external elements; usually not. I don't know
> mySQL, but I suspect
> it does the same :-?
>
> This becomes a real pain for our style of database,
> where our content
> will typically *not* fit in the database, an all
> versioning gets pushed
> back on the programmer, and mw end up with Rob's
> "(c) hybrid" solution
> (but with added versioning support).
>
> So, this is another "what's the mySQL approach?"
> query.
>
> /Bob Dodd
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Auctions - Buy the things you want at great
> prices.
> http://auctions.yahoo.com/
>
> _______________________________________________
> Bug-gnupedia mailing list
> address@hidden
> http://mail.gnu.org/mailman/listinfo/bug-gnupedia
____________________________________________________________
Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie