[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
>> 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?
More information about the Koha