I’ve been importing a solution over the years into a servoy server (190 so far). It has grown to incorporate a mysql database for which I have the latest mysql driver etc…
When importing the solution, it takes ever longer to complete and is now beginning to fail (timeout I guess) although not every time. It causes problems because the database becomes unresponsive if it hasn’t imported properly.
An import can take 8-10 minutes now. Memory on the server is 256MB.
I’d be grateful for any ideas on how to speed things up…
Do you mean you have 190 releases? Maybe then it’s the time to do a clean import…
BTW: the time it takes to import depends on many things but of course on the size of your solution (number of forms etc). Our solution takes about 2 hours to import.
Yeah, 190 releases. Does it make a difference? I didn’t think it did.
There are about 140 forms.
The trouble is that it didn’t seem to take this long before, and the solution has always been fairly big… I have a feeling that it slowed down after adding a MySQL server to the mix, but that was a long time ago and it has just dramatically slowed down today (so far 1 hour for import) The server doesn’t seem to actually be doing anything (cpu % is low)…
Sometimes I have seen the repository import getting stuck in a transaction. Could you check mySql for locks?
Yeah, 190 releases. Does it make a difference? I didn’t think it did.
You can ask the Servoyans about this. But I would say it does. The repository is just a database and all elements, methods etc. have to be queried from there. The bigger the table, the longer it takes.