Sarvapindi Posted July 12, 2021 Report Share Posted July 12, 2021 stored proc queries performance tuning seyyali..jara help needed Quote Link to comment Share on other sites More sharing options...
duryaodhana Posted July 12, 2021 Report Share Posted July 12, 2021 I can give it a try Quote Link to comment Share on other sites More sharing options...
chapstick Posted July 13, 2021 Report Share Posted July 13, 2021 4 hours ago, Sarvapindi said: stored proc queries performance tuning seyyali..jara help needed Is this not developers work ? Quote Link to comment Share on other sites More sharing options...
Sarvapindi Posted July 13, 2021 Author Report Share Posted July 13, 2021 17 minutes ago, chapstick said: Is this not developers work ? developer also Quote Link to comment Share on other sites More sharing options...
ZoomNaidu Posted July 13, 2021 Report Share Posted July 13, 2021 15 minutes ago, Sarvapindi said: developer also High level lo post cheyi - can try. Quote Link to comment Share on other sites More sharing options...
dasari4kntr Posted July 13, 2021 Report Share Posted July 13, 2021 cursors...ekkuva vunnaya..? Quote Link to comment Share on other sites More sharing options...
Sarvapindi Posted July 13, 2021 Author Report Share Posted July 13, 2021 28 minutes ago, dasari4kntr said: cursors...ekkuva vunnaya..? No cursors...all temp tables..select into temp tables with lot of joins between tables. Quote Link to comment Share on other sites More sharing options...
Sarvapindi Posted July 13, 2021 Author Report Share Posted July 13, 2021 44 minutes ago, ZoomNaidu said: High level lo post cheyi - can try. Its basiclaly select into temp table from joining multiple tables.. select * into #temp1 from tableA join table b join table c join table d where.... select * from table x into #temp2 from table y join #temp1 join temp etcc..so on.. final select statement is the result it has about 8 temp tables.. Quote Link to comment Share on other sites More sharing options...
dasari4kntr Posted July 13, 2021 Report Share Posted July 13, 2021 17 minutes ago, Sarvapindi said: No cursors...all temp tables..select into temp tables with lot of joins between tables. CTE (WITH) try chesava...? WITH recursion..? 2 Quote Link to comment Share on other sites More sharing options...
Sarvapindi Posted July 13, 2021 Author Report Share Posted July 13, 2021 5 minutes ago, dasari4kntr said: CTE (WITH) try chesava...? WITH recursion..? Ya..first ade chesina..then went with temp tables Quote Link to comment Share on other sites More sharing options...
ZoomNaidu Posted July 13, 2021 Report Share Posted July 13, 2021 29 minutes ago, Sarvapindi said: Its basiclaly select into temp table from joining multiple tables.. select * into #temp1 from tableA join table b join table c join table d where.... select * from table x into #temp2 from table y join #temp1 join temp etcc..so on.. final select statement is the result it has about 8 temp tables.. 1. Temp table lo use only columns what u need - do not bring everything. 2. select into #temp1 use cheyakunda, instead create a ddl for #temp1 and then use Insert into temp1 table. This will be little faster. 3. make sure you use the correct filters in join conditions. Inka indexes, constraints kuda vuntaayi.. 1 Quote Link to comment Share on other sites More sharing options...
dasari4kntr Posted July 13, 2021 Report Share Posted July 13, 2021 23 minutes ago, Sarvapindi said: Ya..first ade chesina..then went with temp tables sql server or oracle...? select into badulu...try to create a temp table (local / global depends on your needs)...lantivi try cheyii.. break down your...massive single join to ..two to three.. may be that could help... Quote Link to comment Share on other sites More sharing options...
Sarvapindi Posted July 13, 2021 Author Report Share Posted July 13, 2021 1 hour ago, dasari4kntr said: sql server or oracle...? select into badulu...try to create a temp table (local / global depends on your needs)...lantivi try cheyii.. break down your...massive single join to ..two to three.. may be that could help... Sql server Quote Link to comment Share on other sites More sharing options...
Sarvapindi Posted July 13, 2021 Author Report Share Posted July 13, 2021 2 hours ago, ZoomNaidu said: 1. Temp table lo use only columns what u need - do not bring everything. 2. select into #temp1 use cheyakunda, instead create a ddl for #temp1 and then use Insert into temp1 table. This will be little faster. 3. make sure you use the correct filters in join conditions. Inka indexes, constraints kuda vuntaayi.. will try thxz Quote Link to comment Share on other sites More sharing options...
dasari4kntr Posted July 13, 2021 Report Share Posted July 13, 2021 7 hours ago, Sarvapindi said: Sql server then.. try the memory optimized tables...like below... may be..you need to little research on that option.... CREATE TABLE dbo.ShoppingCart ( ShoppingCartId INT IDENTITY(1,1) PRIMARY KEY NONCLUSTERED, UserId INT NOT NULL INDEX ix_UserId NONCLUSTERED HASH WITH (BUCKET_COUNT=1000000), CreatedDate DATETIME2 NOT NULL, TotalPrice MONEY ) WITH (MEMORY_OPTIMIZED=ON) GO Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.