Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kudzen
Starting Member
12 Posts |
 Posted - 2012-07-08 : 09:46:16
|
| Hi there folks,One of my reports are being executed more than 1700times a day and each execution requests on average 7329 milliseconds.All the parameters are the same except the campaignID that identifies wich campaign i'm looking for.There is any way Snapshots can help me with this multiple live requests? I think using cache is not a good idea, because as the parameter changes, a new cache version would be created and that is not i want.Am i right?Thanks for your help. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-07-08 : 16:25:03
|
| are list of campaign ids same? or cant they be determined at runtime?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
kudzen
Starting Member
12 Posts |
Posted - 2012-07-09 : 04:37:35
|
Hi there.If the campaigns are always the same, what could help me in this case?We can have new campaignIDs everyday, so each day the report can be extracting more versions than the last time executed.Thanksquote:
Originally posted by visakh16
are list of campaign ids same? or cant they be determined at runtime?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
|
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-07-09 : 09:59:33
|
| why not create multiple copies of report for each campaign and get it cached to get individual snapshots.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
kudzen
Starting Member
12 Posts |
Posted - 2012-07-09 : 10:09:05
|
As i said, there is thousands of campaigns. Creating individual copies of the report is not a option lol. Could you creat 1700 individual reports? :quote:
Originally posted by visakh16
why not create multiple copies of report for each campaign and get it cached to get individual snapshots.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
|
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-07-09 : 11:04:13
|
| oh ok...didnt realise there are 1700 campaignsthen use a data driven subscription and have a table populated with these 1700 campaign ids------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
kudzen
Starting Member
12 Posts |
Posted - 2012-07-09 : 11:21:32
|
I never heard about data driven subscription. Do you know any good online example ? Thanks for your help quote:
Originally posted by visakh16
oh ok...didnt realise there are 1700 campaignsthen use a data driven subscription and have a table populated with these 1700 campaign ids------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
|
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-07-09 : 11:34:46
|
| http://msdn.microsoft.com/en-us/library/aa237461(v=sql.80).aspx------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Report with thousands of daily executions