|
|
Back to UserFriendly Strip Comments Index
|
Egads I hate MS SQL servers | by Kickstart | 2004-02-10 17:09:18 |
| Indices, maybe? |
by tnglives |
2004-02-10 18:48:15 |
Supposedly you take a slight hit on data entry with nonclustered indices, but I've had queries go from overnight to a matter of seconds by adding a well-planned index.
My first instinct would be to simplify the data to the summary level, but it doesn't look like you have much control over the application's data store. LiveStats had similar issues, and actually crippled a SQL Server with a ridiculous number of identical requests per second. Shoddy programming over which we argued with their support department repeatedly.
Let's just say that after that experience, I'm much more apt to point the finger at the app than at SQL Server. Even at a small ISP, many vendors were dumb enough to claim they'd "never had that much traffic before."
I'd have to know a little of the table structure to be of any help with indexing. Email chances at tampabay dot (2-character roadrunner abbreviation) dot com if you'd like. |
|
[ Reply ] |
|
|
[Todays Cartoon Discussion]
[News Index]
|
|
