CloneDB - Optimization

Moderator: crythias

Post Reply
nx8r
Znuny newbie
Posts: 1
Joined: 19 Apr 2018, 20:33
Znuny Version: 3.3.13
Real Name: Derpino

CloneDB - Optimization

Post by nx8r »

Hi Guys,

I'm using OTRS 3.3.13 and CloneDB extension v.1.0.14. Recently I want to move from a Windows Server with MSSQL to Debian with postgresql and upgrade it to the newest version from OTRS. It seems the extension is working pretty well, beside that its transfering 1000 inserts per tick into the target database.

Is it possible to increase the inserts to like 10000 inserts per tick? The reason I'm asking is that in some tables we have around 300000 rows and it takes around four to five hours to migrate the whole database (not talking about the files) and I think we could speed it up a lot. I reviewed the *.pm files but can't locate the code where it "limits" the inserts. Any tipps?

Cheers,
nx8r
Post Reply