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-05-09 : 10:41:20
|
alain writes "I have a SQL Table generated by a proxy server. This table becomes very large VERY quickly. I am doing a query on the bytes received field to monitor users activity.
This data needs to be broken down into usage today, yesterday, this week etc etc.
The problem I have is that after a day or two the table becomes too big to query, queries take up to 15 minutes to run. As I am doing this through a web site, this is too slow. How would you suggest that I overcome this problem.
Can I trigger stored procedures on a regular basis? Daily, weekly etc. Are sp's the way to go?
Pleaseeeeaaase heeeelp.
am" |
|
|
|
|
|
Large Proxy DB