How to speed up deployment time of SQL reports into SharePoint site?

Hello there Experts,

I have a SQL Reporting Server running in integrated mode inside a SharePoint portal.

My problem is that whenever I deploy reports from my local machine to SharePoint server, it takes very long time to deploy, whereas if I deploy to my local machine (//localhost/reportserver) , it's done very fast.

Any ideas as to what could be the problem with the server?

I know this is a very generic question, and there are probably hundreds of reasons that may cause the slow response. I was hoping though that you through some ideas on what could be the main contributor to the slow deployment.

Thank you so much in anticipation,

Hani
MehawitchiAsked:
Who is Participating?
 
Ted BouskillSenior Software DeveloperCommented:
You links look fine.  It's probably simply the added overhead of Sharepoint.  We used SQL Reporting Services integration for awhile then disabled it.  We found there were too many performance problems.
0
 
Ted BouskillSenior Software DeveloperCommented:
What syntax are you using to deploy locally and to Sharepoint?
0
 
MehawitchiAuthor Commented:
Thanks for your help tedbilly. I hope I understand your question correctly

Target URL for the local deployment is:
http://localhost/reportserver

Target URL for SharePoint server:
http://marina:999/RC2

For deployment, I right-click my project and click 'Deploy' from the menu

Is that what you've asked for?

Thanks again,
Hani
0
 
MehawitchiAuthor Commented:
Did not get a solution or possible answer
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.