[bksvol-discuss] Re: Update on Checkout Queue Problem When Showing 100 Records

  • From: "Evan Reese" <mentat1@xxxxxxxxxxxxxx>
  • To: <bksvol-discuss@xxxxxxxxxxxxx>
  • Date: Mon, 7 Feb 2011 20:45:26 -0500

I remember when we could see the whole list of more than three hundred books at 
once, and it didn't take long to show up either. Maybe what's really needed is 
new hardware?

Evan

  ----- Original Message ----- 
  From: Sue Stevens 
  To: bksvol-discuss@xxxxxxxxxxxxx 
  Sent: Monday, February 07, 2011 8:19 PM
  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 
    To: 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
    Version: 10.0.1204 / Virus Database: 1435/3428 - Release Date: 02/07/11

Other related posts: