[Koha] Introduction and incredibly slow searches

[Randall Rowe]

Is top showing that you really are using the 4 CPUs available?
 Pressing the numeral 1 will toggle multiple CPU lines in top.
 To display the CPU a program is running on first press 'f' then 'J' to add the CPU in use column (P) to top's display.
 What is your load average?

 Does 'uname -a' show that you're running the SMP version of Debian?

Randy Rowe
 Lincoln City Libraries I.T.

 -----Original Message-----
 From: "IBS Computer Support" <ibssupport at Colorado.EDU>
 Sent 10/27/2011 10:35:36 AM
 To: "Randall Rowe" <r.rowe at lincolnlibraries.org>, "ibs computer support" <ibssupport at colorado.edu>, "koha at lists.katipo.co.nz" <koha at lists.katipo.co.nz>, "Chris Cormack" <chris at bigballofwax.co.nz>
 Subject: RE: [Koha] Introduction and incredibly slow searches

To answer the questions from Randy and Chris and add more detail.  

Koha was installed following these directions: 

http://wiki.koha-community.org/wiki/Koha_3.2_on_Debian_Squeeze 

and the install notes towards the bottom of this page starting at “Step: Install Koha” 

http://wiki.koha-community.org/wiki/Setting_Up_Koha_in_Virtual_Environment_%2B_Using_That_as_a_Development_Environment 

The server is a virtual machine on ESXi v4.1. 

It is the only virtual machine on the host ESXi server.  

It has 4 CPUs dedicated to it, as well as 1GB RAM 

Watching “top” it doesn’t use enough RAM to get to need to swap 

Top shows: 

opac-search.pl  for however many tabs I open from the initial search screen 

followed up with  

opac-detail.pl 

ping requests are <1ms 

Machines are on the same physical network, just different subnets.  

Thanks, 

Jeremy 

From: Randall Rowe [mailto:r.rowe at lincolnlibraries.org] 
 Sent: Thursday, October 27, 2011 5:47 AM
 To: ibs computer support; koha at lists.katipo.co.nz
 Subject: Re: [Koha] Introduction and incredibly slow searches   

What version of koha are you running? Where did you download it?
 I noticed that you went "through the examples on liblime.com".
 If that is where you downloaded koha then you are not running the community version of koha.

 Regardless of what koha you are running, check the output of the command "top".
 That should give you an idea of what is taking up time in the process.

 Are all these machines on a local network? Is ping response between the machines reasonable? 

Randy Rowe
 Lincoln City Libraries I.T.

 -----Original Message-----
 From: "IBS Computer Support" <ibssupport at Colorado.EDU>
 Sent 10/26/2011 3:47:54 PM
 To: "koha at lists.katipo.co.nz" <koha at lists.katipo.co.nz>
 Subject: [Koha] Introduction and incredibly slow searches 

Hello Everyone,  

New to the list, new to Koha, increasingly frustrated :} 

I’ve built a koha server for our in-house library which seems to have gone over fine but I’m having issues with incredibly slow search response.  

I’m running the latest stable koha-common 3.6 (updated a few minutes ago) on Debian 6.0.3.  

I have successfully entered in a record for one book. When I search from the initial koha page it takes ~4 seconds to find this item. Then once the item has loaded if I click one of the links for a searchable item (author, details, etc.) it takes ~4-5 seconds for it to load. When I open all of these options at the same time in new tabs it takes forever. It seems to be an almost linear increase in the time it takes for the searches to complete. Also, each new tab running a different search will continue to run until one has finished, then once one has finished another will go. This process is ~4 seconds for each search. Seems like all searches are in a very slow queue. 

So for this example book I have in the system there are 7 items that are searchable. If I go through and open each in a separate tab the total process for all of this is 30+seconds.  

I tried running a webserver load test with just 10 users clicking on a different link each time the new page loaded and it failed horribly with an average page load wait of 50 seconds 

I really don’t know where to go to look for what’s causing this. 

When I use the “browse by author or subject search”, the authority search results page comes back in less than 2 seconds. Though it does show 0 biblios records (no clue what that is) 

I’ve gone through many example sites found here: 

http://www.liblime.com/demos 

And they don’t seem to have this same issue.  

Any help. Thought, direction would be greatly appreciated! 

Thanks, 

Jeremy 

_______________________________________________ 

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/20111027/15a43592/attachment.html>