On 10/15/2003 at 11:30, you wrote:
RF> I am in the process of developing an email tracking module that
RF> will track links initiated on by the recipient of the email
RF> broadcast. Each link with be associated with an ID and tracked
RF> back to a landing page in which I can increment counters for that
RF> particular link
RF> My question is what is the best performance option to run a
RF> counter in the database for each link. Should I just increment one
RF> column every time?
RF> OR
RF> Should I trigger the action to another table which will add an new
RF> row with the LINKID each time it is incremented? Then I could get
RF> the result by running a statement like this: SELECT COUNT(*) FROM
RF> TABLE WHERE LINK_ID = 1
Unless you are interested in reporting on information about each
click-through (date/time, remote_addr, etc), I would go with a single
column that gets incremented.
If you decide that you want to track each click-though and then use
aggregate functions to generate stats (per link, period of time, etc)
AND you plan on keeping a lot of history, make sure you use a robust
database, i.e., not Access! I learned that the hard way...
~ Ubqtous ~
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
