I've done some research on this topic and am looking for some quality comments and suggestions.
I have an application I've been working on for quite some time. As the software continues to be used the clients are reporting a gradual slowing of the app as more data has been entered. I've done all the normal things such as check the server's load and sql server but the thought occurs to me that it might be a flaw in my design.
Currently there are two main tables in the SQL 2005 database. People and Cases. Cases has a key that ties it to people. (ie case 200432 record has a people_id field of 15 to tie it to people record 15). To open the main list of cases I need to include info from the people table and do a select * from cases, people where people.id = cases.people_id. This works fine but returns very slowly. I decided later to remove the * and return o ...
Go to the complete details ...