track links initiated on by the recipient of the email broadcast. Each
link with be associated with an ID and tracked back to a landing page in
which I can increment counters for that particular link
My question is what is the best performance option to run a counter in
the database for each link. Should I just increment one column every
time?
OR
Should I trigger the action to another table which will add an new row
with the LINKID each time it is incremented? Then I could get the result
by running a statement like this: SELECT COUNT(*) FROM TABLE WHERE
LINK_ID = 1
Hope this makes sense. Thx for your help.
-----------------------
Ricky Fritzsching
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
