need solution for web applications...!
-
Hi All, Any one of you done any big online web applications...? I am developing the Web Applicaion using ASP.NET and C#. If yes, then tell me how to increase the performance and selection of records from the database.commonly, database contains a lakhs of records....! i need the different alogrithms for selecting of records from the database....!! thanks, Sukesh.g
-
Hi All, Any one of you done any big online web applications...? I am developing the Web Applicaion using ASP.NET and C#. If yes, then tell me how to increase the performance and selection of records from the database.commonly, database contains a lakhs of records....! i need the different alogrithms for selecting of records from the database....!! thanks, Sukesh.g
You can probably do this yourself. Here are a couple of starters: Have you run your queries through the query analyser to see their performance? Then tweaking them to see how that changes, then selecting the optimal one for your situation. For example, if your query contains lots of nested sub-queries then sometimes the order of the subqueries can make a difference, as a general rule try and have the inner most sub-query return as little data as possible, as less data is propogated to the rest of the query the whole will run much faster. I once saw a query go from taking 20 minutes to just 15 seconds by this technique alone. Have you run a selection of the queries you are running through the index tuning wizard? It will suggest a more optimal set of indexes for your situation. NOTE: This is optimal for querying, not inserting and updating. If you do a lot of inserting and updating then be more selective about which of its suggestions you take.
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell Can't manage to P/Invoke that Win32 API in .NET? Why not do interop the wiki way!
-
Hi All, Any one of you done any big online web applications...? I am developing the Web Applicaion using ASP.NET and C#. If yes, then tell me how to increase the performance and selection of records from the database.commonly, database contains a lakhs of records....! i need the different alogrithms for selecting of records from the database....!! thanks, Sukesh.g
You may also find that this is a question more suited to the SQL / ADO.NET forum as it is not specific to web applications.
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell Can't manage to P/Invoke that Win32 API in .NET? Why not do interop the wiki way!
-
You may also find that this is a question more suited to the SQL / ADO.NET forum as it is not specific to web applications.
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell Can't manage to P/Invoke that Win32 API in .NET? Why not do interop the wiki way!