Sql Lo Batch Processing Evarikina Idea Undha?

[Ranga_The_Donga]

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

ee option intially report ki time paduthundhi anukunta kadha
[/quote]


how r u pulling ur data...

by an sp or set of sql statements..?

if yes....okasari pampu will see emaina changes cheyocha ledho dhaniki for performance....

[siri_vennela]

[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]
na odut like ippudu aa option use chestha users ki kuda first time time teesukoni next time nunchi fast avuthundha anni dout or else how it works

[LoveGuru]

[quote name='siri_vennela' timestamp='1339006629' post='1301922521']
na odut like ippudu aa option use chestha users ki kuda first time time teesukoni next time nunchi fast avuthundha anni dout or else how it works
[/quote]
batch processing emo naku idea ledhu i can give you an turn around,you can create temporary tables for faster execution of reports

[siri_vennela]

[quote name='Jeedeelu' timestamp='1339006621' post='1301922520']


how r u pulling ur data...

by an sp or set of sql statements..?

if yes....okasari pampu will see emaina changes cheyocha ledho dhaniki for performance....
[/quote]

sp nunchi

[siri_vennela]

[quote name='LoveGuru' timestamp='1339006769' post='1301922541']
batch processing emo naku idea ledhu i can give you an turn around,you can create temporary tables for faster execution of reports
[/quote]

anni temp tables ee use chesthunanu

[Ranga_The_Donga]

[quote name='siri_vennela' timestamp='1339006771' post='1301922542']

sp nunchi
[/quote]


[size=4][background=transparent]
[list]
[*] [background=transparent]
Is the report doing it's own calculations on the data that is returned which could potentially take time and resources to accomplish?[/background]
[*] [background=transparent]
Is the report drawing graphs that have lots and lots of datapoints which may take longer to reproduce than a graph with a larger increment?[/background]
[*] [background=transparent]
Is the report loading images? How are the images handled? Are they embedded or linked from an outside source?[/background]
[*] [background=transparent]
Are you creating a lot of groups or drill downs which could take time on the report loading to create?[/background]
[/list] [background=transparent]
Answering these questions may start to point you in the correct direction as far as how to make your report more efficient.[/background] [/background][/size]

[LoveGuru]

[quote name='siri_vennela' timestamp='1339006771' post='1301922542']

sp nunchi
[/quote]
sp nunchi aithe sp ni fine tune chey sp run time meedha kooda depend avthundhi kdha report

[LoveGuru]

[quote name='Jeedeelu' timestamp='1339006840' post='1301922556']



[size=4][background=transparent] [/background][/size][list]
[*]
[background=transparent]Is the report doing it's own calculations on the data that is returned which could potentially take time and resources to accomplish?[/background]
[*]
[background=transparent]Is the report drawing graphs that have lots and lots of datapoints which may take longer to reproduce than a graph with a larger increment?[/background]
[*]
[background=transparent]Is the report loading images? How are the images handled? Are they embedded or linked from an outside source?[/background]
[*]
[background=transparent]Are you creating a lot of groups or drill downs which could take time on the report loading to create?[/background]
[/list]

[background=transparent]Answering these questions may start to point you in the correct direction as far as how to make your report more efficient.[/background]
[/quote]

[Ranga_The_Donga]

[quote name='siri_vennela' timestamp='1339006814' post='1301922550']

anni temp tables ee use chesthunanu
[/quote]


[list]
[*]Run the stored procedures from SSMS and view the query plans it generates.
[*]Check that the tables are indexed appropriately to speed up the queries
[*]Identify and eliminate cruft like unnecessary joins, unneeded selected columns,etc
[/list]

[siri_vennela]

mee idhariki sp pm chesthuna chusi chepara emina prob undhemo

[LoveGuru]

[quote name='Jeedeelu' timestamp='1339006936' post='1301922570']

[list]
[*]Run the stored procedures from SSMS and view the query plans it generates.
[*]Check that the tables are indexed appropriately to speed up the queries
[*]Identify and eliminate cruft like unnecessary joins, unneeded selected columns,etc
[/list]
[/quote]

Query plan ni batti sp ni fine tune chesthe solution vachinatte baa almost

[LoveGuru]

[quote name='siri_vennela' timestamp='1339007014' post='1301922580']
mee idhariki sp pm chesthuna chusi chepara emina prob undhemo
[/quote]
orrike choosi cheppadam easy kaadhu,nuvvu jedelo cheppinattu mundhi sp ni fine tune chey

[Ranga_The_Donga]

[quote name='LoveGuru' timestamp='1339007016' post='1301922581']

Query plan ni batti sp ni fine tune chesthe solution vachinatte baa almost
[/quote]

ya mostly first step cheppesthundhi......

[LoveGuru]

[quote name='Jeedeelu' timestamp='1339007097' post='1301922596']

ya mostly first step cheppesthundhi......
[/quote]
inkokati baa oka vela sql query optimizer enable chesi unte dantho sp ni fine tune cheskovadam better,kani adhi open chesthe vere users antha nethina gudda vesukovalsindhe memory antha tinesthadhi

[mtkr]