[Koha] Checkout and other tasks takes a while

Thommy M. Malmström thommy.m.malmstrom at gmail.com
Sat Feb 19 03:34:01 NZDT 2011


2011/2/18 Tomas Cohen Arazi <tomascohen at gmail.com>:
> 2011/2/18 Thommy M. Malmström <thommy.m.malmstrom at gmail.com>:
>> 2011/2/18 Tomas Cohen Arazi <tomascohen at gmail.com>:
>>> 2011/2/18 Thommy M. Malmström <thommy.m.malmstrom at gmail.com>:
>>>>
>>>> What I find is that a checkout takes 35 seconds for a single item and
>>>> my question is what part of the spec is most important for better
>>>> performance?
>>
>> With checkout I mean the time from I hit the button "Check Out" to the
>> right of where I entered the bar code until the web page is updated.
>
> Less than a second here. We have extra latency because we use an
> external (networked) MySQL server.
> I think your notebook may be using swap (then trashing) and it is
> probable that your MySQL is not tuned enough to have all the tables of
> your database in the RAM (innodb pool stuff).

Well, as it is just a test there is only 6 items in it so I think it
should fit in 2 GB.

If I access the DB through phpMyAdmin and change say a character in a
title in the biblio table, it takes less than 1 second. So the MySQL
is fast from what I can tell. It actually says "Query took 0.0001
sec". So, looks to me as if it the perl scripts, but how to tell and
what to do?


/Thommy M.


More information about the Koha mailing list