Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    2

    Unanswered: scheduled delete performance cost

    What would be the performance cost if I deleted all the rows from a table in MSSQL every 5 minutes?

    I'm doing this to keep track of whos online. Every time a user goes to a new page they get logged into a table called WhosOnline. Every 5 minutes the log will get deleted.

    What would be the performance cost of this and if its high, does anyone know a better way to keep track of whos Online?

  2. #2
    Join Date
    Aug 2003
    Posts
    2
    Forget it, I figured out how to do it. SessionID & UserName in a database.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •