[thesite] thetips database

Seth Bienek seth at sethbienek.com
Mon Jun 18 11:49:37 CDT 2001


Hey Dean,

> Okay, so the problem that you are having is getting the whole e-mail
> message into the database?

Nope.  The database is fine. The problem is parsing the entire .mbox archive (over 50 meg) without any errors.  And since it's so memory and processor-intensive, I can only run the template against the entire archive every couple of hours, or else there ends up being overlapping threads and other issues.. Once the initial database population is done, there shouldn't be any more problems, but that first step is the big one.

I have some ideas that I will test today, and I'll let you know if I can't get it squared away by this evening.

> I'm assuming that after you have
> messages that contain tips in 'thetips' table, they will moved into
> the 'content' table later, correct?

There was a thread regarding this earlier on this list (it's in the archives somewhere).  I think we want to get the data into it's own table first, then let Rudy (or some other db genius) massage it into the 'content' table.

As far the structure of 'thetips' as it is now, I haven't looked at it but I'm sure it will need to be reworked.

HTH,

Seth






More information about the thesite mailing list