Oracle, nothing to worry about then :) yup that's the right idea...
fiddler will be mighty useful for making sure it all works as desired z On Thu, Jun 11, 2009 at 2:06 PM, Andrew Myers<am2...@gmail.com> wrote: > > We deploy on Oracle 10g, so I guess so... > > Hmmm are you saying do something like: > > <cfheader statusCode="304"> > > And if it's not in the user's cache already? Do I need to do something > like this? > > http://www.cftopper.com/index.cfm/blogId/1/tag/ColdFusion > > > > On Thu, 11 Jun 2009 13:46:08 +1000, Zac Spitzer <zac.spit...@gmail.com> > wrote: > >> >> 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/ >>> >>> > >>> >> >> >> > > > > -- > 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 -~----------~----~----~----~------~----~------~--~---
