KrishnaDevaRaya Posted January 9, 2018 Report Share Posted January 9, 2018 view ni run chesthunte results ravadiniki chala time paduthundhi. view internal ga chala views ni calll chesthundhi... Performance tuning yela cheyyali ? Quote Link to comment Share on other sites More sharing options...
Bhai Posted January 9, 2018 Report Share Posted January 9, 2018 2 minutes ago, KrishnaDevaRaya said: view ni run chesthunte results ravadiniki chala time paduthundhi. view internal ga chala views ni calll chesthundhi... Performance tuning yela cheyyali ? emi database? Quote Link to comment Share on other sites More sharing options...
kum5758 Posted January 9, 2018 Report Share Posted January 9, 2018 sql aithe 1.enni tables views lo use aithunnayi indexes pettu tarvatha view run chesinapudu execution plan chudu 2. huge tables unte- neku ah table lo em columns kavalo avi tesko filters petti - just temp tables lo pettukoni indexes pettu so that performance increase aithadi order by koncham costly operation chusko give more info on what database, how huge is your datasets, tables info Quote Link to comment Share on other sites More sharing options...
KrishnaDevaRaya Posted January 9, 2018 Author Report Share Posted January 9, 2018 sql database bro Quote Link to comment Share on other sites More sharing options...
KrishnaDevaRaya Posted January 9, 2018 Author Report Share Posted January 9, 2018 3 minutes ago, kum5758 said: sql aithe 1.enni tables views lo use aithunnayi indexes pettu tarvatha view run chesinapudu execution plan chudu 2. huge tables unte- neku ah table lo em columns kavalo avi tesko filters petti - just temp tables lo pettukoni indexes pettu so that performance increase aithadi give more info on what database, how huge is your datasets, tables info Linq to sql vaduthunnam bro. 100 k records results lo vasthunnayi , filter pettina taruvatha 400 records vasthunnai anthe. view ni storeproc ga maristhe emaina use untundha ?? Quote Link to comment Share on other sites More sharing options...
alooparata Posted January 9, 2018 Report Share Posted January 9, 2018 try upwork.com Quote Link to comment Share on other sites More sharing options...
Archanaa Posted January 9, 2018 Report Share Posted January 9, 2018 1 minute ago, alooparata said: try upwork.com Fost froof no Quote Link to comment Share on other sites More sharing options...
alooparata Posted January 9, 2018 Report Share Posted January 9, 2018 4 minutes ago, Archanaa said: Fost froof no osey nuvvu which technology working? oopt ? Quote Link to comment Share on other sites More sharing options...
Archanaa Posted January 9, 2018 Report Share Posted January 9, 2018 1 minute ago, alooparata said: osey nuvvu which technology working? oopt ? Big Data Analytics Quote Link to comment Share on other sites More sharing options...
alooparata Posted January 9, 2018 Report Share Posted January 9, 2018 Just now, Archanaa said: Big Data Analytics aweeeee....sweet Quote Link to comment Share on other sites More sharing options...
4Vikram Posted January 9, 2018 Report Share Posted January 9, 2018 26 minutes ago, KrishnaDevaRaya said: Linq to sql vaduthunnam bro. 100 k records results lo vasthunnayi , filter pettina taruvatha 400 records vasthunnai anthe. view ni storeproc ga maristhe emaina use untundha ?? Untadi Quote Link to comment Share on other sites More sharing options...
Archanaa Posted January 9, 2018 Report Share Posted January 9, 2018 18 minutes ago, alooparata said: aweeeee....sweet Which sweet buddy? Quote Link to comment Share on other sites More sharing options...
alooparata Posted January 9, 2018 Report Share Posted January 9, 2018 2 minutes ago, Archanaa said: Which sweet buddy? Fost froof no Quote Link to comment Share on other sites More sharing options...
Archanaa Posted January 9, 2018 Report Share Posted January 9, 2018 10 minutes ago, alooparata said: Fost froof no Fook naaku no Quote Link to comment Share on other sites More sharing options...
DayLord Posted January 9, 2018 Report Share Posted January 9, 2018 1 hour ago, KrishnaDevaRaya said: Linq to sql vaduthunnam bro. 100 k records results lo vasthunnayi , filter pettina taruvatha 400 records vasthunnai anthe. view ni storeproc ga maristhe emaina use untundha ?? store procedure ki convert cheyi .. before joining on views ..load filter data from each view into temp table and then join those tables .. Quote Link to comment Share on other sites More sharing options...
.thumb.gif.343fe49c7e1c507ae0056326bd8cf77e.gif)
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.