Quote:
Originally Posted by staplegun  I'm at home. Everything else is blazing fast, JC loads like molasses...
Kevin |
It has been incredibly slow and fails to the "Database Error" screen alot for some time now. Many people I know from JC say the same thing. Being at Career Pilot School right now, most everyone here says the same.
Personally, having alot of experience with SQL server databases, I'd bet it is a result of the size of the database. SQL is an inherent resource hog. I'll try to put it into a basic understanding:
A user searches for XY. SQL server will search ALL lines of data for the best answer. Even if it finds AN answer, it will still continue to search ALL lines of data. So, if the DB grows, the resources needed for a simple search does as well.
At my old job, we kept a history of driver logs going back to the beginning of the use of the electronic driver log system. Though the SQL DB was maintained well, it still continued to grow. We experienced periodic failures that increased over time. Eventually, the system was almost unusable and our divisional users were now not using the system. We archived all but 6 months of data and purged the live SQL DB. The system was running like a Ferrari from that point.