Email list export not completing

[jmestep]

We upgraded a site that is on another hoster and the site has about 5900 users in the email list. The page to export the list never completes. I have added a context.Server.ScriptTimeout in the ExportList.ashx and have suggested a feature that the merchant has an option to export only the email address instead of the entire user address. Is there anything else easy that I can do? I can't adjust anything on the server.
Thanks

[Katie]

Hi Judy,

I reported this to development and asked for a work-around until we can enhance the feature with some export options.

It might take a couple days for something to happen, as we're a little behind schedule right now.

Thanks

[jmestep]

Thanks, Katie.

[Naveed]

The export email list feature was implemented under ~/admin/marketing/email/ExportList.ashx file. It was loading all email list users in memory before starting the export and thus causing the performance issue if there are very large number of users associated. We have updated the export email list implementation to load 500 records at a time. Updated "ExportList.ashx" file is attached, I hope it will solve the issue. Unzip the file and replace the old file at "~/Admin/Marketing/Email/ExportList.ashx".

[jmestep]

Thanks, I will put it on the client's site.

[jmestep]

I still got a timeout error on this one. They have 5900 list members. I'm sorry, but this isn't on our servers so there isn't much we can do with it.

[Katie]

Hi Judy,

She contacted me yesterday about this. I don't understand why it's still no working for her. The new code should be caching 500 at a time. I asked where she hosted and if it was on a shared server. i also asked her to try it during a non-peak time of day, like early AM. We'll see...

If you did have access to the server, are there any settings that you can modify to help with long running queries?

Thanks,
Katie

[jmestep]

We don't have access to the server and the hoster did suggest a few things, but I believed I researched them and it didn't seem like a good idea or didn't apply in this case. Below is what they suggested.

1) In the web.config, at the end of the connection string the following can
be added.

Connect Timeout=0

2) For data adapter

.SelectCommand.CommandTimeout = 0;
3) For command object.
.CommandTimeout = 0;