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 |
|
omamiiiiii
Starting Member
3 Posts |
 Posted - 2006-05-13 : 10:02:50
|
| Hello,I am facing now a problem with the database of my application.It has gotten very large because of the too many registrations and the numerous records,thousands of them.Because of this ,the application slows down a lot.The only solution i have found is deleting the old registrations to fasten the application but this is only a temporary solution.Is there any way in sql server for solving this problem cause i am not a very good expert of it. |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-05-13 : 11:38:54
|
| U may need to give more details:eg. 1. Whether the DB is normalized or not2. Approximately, how many records in transaction tables3. Whether the tables are indexed (properly)4. Whether the slowness is due to front end or because of DB5. WHether the Stored procedures (if any) are efficient (Are those using cursors).Srinika |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-05-13 : 13:01:59
|
| Might be that you need some maintenance on the tables - update statistics, rebuild indexes, that type of thing.Kristen |
|
|
|
|
|
|
Sql Server Data Load