[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Bug-gnupedia] Linking to particular article?
From: |
Tom Chance |
Subject: |
Re: [Bug-gnupedia] Linking to particular article? |
Date: |
Wed, 24 Jan 2001 06:48:20 -0800 (PST) |
--- Hook <address@hidden> wrote: > Tom
Chance wrote:
> > > An article will often comprise a number of
> segments,
> > > each of which may be a
> > > media type other than text. It's not efficient
> use
> > > of a database to store
> > > large binary objects in a table - MySQL
> themselves
> > > recommend against it,
> > > although they agree that the database *will*
> handle
> > > it. Just not
> > > efficiently.
> >
> > You wouldn't store things like pictures and movies
> IN
> > the mySQL databse! But it would be more efficient
> to
> > store text in a database, rather than as many XML
> > files. Especially if you OPTIMIZE it often.
> >
> > >
> > > The same is usually true with large chunks of
> text.
> > > An encyclopedia is
> > > going to get a lot of hits, so one of the
> > > design/implementation criteria
> > > must be performance. For example, you try hard
> *not*
> > > to use varchar in a
> > > table. Use of a single one has an effect on the
> > > performance of all data in
> > > that table. Use of TEXT in any of it's
> > > manifestations has a similar
> > > side-effect in MySQL.
> > Varchars are better to keep to a minimun, but even
> so
> > a database with many varchars and text fields
> would
> > still be more efficient than a large XML
> filesystem.
> >
> >
> > > Throwing hardware at performance problems is a
> > > partial solution, true, but
> > > designing for performance up-front is a better
> > > start.
> > Databasing is performance up-front. Many files
> would
> > need better hardware to get comparable speeds.
>
> Not entirely I'm afraid. If that was really true,
> then Usenet would use a
> database rather than either lots of small files (and
> in the case of net news
> it's the huge number of tiny files which causes
> trouble), and it doesn't.
> The closest is diabolo which uses a small number of
> enormous files with
> comprehensive indexing.
>
> I'd lean towards letting UNIX handle the articles
> (XML, text, word documents
> or whatever), and have a database handle the meta
> data - author, title,
> keywords etc. UNIX after all is pretty good with
> text files.
>
> Paul
That's certainly the next solution after a full
database. And I think it would be best to save the
articles as text files, and make a perl script parse
and format them to be displayed as simple HTML. Then
you could keep all these <author> and <date> tags that
have been mentioned for XML.
Tom Chance
=====
"True security is to be found in social solidarity rather than in isolated
individual effort - Fyodor Dostoyevsky"
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
http://auctions.yahoo.com/
- Re: [Bug-gnupedia] Editorial control, (continued)
- Re: [Bug-gnupedia] Editorial control, Mike Warren, 2001/01/23
- Re: [Bug-gnupedia] Editorial control, Imran Ghory, 2001/01/24
- RE: [Bug-gnupedia] Editorial control, Peter Verrey, 2001/01/25
- Re: [Bug-gnupedia] Editorial control, Mike Warren, 2001/01/25
- Re: [Bug-gnupedia] Editorial control, Imran Ghory, 2001/01/25
- RE: [Bug-gnupedia] Editorial control, Imran Ghory, 2001/01/25
Re: [Bug-gnupedia] Linking to particular article?, Hook, 2001/01/24
Re: [Bug-gnupedia] Linking to particular article?, Bob Dodd, 2001/01/24
Re: [Bug-gnupedia] Linking to particular article?, Tom Chance, 2001/01/24
Re: [Bug-gnupedia] Linking to particular article?,
Tom Chance <=
Re: [Bug-gnupedia] Linking to particular article?, Rob Scott, 2001/01/24