[Koha] Problem querying for OCLC

[Chris Cormack]

Hi Cindy

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.

I've run queries against millions of biblioitems using the scheduler before.

Chris

On 28 Oct 2010 06:56, "Cindy Weber" <cweber at scls.lib.wi.us> wrote:

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.

Does anyone have a suggestion as to how I might be able to get the report
working?

Thanks!
Cindy

--
Cindy Weber                       cweber at scls.lib.wi.us
System Support Specialist         (608)242-4710
South Central Library System

_______________________________________________
Koha mailing list  http://koha-community.org
Koha at lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20101028/4561dcff/attachment.htm