Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-10-29 : 09:12:22
|
| Steven writes "Picture a web app'n that displays a list of users who are contactable (e.g by phone) at any given moment. The list refreshes every 2 minutes, as users often update their contact details. The stored procedure SQL is complicated and it is inefficient to have every user running the same SQL to see the same list. Considered scheduling a web assistant job to generate an HTML file every 2 minutes, but would this be overkill (unsure of the web assistants resourcefulness)? Considered using a global temporary table but is that not memory intensive? Is a trigger on the contact schedule updates the best idea?A lot of developers must face this problem - how to most efficiently deliver data that changes occasionally?" |
|
|
|
|
|
efficiently delivering HTML data that changes occasionally