Image insert are too slow. Databse performance too poor when using MySQL/MariaDB

General
21

Hi Alain,

Sorry I didn’t see your message earlier.

We will try to test it today, and I’ll let you know.

Best regards,

Cedric.

22

Hi @csimon3

Any feedback to my last message ? I’d like to close that development branch and merge in the mainline if it appears it is useful.

Thanks for your feedback

Alain.

23

Hi Alain,

Yes, my developper had it in its todo list for this week and I can see he made it yesterday, as per it’s documentation of the case in our Jira system.

While before it took various seconds per image to remove, with the new procedure studies of 2,000 images are removed in 7 seconds (total time).

So I can confirm the procedure is working well and give a huge speed and resources gain.

We also verified all images were actually removed, and new study upload continue working well.

We only tested it for MySQL, but I am pretty sure Postgres would benefit a similar procedure (selecting images using cursors rather than selecting all images in one SQL).

Pleas let us know in what version of the MySQL plugin this would be implemented.

Have a very nice day,

Cedric.

24

Hi Cédric,

Thanks for your feedback.
I will soon (hopefully next week) release MySQL 5.2 with this fix.

To me, PostgreSQL is not affected by the same issue: it has never been observed and the code is completely different.

Best regards,

Alain

1 Like