[thelist] Re: Relational DB Help

[Nick Wilson]

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


* and then rudy declared....
> >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
>
>
> >The idea is not to store the html in the db if possible, just the text.
> >It makes no odds how much text.
>
> true, but this brings up an interesting point
>
> to store the "content" you'll probably want to store *at least* <p> tags,
> if not <img> and <hx> and so on
>
> it's kinda hard to separate the html

It's pretty much impossible in anything but theoretical retoric (cant
speel)

> the way to split it is to have the pages produced by templates which
> "include" the content (i.e. the navigation etc. is in the template) and
> then the included content is *mostly* text with some simple html

That's exactly what I do. Limit yourself to simple formating like p,
strong, em, etc but produce the rest with templates (PHPLib is my fav)

> the search function would then be able to find relevant pages, but it would
> be a database search, and not something like atomz which indexes static
> files

Well, I use atomz to index my dynamic pages. It's easy to set up so your
url's are www.mysite.com/articles.php/45/34/ instead of
www.mysite.com/articles.php?id=45&auth=34

> make sense?

Oooh yeah!
- --
- -----------------------------------------------------------
 www.explodingnet.com   |    Projects, Forums and
                        +    Articles for website owners
- -- Nick Wilson --     |    and designers.

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

iD8DBQE8eCbpHpvrrTa6L5oRAnbPAJ9Wb759MvsFEFMHP/9vpAERpFnEfgCeLy+t
KLNt66XEU8ViCggmjerWm1o=
=tl4Y
-----END PGP SIGNATURE-----