[Koha-bugs] [Bug 26356] Search by first and last name takes a long time

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26356

--- Comment #10 from David Cook <dcook at prosentient.com.au> ---
I can't replicate your issue using the attachment provided.

First, the attachment is invalid SQL. It looks like this is only a fragment of
the actual SQL being run (plus it contains a number of syntax errors).

Second, when I run the corrected SQL fragment directly against the database, I
get a response in about .0131 seconds. So I don't think it's the SQL. 

I think there's probably more going on with your data and your server than is
made clear in this issue report. You may have a genuine issue, but it's not
reproducible or even clear what it is at this point. 

As Owen suggested earlier, I think your issue qualifies as a support issue
rather than a bug report. 

I'd say you probably need to look at getting a paid support provider or dig
into the code yourself. 

Alternatively, you may try to reproduce your own issue, and break down the
steps to make it clearer to us what might be happening. 

For instance, with a freshly installed Koha, does this happen after importing
50,000 borrowers (and making no other changes)? How are those borrowers
imported? Can you share the dataset so that someone else more technical can try
to reproduce the problem in a technical environment?

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.