<p>Hi Cindy</p>
<p>What is the sql you are trying to run? And what version of Koha are you running. If it is timing out, its probably either not using an index that it should or it just takes longer than the webservers timeout. If so, using the scheduler to run it in the background, or getting direct access to your db would be the best way forward. </p>
<p>I've run queries against millions of biblioitems using the scheduler before.</p>
<p>Chris</p>
<p><blockquote type="cite">On 28 Oct 2010 06:56, "Cindy Weber" <<a href="mailto:cweber@scls.lib.wi.us">cweber@scls.lib.wi.us</a>> wrote:<br><br>A number of the reports we use currently require us to pull a list of the bibs that either have or don't have an OCLC number and were added during the past week. While trying to create the same report in Koha, it appears I can't run a query that large against either biblioitems.marc or biblioitems.marcxml--the only two places that appear to have the OCLC number. The report times out, even if I limit it to a single day.<br>
<br>
Does anyone have a suggestion as to how I might be able to get the report working?<br>
<br>
Thanks!<br>
Cindy<br>
<br>
--<br>
Cindy Weber <a href="mailto:cweber@scls.lib.wi.us">cweber@scls.lib.wi.us</a><br>
System Support Specialist (608)242-4710<br>
South Central Library System<br>
<br>
_______________________________________________<br>
Koha mailing list <a href="http://koha-community.org" target="_blank">http://koha-community.org</a><br>
<a href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br>
<a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
</blockquote></p>