Sql Lo Batch Processing Evarikina Idea Undha?

[siri_vennela]

[quote name='MTBrain' timestamp='1339005274' post='1301922290']

batch processing ante u mean aa 30 million records ni nuvvu 5 million in each batch load ayettu chedhamanukuntunnava?
[/quote]

inka emi anukotamle finding ways to improve performance how anni thalidhu

[cinema pichodu]

[quote name='LoveGuru' timestamp='1339005257' post='1301922287']
dataset ni buffer cheskovachu baa,prathisari database ni hit cheyalsina avasaramlekunda
[/quote]
antha pedda data ni ekkada save chestharu baa.....i am not a sql guy just curiosity tho aduguthunna

[siri_vennela]

[quote name='budankaybalraju' timestamp='1339005168' post='1301922270']

[/quote]

endhuku ala gudlu esukoni chustha solution telistha cheppu lekunte evarinina kanukoni seppu

[LoveGuru]

caching ane concept folllow avvali,go and enable cache settings in ssrs report

[siri_vennela]

[quote name='Jeedeelu' timestamp='1339005189' post='1301922275']

report execution appudu emaina cheyochu anukunta...

like changing buffers....

i know in SSIS but I dnt know how it can b in SSRS...
[/quote]

[LoveGuru]

[quote name='cinema pichodu' timestamp='1339005432' post='1301922313']
antha pedda data ni ekkada save chestharu baa.....i am not a sql guy just curiosity tho aduguthunna
[/quote]
static memory lo baa RAM lo save chesukuntaru,coroporate servers ki terabytes of ram untadhi,a ram indirect ga c drive of the server lo space allocate chesukuntadhi

[siri_vennela]

[quote name='Brahmanandam©' timestamp='1339005325' post='1301922295']
Eee software valla andarini sampeyyali.. .. Ento Ento matladukuntaru.....
[/quote]

[budankaybalraju]

[img]http://2.bp.blogspot.com/-tj18uEVBUhk/T3UdDXivLvI/AAAAAAAACtE/GwOOOFLWawQ/s1600/Brahmanandam+Dookudu+GIF.gif[/img][img]http://2.bp.blogspot.com/-tj18uEVBUhk/T3UdDXivLvI/AAAAAAAACtE/GwOOOFLWawQ/s1600/Brahmanandam+Dookudu+GIF.gif[/img][img]http://2.bp.blogspot.com/-tj18uEVBUhk/T3UdDXivLvI/AAAAAAAACtE/GwOOOFLWawQ/s1600/Brahmanandam+Dookudu+GIF.gif[/img][quote name='Brahmanandam©' timestamp='1339005325' post='1301922295']
Eee software valla andarini sampeyyali.. .. Ento Ento matladukuntaru.....
[/quote]

[budankaybalraju]

[quote name='siri_vennela' timestamp='1339005484' post='1301922322']

endhuku ala gudlu esukoni chustha solution telistha cheppu lekunte evarinina kanukoni seppu
[/quote]

[vissu]

[quote name='budankaybalraju' timestamp='1339005661' post='1301922356']
[img]http://2.bp.blogspot.com/-tj18uEVBUhk/T3UdDXivLvI/AAAAAAAACtE/GwOOOFLWawQ/s1600/Brahmanandam+Dookudu+GIF.gif[/img][img]http://2.bp.blogspot.com/-tj18uEVBUhk/T3UdDXivLvI/AAAAAAAACtE/GwOOOFLWawQ/s1600/Brahmanandam+Dookudu+GIF.gif[/img][img]http://2.bp.blogspot.com/-tj18uEVBUhk/T3UdDXivLvI/AAAAAAAACtE/GwOOOFLWawQ/s1600/Brahmanandam+Dookudu+GIF.gif[/img]
[/quote]

[MTBrain]

[quote name='siri_vennela' timestamp='1339005425' post='1301922308']

inka emi anukotamle finding ways to improve performance how anni thalidhu
[/quote]

ipudu entha time paduthundhi execution ki. indhaka evaro seppinattu caching enable seyyu.

[siri_vennela]

[quote name='LoveGuru' timestamp='1339005525' post='1301922332']
caching ane concept folllow avvali,go and enable cache settings in ssrs report
[/quote]

ee option intially report ki time paduthundhi anukunta kadha

[LoveGuru]

[quote name='siri_vennela' timestamp='1339006057' post='1301922426']

ee option intially report ki time paduthundhi anukunta kadha
[/quote]
naku exact ga cheppu ,neeku report everytime databse ni hit avthundhi so it is taking time,so you want to avoid that and make the report run faster kadha

[cinema pichodu]

[quote name='LoveGuru' timestamp='1339006350' post='1301922479']
naku exact ga cheppu ,neeku report everytime databse ni hit avthundhi so it is taking time,so you want to avoid that and make the report run faster kadha
[/quote]
but if everytime we get new data....we have to hit database everytime kadha.......

[LoveGuru]

[quote name='cinema pichodu' timestamp='1339006472' post='1301922504']
but if everytime we get new data....we have to hit database everytime kadha.......
[/quote]
oka example istha 30 million rows old data undhi adhi already cache lo untadhi,oka 5 million rows kotha data vachindhi and koncham old data update ayi vachindhanuko then nuvvu just e 5 million and updated data kosam mathrame database ni hit chesthav so you wont be hittingthe db for 35 million rows,so deenivalla ne report fast ga run avthadhi andhuke the concept of caching dataset