Issue 13103

NMNH DiGIR unusably slow

13103
Reporter: lfrancke
Assignee: jlegind
Type: Task
Summary: NMNH DiGIR unusably slow
Priority: Minor
Resolution: Invalid
Status: Closed
Created: 2013-04-08 11:49:24.592
Updated: 2015-03-06 10:51:42.294
Resolved: 2015-03-06 10:51:42.27
        
Description: A request like this: http://collections.nmnh.si.edu/nmnhweb/webservices/digir.php?request=%3Crequest+xmlns%3D%22http%3A%2F%2Fdigir.net%2Fschema%2Fprotocol%2F2003%2F1.0%22%0A+++++++++xmlns%3Axsi%3D%22http%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema-instance%22%0A+++++++++xmlns%3Adwc%3D%22http%3A%2F%2Fdigir.net%2Fschema%2Fconceptual%2Fdarwin%2F2003%2F1.0%22%0A+++++++++xsi%3AschemaLocation%3D%22http%3A%2F%2Fdigir.net%2Fschema%2Fprotocol%2F2003%2F1.0+http%3A%2F%2Fdigir.sourceforge.net%2Fschema%2Fprotocol%2F2003%2F1.0%2Fdigir.xsd+http%3A%2F%2Fdigir.net%2Fschema%2Fconceptual%2Fdarwin%2F2003%2F1.0+http%3A%2F%2Fbnhm.berkeley.edu%2Fmanis%2FDwC%2Fdarwin2jrw030315.xsd%22%3E%0A++%3Cheader%3E%0A++++%3Cversion%3E1.0.0%3C%2Fversion%3E%0A++++%3CsendTime%3E2013-04-08T11%3A35%3A17%2B02%3A00%3C%2FsendTime%3E%0A++++%3Csource%3EGBIF+Crawler%3C%2Fsource%3E%0A++++%3Cdestination+resource%3D%22NMNH-VZHerps%22%3Ehttp%3A%2F%2Fcollections.nmnh.si.edu%2Fnmnhweb%2Fwebservices%2Fdigir.php%3C%2Fdestination%3E%0A++++%3Ctype%3Esearch%3C%2Ftype%3E%0A++%3C%2Fheader%3E%0A++%3Csearch%3E%0A++++%3Cfilter%3E%0A++++++%3Cand%3E%0A++++++++%3CgreaterThanOrEquals%3E%0A++++++++++%3Cdwc%3AScientificName%3EZya%3C%2Fdwc%3AScientificName%3E%0A++++++++%3C%2FgreaterThanOrEquals%3E%0A++++++++%3ClessThan%3E%0A++++++++++%3Cdwc%3AScientificName%3EZza%3C%2Fdwc%3AScientificName%3E%0A++++++++%3C%2FlessThan%3E%0A++++++%3C%2Fand%3E%0A++++%3C%2Ffilter%3E%0A++++%3Crecords+limit%3D%221000%22+start%3D%221000%22%3E%0A++++++%3Cstructure+schemaLocation%3D%22http%3A%2F%2Fbnhm.berkeley.edu%2Fmanis%2FDwC%2Fdarwin2resultfull.xsd%22%2F%3E%0A++++%3C%2Frecords%3E%0A++++%3Ccount%3Efalse%3C%2Fcount%3E%0A++%3C%2Fsearch%3E%0A%3C%2Frequest%3E%0A

Does return in 7 or so minutes with a diagnostic error messages saying that it took to long. We can't harvest these resources. Maybe a missing index?

The error message: "KE XML database server returned: 'Your search has taken too long. Please adjust your query.' in /home/emu/nmnhweb/web/webservices/lib/Provider.php on line 1052"]]>
    


Author: jlegind@gbif.org
Comment: Smithsonian moved to IPT
Created: 2015-03-06 10:51:42.291
Updated: 2015-03-06 10:51:42.291