Post reply

Calling a RPC 7 times slower that script

  • December 14, 2007 at 1:13 am

    #179878

    Good day

    I do a RPC for crystalreports and it runs 7 times slower than running the script. Is there any settings I can change to improve the performance?

    I am running crystalreports on it's own server. The sp creates various temp tables from the server it runs on and a linked server.

    thanks

    Tinus

  • December 14, 2007 at 5:59 am

    #760180

    you'll have to examine the query plan - there's just too many possible causes here, the most likely being the linked server not doing optimal joins ( if you're unlucky all data is pulled from one server to the other prior to join/select or whatever ) cross server joins don't usually work too well.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • December 14, 2007 at 6:21 am

    #760197

    Thanks for the reply - Why then does it run OK if only the script is run from the same server. Can I send through the script so you can see what I mean. Maybe I am not explaining the problem correctly?

  • December 14, 2007 at 10:34 am

    #760366

    even a script would be tricky - sorry, but this sort of problem needs to be resolved in place. I'd need to see the source data and volumes too - try comparing your query plans that should sort it out.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply