Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# ASP.NET SQL-Server , +
Hi all,
i have a web application which is very large in terms of form and database. we have around 150 web pages and 50 database table in database. somehow the architecture of the project is not good. we have used dev express controls , ajax tool kit , jquery , json , lot of sessions and viewstate in every pages. functionality of project is working fine but performance of the application is very poor. can anyone please help me to check how can we improve things based on performance. or some configuration settings may be on IIS.
 
we have used cache and gzip compression but other suggestions are also welcome.
 
Thanks
Posted 19-Feb-14 19:16pm
ravikhoda6.8K
Comments
VICK at 20-Feb-14 1:19am
   
Have you tried optimization at DB end.. e.g. if you are using inline queries with select *.. you can change them to select field1, field 2 etc.. mean just get the desired results and so on.. Optmization at DB end can maximize your application performance.
ravikhoda at 20-Feb-14 3:49am
   
thanks for all of yours suggestions i think database clean up will take a lot of time for me only and then i can test things again. i will apply other changes and update you later
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

  Permalink  
v4
Comments
ravikhoda at 20-Feb-14 3:49am
   
thanks for all of yours suggestions i think database clean up will take a lot of time for me only and then i can test things again. i will apply other changes and update you later
thatraja at 20-Feb-14 3:54am
   
welcome & let me know
Maciej Los at 2-May-14 15:01pm
   
"Improve everything" link placed down to your sign on "Bugs And Suggestions" board - that's the way to chain attention ;)
+5!
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

  Permalink  
Comments
ravikhoda at 20-Feb-14 3:49am
   
thanks for all of yours suggestions i think database clean up will take a lot of time for me only and then i can test things again. i will apply other changes and update you later
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

1) Use Stored Procedures where ever possible...
2) Check your queries in the SPs. Remove unwanted fields from the queries...
3) Index the Tables which are used most in Select queries..
4) If you are using SQL Server as DB, monitor the queries to identify which queries take more time to execute.
5) Do not store large data in Sessions/Viewstate.
 
The above points are basic points.
 
http://www.infoworld.com/d/data-management/7-performance-tips-faster-sql-queries-262?page=0,0[^]
 
and Refer the above link
 
Hope this gives the start you need...
  Permalink  
v3
Comments
ravikhoda at 20-Feb-14 1:45am
   
1) Use Stored Procedures where ever possible...(already have this )
2) Check your queries in the SPs. Remove unwanted fields from the queries...(need to check on all sp)
3) Index the Tables which are used most in Select queries..(not done)
4) If you are using SQL Server as DB, monitor the queries to identify which queries take more time to execute. (will check this)
5) Do not store large data in Sessions/Viewstate. (there are lot of viewstate and session variables not sure which we can avoid)
 

one more thing. there are some columns in the database which were previously used but now they are not used in project. does these affect the performance of the project.
Dinesh.V.Kumar at 20-Feb-14 1:54am
   
Just remove those. The query will unnecessarily fetch the columns when it is not required. Then these columns will be in memory and will be unused...Till it is cleared..
 
Also clear the memory as and when it is used..
Usage of proper design patterns in the web application will help you in memory management
For eg: using singleton pattern will help you manage the objects. The object once created will be reused when required and will not be created again and again when needed.
 
Find the Design Patterns suitable for your application and implement it..
It will reduce lot of over heads..
 
Regards
ravikhoda at 20-Feb-14 1:55am
   
Tell me one more thing please which is better ..join query or inline sub query if we wanted to get data from multiple tables.
Dinesh.V.Kumar at 20-Feb-14 2:30am
   
Joins are always better then subquery...
Jas 24 at 20-Feb-14 2:42am
   
yes you're right.My 4
ravikhoda at 20-Feb-14 2:10am
   
lot of queries changed and need some more help..now i see that we have unwanted stored procedures as well. we have used that previously but now that code is totally changed/removed. for example lets say we have 20 extra sp in database which are not in used. does it affect the performance. i know these should obviously removed ...but what if they are still in the database..
Dinesh.V.Kumar at 20-Feb-14 2:29am
   
Unused SPs will not affect your application...But queries that are being used if referring to unused columns may affect though the impact will not be big..but still may affect the application
ravikhoda at 20-Feb-14 3:49am
   
thanks for all of yours suggestions i think database clean up will take a lot of time for me only and then i can test things again. i will apply other changes and update you later

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

  Print Answers RSS
0 OriginalGriff 483
1 Sergey Alexandrovich Kryukov 207
2 RyanDev 165
3 PhilLenoir 135
4 Richard Deeming 120
0 Sergey Alexandrovich Kryukov 6,415
1 OriginalGriff 5,856
2 CPallini 2,473
3 Richard MacCutchan 1,667
4 Abhinav S 1,530


Advertise | Privacy | Mobile
Web02 | 2.8.140821.2 | Last Updated 25 Apr 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100