Hi, I've been loading pictures into MySQL 5.6 database for years ans recently realized that loading a 60k image ends up being stored as 600k in the database and when I extract the image, it comes out as 600k. My method required loading the image into an image control linked to file and then using hAdd or hModify. I've experimented and realized that if I use hLinkMemo, I get the proper size being loaded. Does this mean the image control modifies the image in some way before saving it? Any ideas on whats taking place in the background? Thanks and regards issah https://www.wxforum.info/read.php?27131,797739,797739#msg-797739 Tue, 19 May 2026 03:26:27 +0200 Phorum 5.2.23 https://www.wxforum.info/read.php?27131,797739,797747#msg-797747 https://www.wxforum.info/read.php?27131,797739,797747#msg-797747
Thanks. This is new to me though when I realized this, I suspected the image control was doing some shenanigans behind the scenes. Using hLinkMemo all the way now.

issah]]> mixgh WinDev Forum Sat, 20 Jan 2024 19:30:35 +0100 https://www.wxforum.info/read.php?27131,797739,797740#msg-797740 https://www.wxforum.info/read.php?27131,797739,797740#msg-797740
So if your image control is 800*600, you get an image containing 480000 pixels, EVEN if your original image was 400*300...

So saving that directly to a file will change the content, yes

On top of that (but I haven't tested that part), the image control itself is probably considered RAW format in your case, so even if you reiszed the control to the corrct size for your image before loading the image file in it, it would STILL probably be much bigger with your method, as there is no INPLIED dsauveimagejpg with a percentage of compression.]]> Argus WinDev Forum Thu, 18 Jan 2024 08:08:38 +0100 https://www.wxforum.info/read.php?27131,797739,797739#msg-797739 https://www.wxforum.info/read.php?27131,797739,797739#msg-797739
I've been loading pictures into MySQL 5.6 database for years ans recently realized that loading a 60k image ends up being stored as 600k in the database and when I extract the image, it comes out as 600k. My method required loading the image into an image control linked to file and then using hAdd or hModify. I've experimented and realized that if I use hLinkMemo, I get the proper size being loaded. Does this mean the image control modifies the image in some way before saving it? Any ideas on whats taking place in the background?

Thanks and regards

issah]]> mixgh WinDev Forum Thu, 18 Jan 2024 03:21:18 +0100