Many of the pages on our sites require up to 30 sql select queries to generate the various bits and pieces, including the queries done by our in-house ad server. We do internal page view logging of data such as date, site section, and page, plus the logging of ad impressions. Most of these write queries are updates rather than inserts and all of them are much faster than some of the more complex selects we do. That handful of writes per page are anything but a bottleneck.
----- Original Message ----- From: "Michael Dinowitz" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Wednesday, March 16, 2005 2:04 PM Subject: Asynchronous logging >A thought just came to me. Many people use CF for logging and the logging > 'takes up' time on a page, slowing it down. Why bother? Most logging is > just > posting information to a DB and returns nothing to the page. Here's my > solution to logging being a bottleneck: Asynchronous logging. > > When you want to log a page, you just call an asynchronous gateway on CF > 7 > and pass it all the info you want to log. If it fails, it fails. If it > succeeds then it has all the info it needs to go through. No real 'hit' > to > the page being called other than the calling of the gateway. The page > does > not wait for a result, it does not care if the logging table times out > or > fails, it just goes on. > > What do you think? Any flaws in my logic? Will an asynchronous gateway > used > for logging be a different form of bottleneck? Too much overhead (as its > another page being run)? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199062 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
