[thelist] Relational DB Help

[Nick Wilson]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


* and then David Kutcher declared....
> based on publishing large amounts of content, sometimes it does make sense
> to store the "article" as a separate text file for various reasons:
>
> 1. less strain on the database to do queries on large amounts of data

That strain will be picked up by something else though. There are also
some pretty nifty tools for such circumstances.

> 2. ability to use specialized tools to index and query content

Like what?

> Also, lets say we're using MySQL and not a super-scalable, massively
> relational database like Oracle with great indexing functionality... MySQL
> would choke.

I don't see why?

> running a query for "the" in a potentially huge database because they would
> be separate process/applications.

Yeah but the trick here is not to allow a user to search for 'the' or
'a' etc.

> Just thoughts... I might seem to be advocating text files... but normally I
> wouldn't (it's not a good practice)...

Agreed.

> but it might make sense here unless
> he's using a big relational database on a real server system.

If he had a dedicated MySQL server I don't think he'd have a problem
although I wouldnt attempt it. Does he have /that/ much content?
- --
- -----------------------------------------------------------
 www.explodingnet.com   |    Projects, Forums and
                        +    Articles for website owners
- -- Nick Wilson --     |    and designers.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)

iD8DBQE8d//wHpvrrTa6L5oRAqLPAJ9cyNQPd1iArX11YsUGlFC4dsKxhQCgkqEB
0hgEVqE/FBs88WaeUNnbSJk=
=6yJY
-----END PGP SIGNATURE-----