Web Development

Ask something
Question Locked

MSSQL year wise Database split

0 helpful
3 replies

by ashok

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

we are using warehouse management system, which is developed in vb and sql 2005 database.
this software we are using from last 4 years.
Now the users are getting very slow response for the database queries. we found that there are 2,50,000 records in incoming table, 2,00,000 records in outgoing table and around 50,000 records in storage master ( current stock in warehouse). can any one help me out how to split the database / how to tune the database for the better performance.

3 replies

by bfmomin

It needs to design yearwise schemas.
For more info, please contact me via bfmomin@yahoo.com

Thanks
Dr. B.F.MOMIN

by lanre

1. You have provided very little information to even enable me assist

2. you provide a picture of a db with just 4 tables, that looks weired and you cant just split a database unless, you are sure most of the data in storage in redundant in some sense, in such a case u can create an archiving routing to move out such data into a separate db. you can then create a routine that will access the archive data only when needed

3. while you can split tables in such a way as to provide parallel access, its not a common procedure

4. do you run maintenenc routines on the database ?

5, Lastly, you have not provided information that will determine if your vb code is written in such a way that they use proper indices

if you need moe help u can contact me on lanre_makinde@gmail.com

This discussion is closed to new replies.