Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Vincent Lui 11 posts 31 karma points
    May 05, 2011 @ 03:43
    Vincent Lui
    0

    Expensive Query

    I have around 2000 records to export and this is the error message I got.

  • Richard Soeteman 4035 posts 12842 karma points MVP
    May 07, 2011 @ 06:09
    Richard Soeteman
    0

    Hi Vincent,

    This error is related to sqlserver and I've been googling for a solution and think it's related to your timeout settings. You can set the query timout to 0 in the management console if you have access to it. Right click on the sqlserver instance and select properties. Then set the timout to 0.

    Hope this helps you for now, I'm also very curious about the amount of member properties since you shouldn't have got this error in the first place and I never seen this error before with 10.000 + records.

    Please let me know if the timout setting fixed the error.

    Cheers,

    Richard

  • Vincent Lui 11 posts 31 karma points
    May 09, 2011 @ 04:00
    Vincent Lui
    0

    Thanks for your help, unfortunately the site is hosted in a shared hosting environment, and I do not have access to that setting at all. At the moment it's set to 300 seconds.

  • Richard Soeteman 4035 posts 12842 karma points MVP
    May 09, 2011 @ 09:24
    Richard Soeteman
    0

    I think I can set teh timout in code as well, so I'll send you an update later today. I'm a little worried about the performance on the shared hosting server when it says it needs more than 300 seconds to complete for just 2000 members. How many properties did you define?

     

  • Vincent Lui 11 posts 31 karma points
    May 09, 2011 @ 09:29
    Vincent Lui
    0

    18 fields altogether including the default ones.

  • Richard Soeteman 4035 posts 12842 karma points MVP
    May 09, 2011 @ 10:46
    Richard Soeteman
    0

    Hi Vincent,

    I just send you the hotfix, please let me know if it solved your issue.

    Cheers,

    Richard

Please Sign in or register to post replies

Write your reply to:

Draft