Query Related problem
-
hi There is problem regarding fetching data from server. In a table ,There is 900000 records and join with other tables. Other tables also store 100000-2 records each. Query is written in Stored Procedure and it take 10 to 15 minuts in execution. How can We reduce execution time?
-
hi There is problem regarding fetching data from server. In a table ,There is 900000 records and join with other tables. Other tables also store 100000-2 records each. Query is written in Stored Procedure and it take 10 to 15 minuts in execution. How can We reduce execution time?
Use filter criteria (i.e., a WHERE clause) that will reduce the number of records to the minimum required (i.e., don't return unnecessary records). Ensure proper indexes are used for all columns in the JOIN. Show what query you are currently using?
-
hi There is problem regarding fetching data from server. In a table ,There is 900000 records and join with other tables. Other tables also store 100000-2 records each. Query is written in Stored Procedure and it take 10 to 15 minuts in execution. How can We reduce execution time?
lets your code
Vuyiswa Maseko, Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code. C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.com vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/
-
hi There is problem regarding fetching data from server. In a table ,There is 900000 records and join with other tables. Other tables also store 100000-2 records each. Query is written in Stored Procedure and it take 10 to 15 minuts in execution. How can We reduce execution time?
you can reduce execution time by using better management of Indexes
-
hi There is problem regarding fetching data from server. In a table ,There is 900000 records and join with other tables. Other tables also store 100000-2 records each. Query is written in Stored Procedure and it take 10 to 15 minuts in execution. How can We reduce execution time?
And this has nothing to do with C#. Nesxt time, try the General Database forum for this.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak