|
From: tech.vronk <te...@vr...> - 2013-06-11 13:23:24
|
Am 11.06.2013 15:09, schrieb tech.vronk: > Am 11.06.2013 14:08, schrieb Dannes Wessels: >> as I said, try to write queries that are as selective as possible in >> an early phase ; this will limit memory usage. > I have just the collection to search in and an index-based search, that > returns me one element: > > $data-collection//cmd:MdSelfLink[. eq > 'oai:ufal-point.mff.cuni.cz:11858/00-097C-0000-0001-48F2-1']/ancestor-or-self::cmd:CMD > > i believe this is the most selective i can get. but admittedly, I am not sure, that it is those queries, that cause the issue. They are just the ones, that according to the access-logs the googlebot keeps requesting. Can anyone point me to How can I track down the offending query. I ran the query profiler, but it does not give me information about the memory usage. Although it seems to show, that the collection()-function is quite costly (in terms of elapsed time) thank you matej |