what is the best way to store counts in a relational database?

Question

i want to store the number of times an item has been viewed.

Answer 1

Add a column to your Items table called "ViewCount" as an integer field.

Have your page execute a SQL statement to increment this value every time the item is viewed.

SQL = "UPDATE Items SET ViewCount = (ViewCount + 1) WHERE ItemID = MyItemID"