| roncli.com blog |
| roncli.com |
| blog |
| Profile |
 |
| roncli |
| Houston, Texas, United States |
| Labels |
| Coding |
| CTG Music |
| Editorials |
| Games |
| Miscellaneous |
| Music |
| Servers |
| Silliness |
| Software |
| Sports |
| Trax in Space Beta |
| Weather |
| Recent Posts |
| Site logs |
| Miss Driller |
| roncli.com blog |
| Sunday, February 20, 2005 |
|
SQL Server v Winamp Posted: 3:38:00 AM 0 comments |
|
Now playing: RedHeat (m0d) - Discovery (11:25) So I'm sitting here working on my log analyzer web app, and Kathy's sitting on her computer listening to Winamp and playing AdventureQuest. The music plays along fine... until I decide to create an index on my 5 million row table. See, my SQL server is on the same machine as all the MP3s. Since this machine doesn't have any spectacular hardware in it - just an SIDE hard drive - SQL Server and Winamp fight for drive time. The result is usually that SQL Server wins out, causing Winamp to choke. This happening once in a while isn't bad... but I've been hitting my database with new indexes all night trying to reduce my query times from 1 minute to under 1 second. The result, lots of unnecessary interruptions. If we didn't use the MP3s on more than one machine - and an available machine other than the server had enough hard drive space - this could be avoidable. Until then, though, I guess we're stuck just skip skip skipping away... Labels: AdventureQuest, Coding, Gaming, SQL Server, Winamp 0 Comments Post a Comment |