This is what I do for my ad server, to avoid heavy load. All counts for impressions, etc are batched up, and only the one time that incrementing the memory count hits a threshold is the counter committed to database, and reset.
It's easy to write a java class which spawns a thread, and make a CFX or CFC to delegate logging to it, and then you can use things like log4j to do make logging asynchronous without an event gateway.. Dov -----Original Message----- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 16, 2005 4:16 PM To: CF-Talk Subject: RE: Asynchronous logging This is a very good idea expanding on Michael's also very good idea. -----Original Message----- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 16, 2005 3:14 PM To: CF-Talk Subject: Re: Asynchronous logging Or just "log" to a memory structure, and then have a scheduled task run every couple minutes to persist the in-memory values to the DB. Now that you have application events, this can be employed in a fail-safe manner, because shutting down the CF server won't result in missed entries. Simpler than setting up a gateway to do it, and it doesn't depend on having Enterprise edition. cheers, barneyb ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199033 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

