Page 1 of 1
Blob Files Download
Posted: Mon Feb 21, 2005 10:12 am
by stevejones
I have a script that downloads blob files, and works, but the download time for blob files off the server takes about 20 times longer than with regular files...
Does anyone know how to fix this problem. I already tried optimizing the table with: OPTIMIZE TABLE `tbl_name`
Thanks for any help....
Posted: Mon Feb 21, 2005 10:15 am
by feyd
each chunk of blob data has to be transferred from the database to the web server, then parsed and sent to the browser... fairly inefficient. Why not just store the files in the file system?
Blob Files Download
Posted: Mon Feb 21, 2005 10:18 am
by stevejones
File system is how we where doing it, but we want to implement real time data backups, so all data in mysql is written at the same time each time to two servers, you can't do that with a regular files system, really only mysql....
Could it posible be a server config problem???
Even though it seems inefficient, is it realy ineffecient to the point to where it should take litteraly 20 times longer or more to download through the MYSQL way....
Thanks,