[thesite] need another template..

[Seth Bienek]

Hey Dan,

> how about this: What do you need from me to get them into the DB? :)

I'm glad you asked.

All I need is a table with no indexes and the following fields (name them
whatever):

listid (fk to lookup table with list names)
messageid (pk)
hdr_message-id (text-75char)
hdr_fromemail (text-100char)
hdr_fromname (text-100char)
hdr_toemail (text-100char - optional may be used instead of listid?)
hdr_subject (text-100char)
hdr_date (date)
hdr_in-reply-to (text-75char)
bdy_content (long, memo, whatever)

I'm sure all of the fields will not be used, initially anyway, but it makes
sense to parse out and keep everything we can for future use.

Of course that table needs to be accessible from the server that we want to
run the function on...

That's really about it.  If you can set that up, and do not mind l.e.o.
being tied up, I can test this afternoon and kick the process in the wee
hours tonight.

Seth

------------------------------
Seth Bienek
Solutions Development Manager
Stonebridge Technologies, Inc.
972.455.7294 tel
972.404.9754 fax
ICQ #7673959
------------------------------

> -----Original Message-----
> From: thesite-admin at lists.evolt.org
> [mailto:thesite-admin at lists.evolt.org]On Behalf Of Daniel J. Cody
> Sent: Wednesday, February 28, 2001 11:39 AM
> To: thesite at lists.evolt.org
> Subject: Re: [thesite] need another template..
>
>
> sorry i'm not the most organized guy this week and not being clear..
>
> i mean option 3 :)
>
> Was gonna address the problems with the inserts that you were talking
> about before.. but i'll get them here.. the main reason the inserts were
> taking so long on the old box was cus i had indexs one for that table..
>
> i dont mind if its a strain on the server actually.. we can set it to
> run overnight or something. sorry i know i was gonna do this before, but
> got sidetracked with something :)
>
> how about this: What do you need from me to get them into the DB? :)
>
> i can break the mbox file up into smaller, less big-assed chunks too
>
> lemme know
>
> Seth Bienek wrote:
>
> >> thats kind of an intermediate step it seems to me..
> >
> >
> > Do you mean intermediate as in "down the road, when we have time to mess
> > with all the database stuff", as opposed to "what we have right
> now and need
> > to get online ASAP", or do you mean intermediate as in "It's a
> step out of
> > the path we need to take in order to get things where we want
> them to be"?
> >
> > Because the only reason I can see for even wanting to parse
> those big-ass
> > .mbox files is in order to get them into a db...  So we can
> wrap them in the
> > nice Evolt l&f...
>
>
> _______________________________________________
> http://lists.evolt.org/thesitearchive/
> and new & improved kentucky fried old archives:
> http://lists.evolt.org/thesitearchive/old/
>
>