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
-~----------~----~----~----~------~----~------~--~---

Reply via email to