s q l performance issue help kavali

[KrishnaDevaRaya]

view ni run chesthunte  results ravadiniki chala time paduthundhi.

view internal ga chala views ni calll chesthundhi... Performance tuning yela cheyyali ? 

 

[Bhai]

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?

[kum5758]

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

[KrishnaDevaRaya]

sql database bro

[KrishnaDevaRaya]

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 ??

 

[alooparata]

try upwork.com

[Archanaa]

1 minute ago, alooparata said:

try upwork.com

Fost froof no

[alooparata]

4 minutes ago, Archanaa said:

Fost froof no

osey nuvvu which technology working? oopt ?

[Archanaa]

1 minute ago, alooparata said:

osey nuvvu which technology working? oopt ?

Big Data Analytics 

[alooparata]

Just now, Archanaa said:

Big Data Analytics 

aweeeee....sweet 

[4Vikram]

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

[Archanaa]

18 minutes ago, alooparata said:

aweeeee....sweet 

Which sweet buddy?

[alooparata]

2 minutes ago, Archanaa said:

Which sweet buddy?

Fost froof no

[Archanaa]

10 minutes ago, alooparata said:

Fost froof no

Fook naaku no

[DayLord]

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 ..