best method click tracking

any ideas out there for fast click tracking?

[s_mk]

Hi!

I want to track clicks in email messages, and the programmer before me wrote something in ASP that would open a database connection for each click. I'm trying to rewrite it now, but it doesn't seem very efficient to do it this way. Anyone done anything like this before another way?
maybe a good way to cache the clicks and do a single batch insert?
would it even be faster to work off flat files completely instead of a db?

thanks for any advice you can give.

[eelixduppy]

I don't see a problem with using a database, but a flat file will work just as good, and may be a little faster.

If you need help coding this please try your best first, and then we'll be glad to help you if you get stuck at any roadblocks :)

Best of luck!