SQL server database design question

Question

I have a Users table and a Totals table which has an integer field for the total number of users. I thought about writing a console app that counts the Users table and then updates the Totals table. And then make a Task scheduler events that executes this app every 10 minutes. Is there a more elegant way to do this?

Please clarify why you need a Totals table. Is there a business requirement for it? Doing a record count of "Users" will not have a performance impact - it's an extremely fast operation. — funwhilelost
– funwhilelost, Commented Jul 15, 2010 at 0:26
It has a few other system stats besides the user total and it doesn't have to be in real time. — Fasid
– Fasid, Commented Jul 15, 2010 at 0:31

Borealid · Accepted Answer · 2010-07-15 00:25:34Z

1

Make the Totals table a view, so it doesn't need to be updated at all?

or ...

Update the Totals table with ON INSERT triggers on the Users table?

answered Jul 15, 2010 at 0:25

Borealid

99.4k9 gold badges111 silver badges123 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

SeaDrive Over a year ago

This is exactly what triggers were made for.

Collectives™ on Stack Overflow

SQL server database design question

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related