KrishnaDevaRaya Posted January 9, 2018 Report 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
Bhai Posted January 9, 2018 Report 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
kum5758 Posted January 9, 2018 Report 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
KrishnaDevaRaya Posted January 9, 2018 Author Report 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
Archanaa Posted January 9, 2018 Report Posted January 9, 2018 1 minute ago, alooparata said: try upwork.com Fost froof no Quote
alooparata Posted January 9, 2018 Report Posted January 9, 2018 4 minutes ago, Archanaa said: Fost froof no osey nuvvu which technology working? oopt ? Quote
Archanaa Posted January 9, 2018 Report Posted January 9, 2018 1 minute ago, alooparata said: osey nuvvu which technology working? oopt ? Big Data Analytics Quote
alooparata Posted January 9, 2018 Report Posted January 9, 2018 Just now, Archanaa said: Big Data Analytics aweeeee....sweet Quote
4Vikram Posted January 9, 2018 Report 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
Archanaa Posted January 9, 2018 Report Posted January 9, 2018 18 minutes ago, alooparata said: aweeeee....sweet Which sweet buddy? Quote
alooparata Posted January 9, 2018 Report Posted January 9, 2018 2 minutes ago, Archanaa said: Which sweet buddy? Fost froof no Quote
Archanaa Posted January 9, 2018 Report Posted January 9, 2018 10 minutes ago, alooparata said: Fost froof no Fook naaku no Quote
DayLord Posted January 9, 2018 Report 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
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.