pcsoft.us.windevCopyright 2026, PC SOFT20 Jan 2015 18:28:00 Z16 Jan 2015 16:50:00 ZHello, i ve created programs in the past where i have saved images directly into the datafile. But they seem to slow the database down a ridiculous amount, even when ive only had about 5 thumbnail pictures am i doing something wrong? because of this ive been saving the paths and storing the images elsewhere, however i ve started a new project (WB18) that requires quite a few images linked to records, i know i can still create paths and do it as i have been, but i would prefer on this particular project to store them in the database. has anyone had success storing lots of images in a database without a massive dent in its performance? thanks iso30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49892-images-stored-hypersql-database/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49892-images-stored-hypersql-database-49974/read.awp20 Jan 2015 18:28:00 ZThanks Fabrice. Now I understand and got it.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49892-images-stored-hypersql-database-49974/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49892-images-stored-hypersql-database-49974/read.awpimages stored in hypersql databaseguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49892-images-stored-hypersql-database-49956/read.awp20 Jan 2015 12:45:00 ZHi, WinDev has zip compression capabillities, check out ZipCreate etc. in doc. Cheers Tor-Bjarnehttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49892-images-stored-hypersql-database-49956/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49892-images-stored-hypersql-database-49956/read.awpimages stored in hypersql databaseguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49892-images-stored-hypersql-database-49952/read.awp20 Jan 2015 12:00:00 ZI ve been doing some testing putting them in a separate table and it seems to be all ok, so thanks for your help on this. Also F…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49892-images-stored-hypersql-database-49952/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49892-images-stored-hypersql-database-49952/read.awpimages stored in hypersql databaseguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49892-images-stored-hypersql-database-49941/read.awp19 Jan 2015 21:47:00 ZHi Luis no, I means that they CAN be in a separate table, in order to avoid any kind of error when using a query... If you…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49892-images-stored-hypersql-database-49941/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49892-images-stored-hypersql-database-49941/read.awpimages stored in hypersql databaseguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49892-images-stored-hypersql-database-49935/read.awp19 Jan 2015 18:10:00 ZFabrice, Do you mean that "blobs should be in a separate table" as Iso stated? Can you explain more the "Select" and how can …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49892-images-stored-hypersql-database-49935/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49892-images-stored-hypersql-database-49935/read.awpimages stored in hypersql databaseguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49892-images-stored-hypersql-database-49929/read.awp19 Jan 2015 14:18:00 ZI am not saying that you have to have your images and video in a separate file, although you CAN do that I am saying that you…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49892-images-stored-hypersql-database-49929/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49892-images-stored-hypersql-database-49929/read.awpimages stored in hypersql databaseguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49892-images-stored-hypersql-database-49928/read.awp19 Jan 2015 14:00:00 ZIso, I just defined 2 or 3 thumbnails in the analysis and that's it. Whenever I add an image, the hfsql engine creates the t…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49892-images-stored-hypersql-database-49928/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49892-images-stored-hypersql-database-49928/read.awpimages stored in hypersql databaseguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49892-images-stored-hypersql-database-49923/read.awp19 Jan 2015 12:08:00 ZHi, Thanks Fabrice maybe thats part of the problem. Are you saying the images (and videos which i didnt even know i could sto…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49892-images-stored-hypersql-database-49923/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49892-images-stored-hypersql-database-49923/read.awpimages stored in hypersql databaseguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49892-images-stored-hypersql-database-49897/read.awp16 Jan 2015 17:07:00 ZHi I have a 8GB+ DB where about 7GB are blobs (images and videos) I have ZERO problem, it's fast and nothing changes when I …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49892-images-stored-hypersql-database-49897/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49892-images-stored-hypersql-database-49897/read.awpimages stored in hypersql databaseguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49892-images-stored-hypersql-database-49896/read.awp16 Jan 2015 17:03:00 ZHi iso Are you sure the database is causing troubles and not your page, loading several FULL blown images? I have an image…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49892-images-stored-hypersql-database-49896/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49892-images-stored-hypersql-database-49896/read.awpimages stored in hypersql database