Sql Lo Batch Processing Evarikina Idea Undha?

[siri_vennela]

[LoveGuru]

cheppu what are your wants

[budankaybalraju]

[LoveGuru]

oka bunch of sql statements ni oka variable lo pass chesi sp_execute sql system sp use chesi execute chey adhe batch processing

[siri_vennela]

nennu okka report ki performance tuning chesthuna around 30 million records unayi vatini 30 sec lo execute avali antaru

so indexes pages temp tables anni use chesa eee situation ki batch process emina use avuthadha

[Ranga_The_Donga]

[quote name='LoveGuru' timestamp='1339004997' post='1301922239']
oka bunch of sql statements ni oka variable lo pass chesi sp_execute sql system sp use chesi execute chey adhe batch processing
[/quote]

[budankaybalraju]

[quote name='siri_vennela' timestamp='1339005092' post='1301922258']
nennu okka report ki performance tuning chesthuna around 30 million records unayi vatini 30 sec lo execute avali antaru

so indexes pages temp tables anni use chesa eee situation ki batch process emina use avuthadha
[/quote]

[Ranga_The_Donga]

[quote name='siri_vennela' timestamp='1339005092' post='1301922258']
nennu okka report ki performance tuning chesthuna around 30 million records unayi vatini 30 sec lo execute avali antaru

so indexes pages temp tables anni use chesa eee situation ki batch process emina use avuthadha
[/quote]

report execution appudu emaina cheyochu anukunta...

like changing buffers....

i know in SSIS but I dnt know how it can b in SSRS...

[LoveGuru]

[quote name='siri_vennela' timestamp='1339005092' post='1301922258']
nennu okka report ki performance tuning chesthuna around 30 million records unayi vatini 30 sec lo execute avali antaru

so indexes pages temp tables anni use chesa eee situation ki batch process emina use avuthadha
[/quote]
SSRS meedha na working

[Terminator II]

[quote name='LoveGuru' timestamp='1339004898' post='1301922209']
cheppu what are your wants
[/quote]
[img]http://i50.tinypic.com/33lp2c2.gif[/img]

[LoveGuru]

[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]
dataset ni buffer cheskovachu baa,prathisari database ni hit cheyalsina avasaramlekunda

[MTBrain]

[quote name='siri_vennela' timestamp='1339005092' post='1301922258']
nennu okka report ki performance tuning chesthuna around 30 million records unayi vatini 30 sec lo execute avali antaru

so indexes pages temp tables anni use chesa eee situation ki batch process emina use avuthadha
[/quote]

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

[LoveGuru]

[quote name='Terminator II' timestamp='1339005212' post='1301922280']
[img]http://i50.tinypic.com/33lp2c2.gif[/img]
[/quote]
evaru saami nuvvu

[Anta Assamey]

Eee software valla andarini sampeyyali.. .. Ento Ento matladukuntaru.....

[siri_vennela]

[quote name='LoveGuru' timestamp='1339005257' post='1301922287']
dataset ni buffer cheskovachu baa,prathisari database ni hit cheyalsina avasaramlekunda
[/quote]

adhi ela chestharu