[Koha-devel] Massime import slow (around 800 record in 1 minute).

[MJ Ray]

Tajoli Zeno wrote:
> I'm finding a quite slow import into a Koha DB with bulkmarcimport.pl.
> It imports only 800 record in 1 minute.
> With top:
> 
> 90-95 % bulkmarcimport.pl
> 5 % mysql
> 
> apache, zebra, indexing are down.

Down the list rather than down=not-running, I hope!

[...]
> Do you have suggestions on how to speed the import ?

Not without stepping through the code in a debugger or using a profiler
on it.  Is the bulkmarcimport a one-time process (it'll be quicker to
wait for it, rather than to spend lots of time speeding it up) or
something you do often?

Imports aren't the speediest task but I've not seen it that slow. If you
could to make the import file available somehow (please not email
attachment and probably not public unless you "own" all the data in it),
maybe someone on IRC or otherwise can try it on a test server for you
and how fast it goes, or spot any obvious problems with the data.

Regards,
-- 
MJ Ray (slef), member of www.software.coop, a for-more-than-profit co-op
http://koha-community.org supporter, web and library systems developer.
In My Opinion Only: see http://mjr.towers.org.uk/email.html
Available for hire (including development) at http://www.software.coop/