Andy, File Systems are made to store and retrieve files in an efficient way. You may not expect better performance when you put a database in between. When speed is an issue you should use MySQL to store and retrieve filenames and something like ReiserFS, RAID and good hardware to store images.
Thomas Spahni On Mon, 1 Jul 2002, andy wrote: > Hi there, > > I am wondering if anybody has experiance in saving images to blob in mysql. > > I do save images with 1 K and 4 KB to blob fields while I used to save them > to file. It seams to me that this is much slower accessing the files. The > images take a bit (really short but absolutly noticable) to show up on the > site. Is there a way to improve the performance, and why is this happening? > I thought the performance might even boost after storing them to blobs. > > Thank you for any comments on that, > > Andy > > PS: I was planing to store all the other images (20 - 50 KB) to blobs as > well (thousands) but after this first experiance I am a bit confused if the > performance would even more suffer. Would you guys recommend this? > > sql, query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
