Click here to Skip to main content
15,899,025 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hello everyone,

I made one website for SPA management, but the issue the client are facing is loading of data, it is very slow process.

I have used Asp.net with c# and MSSQL server 2008 for creating that website.

I have used each and every techniques like making Stored Procedure, Normalization of Database, Optimization of the code using OOPS concept, I have also done Indexing on tables. I have also used CSS, JAVASCRIPT, AJAX.But still the website is too much slow...
Moreover my internet connection is also too fast...
But still the level of data coming is too much, and i need to make it as fast as possible.

Please help me out in doing this.

the link of the website is http://jeevaaspa.spaonline.in, please guide me what to do for making this website as fast as possible.

Please help is must needed.

Thanks & Regards,
Krunal Panchal
Posted
Comments
Sergey Alexandrovich Kryukov 26-Mar-11 0:56am    
What's the use of showing the link to the site, if it needs authentication. How to log in?
I don't think it would be possible to advise anything at all based on the information you provide. It takes a lot: some keys parts of code, architecture, design of important components...
Sorry,
--SA
[no name] 30-Mar-11 3:18am    
sorry buddy,
well the user name is admin and pwd is a123

Please help me,

Thanks & Regards,
Krunal Panchal

There can be two approaches:

#1: It needs detailed review of architecture, design of key components and critical parts of the code. I can hardly imagine you can share all this in a reasonable amount of time and get reviewed. I think this is well beyond the CodeProject format. Rather you could hire a good consultant, of the "fixer" type.

#2: You could thoroughly profile all your code and obtain good amount of timing information in order to identify the performance bottlenecks. I'm not sure you can use standard profilers to profile a Web site code (may be I'm just unfamiliar with such products), but your certainly could build your own, very basic profiler and start getting timing data.

Both ways are pretty difficult. At the same time, chances are, the reason of the performance leak can be quite simple and detectable by someone with a fresh eye. Again, it's impossible to say anything else based on the information you provide.

—SA
 
Share this answer
 
v3
From the Database end you could start by reading SQL Tuning Tutorial - Understanding a Database Execution Plan (1)[^] and then search the web for related articles/blogs/tips and read as much as you can.

Also there are potential savings to be made by tuning the indexing. I know that you have set up indexes but sometimes putting an index on an unexpected column (or indeed removing one) can make improvements. With this in mind have a look at SSMS Missing Index Feature[^] and once again do searches on any terms that you are not familiar with.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900