Hi Sue, Well, a four minute timeout gives double the time for the page to load so that's from bad to better by 100%. The engineers are convinced that they have a good final solution available. It's just that it will take concentrated coding to implement it and there is no time on their collective schedules in the foreseeable future. Scott From: Sue Stevens <siss52@xxxxxxxxxxxx<mailto:siss52@xxxxxxxxxxxx>> Reply-To: "bksvol-discuss@xxxxxxxxxxxxx<mailto:bksvol-discuss@xxxxxxxxxxxxx>" <bksvol-discuss@xxxxxxxxxxxxx<mailto:bksvol-discuss@xxxxxxxxxxxxx>> Date: Mon, 7 Feb 2011 17:19:49 -0800 To: "bksvol-discuss@xxxxxxxxxxxxx<mailto:bksvol-discuss@xxxxxxxxxxxxx>" <bksvol-discuss@xxxxxxxxxxxxx<mailto:bksvol-discuss@xxxxxxxxxxxxx>> Subject: [bksvol-discuss] Re: Update on Checkout Queue Problem When Showing 100 Records Ah, for the good old days! (smile) It used to be fine to have 100 per page, Scott. So are things going from bad to worse? And wow! A four-minute timeout? It would take ages to go through the whole list. Sue S. ----- Original Message ----- From: Scott Rains<mailto:scottr@xxxxxxxxxxxx> To: bksvol-discuss@xxxxxxxxxxxxx<mailto:bksvol-discuss@xxxxxxxxxxxxx> Sent: Monday, February 07, 2011 4:17 PM Subject: [bksvol-discuss] Update on Checkout Queue Problem When Showing 100 Records The short answer to why we have trouble when we try to show 100 records in the Checkout Queue is that it takes too long and the server shuts down the process. From one of Benetech's Engineers comes the following with more detail: It turns out this is a known issue for many volunteer queues. The database query that supplies the book lists is a downright beast, and taming it is not possible in the short term. We have a new search engine that can be used to update the volunteer queues, though that work has yet to be scheduled. Bottom-line: when a volunteer views the queues with 100 records to a page, the query takes nearly 3 minutes. Unfortunately, there is a 2-minute timeout on the server and the volunteers wait 2 minutes only to get an error message. So short-term workaround is to advise volunteers to use smaller page sizes, like 25 or 50 records to a page. A medium-term workaround is being worked on -- we are going to increase the timeout value on the volunteer pages to 4 minutes. The long-term fix is to switch to [a new search method but we] don't have any sense of when that will be put into place. Scott Rains ________________________________ No virus found in this message. Checked by AVG - www.avg.com<http://www.avg.com> Version: 10.0.1204 / Virus Database: 1435/3428 - Release Date: 02/07/11