^NyAw^
4th July 2013, 10:47
Hi,
I'm developing an application that stores images into a MySQL database. It takes images from a camera, inspects the image and save the "detected" zones of the image as little images into the database. To speedup the process it writes the image as the direct camera buffer(not JPG,BMP...) and the width and height of the images to be able to show them when needed. The camera images are 8000x3500px gray(one byte per pixel) and the "detection" images can be 1000x3500px that is 3.3MB.
The problem that I'm getting is the speed of the execution of the SQL insertion.
Now I'm using the multiple row insertion way also with a transaction.
Inserting 42 "detection" images takes from 350ms to 2800ms on different executions.
Have you any idea how to improve this?
Thanks,
I'm developing an application that stores images into a MySQL database. It takes images from a camera, inspects the image and save the "detected" zones of the image as little images into the database. To speedup the process it writes the image as the direct camera buffer(not JPG,BMP...) and the width and height of the images to be able to show them when needed. The camera images are 8000x3500px gray(one byte per pixel) and the "detection" images can be 1000x3500px that is 3.3MB.
The problem that I'm getting is the speed of the execution of the SQL insertion.
Now I'm using the multiple row insertion way also with a transaction.
Inserting 42 "detection" images takes from 350ms to 2800ms on different executions.
Have you any idea how to improve this?
Thanks,