|
Hi all, we have a Fedora installation 3.4.2 with Mulgara embedded. It is loaded with about seventy thousands of objects with various datastreams. When PROAI makes its periodic query to update its data using itql with time ranges (before, after), the query does not answer and results in timeout (also more than one hour). We have tried the same query also in the online form with the same results. There is much log but only of info level (no errors). But if we avoid to use the time limits the response is ok and fast. This is an eaxmple of query done by PROAI, which results in timeout: select $item $itemID $date $state from <rmi://localhost/fedora#ri> where $item <http://www.openarchives.org/OAI/2.0/itemID> $itemID and $item <info:fedora/fedora-system:def/model#state> $state and $item <info:fedora/fedora-system:def/view#disseminates> $diss and $diss <info:fedora/fedora-system:def/view#disseminationType> <info:fedora/*/pico> and $item <info:fedora/fedora-system:def/view#lastModifiedDate> $date and $date <http://mulgara.org/mulgara#after> '2012-11-03T08:53:48.559Z'^^<http://www.w3.org/2001/XMLSchema#dateTime> in <rmi://localhost/fedora#xsd> and $date <http://mulgara.org/mulgara#before> '2012-11-04T08:53:48.559Z'^^<http://www.w3.org/2001/XMLSchema#dateTime> in <rmi://localhost/fedora#xsd> This is an eaxmple of query which is ok: select $item $itemID $date $state from <rmi://localhost/fedora#ri> where $item <http://www.openarchives.org/OAI/2.0/itemID> $itemID and $item <info:fedora/fedora-system:def/model#state> $state and $item <info:fedora/fedora-system:def/view#disseminates> $diss and $diss <info:fedora/fedora-system:def/view#disseminationType> <info:fedora/*/pico> and $item <info:fedora/fedora-system:def/view#lastModifiedDate> $date order by $itemID asc We have seen in forum that similar problems where present in previous versions of Fedora, but the problems seem almost equal (for example Fedora-commons-users] Fedora Resource Index Query Service veryslow). Thanks for every response, Luca |
------------------------------------------------------------------------------ LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial Remotely access PCs and mobile devices and provide instant support Improve your efficiency, and focus on delivering more value-add services Discover what IT Professionals Know. Rescue delivers http://p.sf.net/sfu/logmein_12329d2d
_______________________________________________ Fedora-commons-developers mailing list Fedora-commons-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/fedora-commons-developers
