Enterprise Applications
-
I am now working with an ERP application, but the database is getting bigger and bigger, my application have database with 300MB size after 6 months only!!! and the application is getting slower because huge amount of data, especially when user ask for a report or do some inquiries in screens, I am thinking about partial loading solution to load the data partially when user scroll the data, but I have problems with sorting and hanging when user scroll data, what is the best solution for my application, The environment is VB.NET 2008 3 tiers architecture SQL SERVER 2008 Possibly using VPN connection (makes application give time out) Any help is highly appreciated
-
I am now working with an ERP application, but the database is getting bigger and bigger, my application have database with 300MB size after 6 months only!!! and the application is getting slower because huge amount of data, especially when user ask for a report or do some inquiries in screens, I am thinking about partial loading solution to load the data partially when user scroll the data, but I have problems with sorting and hanging when user scroll data, what is the best solution for my application, The environment is VB.NET 2008 3 tiers architecture SQL SERVER 2008 Possibly using VPN connection (makes application give time out) Any help is highly appreciated
There are many areas that you need to look at. Are your queries running against indexed values? Are you bulk loading too much data? Should you be lazy loading? What can you cache? To be honest, whoever designed this system should have thought about these issues right at the start - it's going to cost a lot more to fix the system now that it's live than it would have cost at the design stage. BTW - 300MB isn't very big, you need to sort this out now before you get to terabytes.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith
As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.