performance issue
-
Hi to all, I know its a common question. But I want to share something. Actually I am working on e-commerce portal. It consists of 32000 products with around 2500 categories. I used 3-tier architecture for this project. Everything is coming using stored procedures. I used master pages as well. But still I am fighting with the performance issue. Can anyone please tell me some useful steps to increase the speed of the website. Its taking ages to load the pages. waiting for your assistance....
cheers, sneha
-
Hi to all, I know its a common question. But I want to share something. Actually I am working on e-commerce portal. It consists of 32000 products with around 2500 categories. I used 3-tier architecture for this project. Everything is coming using stored procedures. I used master pages as well. But still I am fighting with the performance issue. Can anyone please tell me some useful steps to increase the speed of the website. Its taking ages to load the pages. waiting for your assistance....
cheers, sneha
First question might be: are you loading all of the records into a grid at startup? Perhaps you should look at only loading an appropriate subset of records. You could also look at caching data and settings that don't change very often. There are also a couple of articles on CP (you'll have to find them for yourself) which give good tips on how to optimise your application. You could also use analysis tools (like Fiddler) to see what the application is doing or analyse the stored procedures; look at the explain plans and try to speed them up. Do they have the correct/any indexes? That barely scrathces the surface and is a guess about your needs: you should be more specific about where the bottlenecks are occurring but should get you started.
me, me, me "The dinosaurs became extinct because they didn't have a space program. And if we become extinct because we don't have a space program, it'll serve us right!" Larry Niven
-
Hi to all, I know its a common question. But I want to share something. Actually I am working on e-commerce portal. It consists of 32000 products with around 2500 categories. I used 3-tier architecture for this project. Everything is coming using stored procedures. I used master pages as well. But still I am fighting with the performance issue. Can anyone please tell me some useful steps to increase the speed of the website. Its taking ages to load the pages. waiting for your assistance....
cheers, sneha
In addition to other ideas I would suggest to fire up a profiler like the one from redgate (ants profiler it is, i believe) to see what takes so long to render your page.
When in trouble, when in doubt, run in circles, scream and shout
-
Hi to all, I know its a common question. But I want to share something. Actually I am working on e-commerce portal. It consists of 32000 products with around 2500 categories. I used 3-tier architecture for this project. Everything is coming using stored procedures. I used master pages as well. But still I am fighting with the performance issue. Can anyone please tell me some useful steps to increase the speed of the website. Its taking ages to load the pages. waiting for your assistance....
cheers, sneha
Agree with digital man. First thing to look at is SQL. Also, does the site have images for the products? Are these optimized? How are they handled? Are you storing in db? Need to see some code to help more...
-
Hi to all, I know its a common question. But I want to share something. Actually I am working on e-commerce portal. It consists of 32000 products with around 2500 categories. I used 3-tier architecture for this project. Everything is coming using stored procedures. I used master pages as well. But still I am fighting with the performance issue. Can anyone please tell me some useful steps to increase the speed of the website. Its taking ages to load the pages. waiting for your assistance....
cheers, sneha