Copied to clipboard

Flag this post as spam?

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


  • Tom 23 posts 79 karma points
    May 03, 2012 @ 16:42
    Tom
    0

    Listing lots of nodes - timeout.

    Recently ran into a problem where we needed to mass delete lots of unpublished nodes (over 1500), but the package would timeout - adding connection timeout to the connection string in web.config did not work, but adding

    sqlCommand.CommandTimeout = 1000000;

    after

    SqlCommand sqlCommand = new SqlCommand(sb.ToString(), sqlConnection);

    fixed the timeout (inspired by something I noticed in the memberexport forum), but also needed to add 

    <add key="aspnet:MaxHttpCollectionKeys" value="2000"/>

    to webconfig to enable deleting of all the nodes at once, also added a new amount to the dropdown to allow us to load all the items on one page so we wouldnt have to page through lots of pages!

    Just thought I would put this here so if anyone else has the same problem, they might be able to do the same :)

  • Jay 425 posts 652 karma points
    Jun 23, 2015 @ 17:02
    Jay
    0

    Hi Tom,

    Having the same issues with many nodes.

    Where do you add the below to?

    sqlCommand.CommandTimeout = 1000000;
    

    thanks

Please Sign in or register to post replies

Write your reply to:

Draft