webstagingperformancecompare.sql

/* article 1 - North Branford residents hire attorney, start GoFundMe over propane facility */
select 
x1.Site as liveSite, 
x2.Site as stageSite, 
x1.PbsTag as livePBSTag,
x2.PbsTag as stagePBSTag,
x1.RequestStr as liveRequest, 
x2.RequestStr as stage,
x1.BuildTime as liveBuildTime, 
x2.BuildTime as stageBuildTime 
from shared.dbo.CacheStorage_JRC_NH x1 (nolock) 
inner join shared.dbo.CacheStorage_JRC_NH_Stage x2 (nolock)
on x1.Site = x2.Site and x1.RequestStr = x2.RequestStr and x1.PbsTag = x2.PbsTag
where x1.Site='nh' and x2.RequestStr='/apps/pbcs.dll/article?avis=NH&date=20141021&category=NEWS&lopenr=141029884&Ref=AR&profile=1030370&nocache=1'


/* article 2 - Opinion: First sex, then sexting and now sext education */
select 
x1.Site as liveSite, 
x2.Site as stageSite, 
x1.PbsTag as livePBSTag,
x2.PbsTag as stagePBSTag,
x1.RequestStr as liveRequest, 
x2.RequestStr as stage,
x1.BuildTime as liveBuildTime, 
x2.BuildTime as stageBuildTime 
from shared.dbo.CacheStorage_JRC_NH x1 (nolock) 
inner join shared.dbo.CacheStorage_JRC_NH_Stage x2 (nolock)
on x1.Site = x2.Site and x1.RequestStr = x2.RequestStr and x1.PbsTag = x2.PbsTag
where x1.Site='nh' and x2.RequestStr='/apps/pbcs.dll/article?avis=NH&date=20141022&category=NEWS&lopenr=141029868&Ref=AR&nocache=1&profile=1033652&nocache=1'



/* section 1 - apps/pbcs.dll/section?category=&profile=400093&nocache=1 */
select 
x1.Site as liveSite, 
x2.Site as stageSite, 
x1.PbsTag as livePBSTag,
x2.PbsTag as stagePBSTag,
x1.RequestStr as liveRequest, 
x2.RequestStr as stage,
x1.BuildTime as liveBuildTime, 
x2.BuildTime as stageBuildTime 
from shared.dbo.CacheStorage_JRC_NH x1 (nolock) 
inner join shared.dbo.CacheStorage_JRC_NH_Stage x2 (nolock)
on x1.Site = x2.Site and x1.RequestStr = x2.RequestStr and x1.PbsTag = x2.PbsTag
where x1.Site='nh' and x2.RequestStr='/apps/pbcs.dll/section?category=&profile=400093&nocache=1'


/* section 2 - News */
select 
x1.Site as liveSite, 
x2.Site as stageSite, 
x1.PbsTag as livePBSTag,
x2.PbsTag as stagePBSTag,
x1.RequestStr as liveRequest, 
x2.RequestStr as stage,
x1.BuildTime as liveBuildTime, 
x2.BuildTime as stageBuildTime 
from shared.dbo.CacheStorage_JRC_NH x1 (nolock) 
inner join shared.dbo.CacheStorage_JRC_NH_Stage x2 (nolock)
on x1.Site = x2.Site and x1.RequestStr = x2.RequestStr and x1.PbsTag = x2.PbsTag
where x1.Site='nh' and x2.RequestStr='/apps/pbcs.dll/section?category=&profile=4000931&nocache=1'

/*frontpage*/
select 
x1.Site as liveSite, 
x2.Site as stageSite, 
x1.PbsTag as livePBSTag,
x2.PbsTag as stagePBSTag,
x1.RequestStr as liveRequest, 
x2.RequestStr as stage,
x1.BuildTime as liveBuildTime, 
x2.BuildTime as stageBuildTime 
from shared.dbo.CacheStorage_JRC_NH x1 (nolock) 
inner join shared.dbo.CacheStorage_JRC_NH_Stage x2 (nolock)
on x1.Site = x2.Site and x1.RequestStr = x2.RequestStr and x1.PbsTag = x2.PbsTag
where x1.Site='nh' and x2.RequestStr='/apps/pbcs.dll/section?template=frontpage&profile=3020867&nocache=1'