Hi Marcus, 

Since you raised the point, I'm going to direct this to you. 

You mentioned wanting stats on a shared short url being specific to when 
you created it, not just the redirect from when it was originally created. 

For instance; let's say there's an existing shortened url to openbd.org and 
it already has 11,000 hits. Then you create a short url to openbd.org. 
Right now, you would just see how many hits the redirect has, and in order 
for me to compile the hits since you created it, I'd have to scan the big 
hitDetail table for any hits since the date you created it. 

I'm thinking about just creating multiple hitCounter entries. This way, 
when a redirect is used, I simply +1 whichever records match that URL. 

In the case of 3 users owning the same redirect, there would be 3 different 
hitCounters in play. 

I'd have to add a 'userID' column to the hitCounter table to differentiate 
whose redirect was which. 

But to me, for simply displaying the hits, it seems far more efficient to 
keep multiple hit counters for a single url than keep one master hit 
counter and have to compile the hit count for the others. 

-- 
-- 
online documentation: http://openbd.org/manual/
 http://groups.google.com/group/openbd?hl=en

--- 
You received this message because you are subscribed to the Google Groups "Open 
BlueDragon" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.

Reply via email to