how to increase performance
-
i have used a stored procedure which requires joining with 10 tables (can't reduce this). It takes 8 seconds to load the page with this procedure. Also i have 2 more procedures with simple select queries for validation. Can i increase the performance by using linq or anyother methods instead of using this procedures. please help me out .
-
i have used a stored procedure which requires joining with 10 tables (can't reduce this). It takes 8 seconds to load the page with this procedure. Also i have 2 more procedures with simple select queries for validation. Can i increase the performance by using linq or anyother methods instead of using this procedures. please help me out .
You didn't share details(like code) here. But here some way to optimize things. SQL Server DO's and DONT's[^] Top 10 steps to optimize data access in SQL Server: Part I (use indexing)[^] Top 10 steps to optimize data access in SQL Server: Part II (Re-factor TSQL and apply best practices)[^] Top 10 steps to optimize data access in SQL Server: Part III (Apply advanced indexing and denormalization)[^] Top 10 steps to optimize data access in SQL Server: Part IV (Diagnose database performance problems)[^] Top 10 steps to optimize data access in SQL Server: Part V (Optimize database files and apply partitioning)[^]
thatraja
FREE Code Conversion VB6 ASP VB.NET C# ASP.NET C++ JAVA PHP DELPHI ColdFusion
HTML Marquee & its alternativesNobody remains a virgin, Life screws everyone :sigh:
-
i have used a stored procedure which requires joining with 10 tables (can't reduce this). It takes 8 seconds to load the page with this procedure. Also i have 2 more procedures with simple select queries for validation. Can i increase the performance by using linq or anyother methods instead of using this procedures. please help me out .
-
i have used a stored procedure which requires joining with 10 tables (can't reduce this). It takes 8 seconds to load the page with this procedure. Also i have 2 more procedures with simple select queries for validation. Can i increase the performance by using linq or anyother methods instead of using this procedures. please help me out .
You need to start by measuring where the performance problem is.
- Is the query slow to execute from SSMS?
- Does it take a long time for ASP.NET to read the results of the query?
- Is ASP.NET taking a long time to bind the data and build the control hierarchy?
- If the generated output is large, is it taking a long time to download to the browser?
- If the generated output is very large, is it taking a long time for the browser to render it?
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
