Blob Files Download

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
stevejones
Forum Newbie
Posts: 2
Joined: Mon Feb 21, 2005 10:11 am

Blob Files Download

Post 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....
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post 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?
stevejones
Forum Newbie
Posts: 2
Joined: Mon Feb 21, 2005 10:11 am

Blob Files Download

Post 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,
Post Reply