Hello everybody.
I remember a couple of months ago a discussion on this list concerning
performing logging within Fusebox... I'm about to embark on a similar thing
and was wondering if anyone made any progress with this???
I'm not actually doing full logging of every user as I don't believe that
would be efficent, but just on a section of my site. Here's what I was
thinking:
When a user hits the page I load all the data on them into a request scoped
structure. I then copy this into an app level struct holding many users
details... When this app level struct contains a certain number of users
details, e.g 100, I do a bulk insert into the Db of all these details.
A few questions about this technique...
What's the best way to do a Db insert from a large struct??? Do I just loop
over the struct inside a SQL query?
When the 100th user (or what ever I set the limit to on the struct to be)
hits the page, the loading of their page will be considerably slowed by the
SQL insert, is there anyway to "spawn" another process, so it wont affect
any users??
Thanks
Ben.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
