On Wed, 30 May 2001 14:46:26 -0700
Chuq Von Rospach <[EMAIL PROTECTED]> wrote:
> On Wednesday, May 30, 2001, at 02:31 PM, J C Lawrence wrote:
>> What I ___*REALLY*___ want is to hook up MHonArc to an SQL
>> backend for archive message storage with all the thread links
>> stored in under SQL.
> Me -- I've sort of decided at some point to throw mhonarc out
> completely, because from what I've seen, it'd be a lot cheaper
> computationally to stuff it all in a database, and generate index
> pages and data pages on the fly than it is to have mhonarc update
> the indexes and everything every time we insert a message in case
> a user might want to visit before the next insertion...
I've looked at the code and logic surrounding properly handling
charsets, all of MIME, all the attachment crap (I allow actual
signal-contributing attachments) etc, and said, "No!" rather loudly.
Its taken a long time for MHonArc to get as good as it is at this
stuff. I'd rather leverage that than recreate it.
I've talked to Eric Hood about this (its a fairly regular Q on the
MHonArc list), and he's interested, but states taht it would be
extremely invasive of the current MHonArc code as it wasn't designed
with anything like a storage/index abstraction concept in mind.
Every so often I toy with using MHonArc as a front end processor
that produces script files which when run do the appropriate SQL
magic... I've got most of it done with my current MHonArc->PHP
setup. The only bit really left hanging is handling the thread
linkage stuff fully (expecially multi-tree joins etc).
Like you say, every so often I tell myself it couldn't be too hard,
and then I make sure I go play with the kids instead (which rapidly
results in me lieing down).
> this seems like a wonderful place to put a database-driven dynamic
> system and to stop pre-generation pages that get generated 10
> times or more for every access...
<nod>
> I just have other priorites right now, like my front yard and my
> woodshop. But you could get a search engine more or less for free,
> too...
One of the nice things about MnoGoSearch is that it can index
directly off SQL tables.
> ... and save having to build all that technology, indexes and
> etc...
> And I keep telling myself it's not THAT much work, which is my
> hint to go lie down in a dark room until the impulse passes...
Wuss.
<run!>
--
J C Lawrence [EMAIL PROTECTED]
---------(*) http://www.kanga.nu/~claw/
The pressure to survive and rhetoric may make strange bedfellows
