[thesite] Tip Harvester question (was: [***] Formatting tips )

[jeff]

seth,

:~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: From: Seth Bienek
:
: Would it be better for me to parse the
: emails (several dozen megs) into a big
: giant structure, and then insert them
: into the database with one query?
:~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

no and yes, in that order.  don't bother parsing them into a big giant
structure.  however, you should be inserting them as one giant query.

:~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: And if so, would I do that by just looping
: the insert statements , or is there some
: "database ninja" technique for getting them
: all (several thousand) in one query?
:~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

sure, just do your logic inside the <cfquery> instead of outside.  like
this:

<cfquery ...>
  <cfloop ...>
    INSERT INTO blah ()
    VALUES ()
  </cfloop>
</cfquery>

notice the order of the tags -- many inserts, one connection.

good luck,

.jeff

name://jeff.howden
game://web.development
http://www.evolt.org/
mailto:jeff at members.evolt.org