should be thread safe, with a decent a real database? did you try and return a 304 for the request?
On Thu, Jun 11, 2009 at 1:41 PM, Andrew Myers<am2...@gmail.com> wrote: > > Is that definitely thread-safe? > > Also just coming back to Steve's suggestion, one thing I am noticing is > that the browser will no longer cache the image file (at least on my > configuration). Is that unavoidable? > > On Thu, 11 Jun 2009 12:49:28 +1000, Dale Fraser <d...@fraser.id.au> wrote: > >> >> Nothing wrong with >> >> Update tracking set myCount = myCount + 1 >> >> Regards >> Dale Fraser >> >> http://dale.fraser.id.au >> http://learncf.com >> http://flexcf.com >> >> -----Original Message----- >> From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On >> Behalf >> Of Andrew Myers >> Sent: Wednesday, 10 June 2009 10:26 PM >> To: cfaussie@googlegroups.com >> Subject: [cfaussie] Re: Banner Tracking >> >> >> Thanks for that suggestion - I like it :-) >> >> So any thoughts on the counter side of things? Is it a bad idea to have >> say a table like this: >> >> Table Name: Banner >> Columns: banner_id, banner_desc, banner_impressions, banner_clicks, >> image_url, click_url >> >> Then lock and increment the banner_impressions or banner_clicks depending >> on the action? Does that create a bottleneck? >> >> Or am I better using a separate table, inserting a row for each click / >> impression, and totalling them up as a separate job? >> >> Andrew. >> >> >> >> On Thu, 11 Jun 2009 12:07:41 +1000, Steve Onnis <st...@cfcentral.com.au> >> wrote: >> >>> >>> What you could do is do this.... >>> >>> Instead of loading the image/swf, make the script load a cfm file >>> like... >>> >>> <img src="loader.cfm?adImage.gif" /> >>> >>> then you could increment the counter for that ad based on the file being >>> used to load the ad. >>> >>> Then because you know the name of the image/swf you can then read the >>> file, >>> then output it and push it to the client using cfcontent to set the >>> content >>> type of the stream you are pushing to the browser... >>> >>> Hows that? >> >> >> >> > > > > > -- > Using Opera's revolutionary e-mail client: http://www.opera.com/mail/ > > > > -- Zac Spitzer - http://zacster.blogspot.com +61 405 847 168 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---