HI


I been saving image file and label txt into SQL server database with binary mode, uploading from any images source .

Is there a better and a fast way script to do it?

Thanks

Yep...

... Don't!

Storing images (and retrieving them) as BLOBs is a resource intesive process and will slow down the site dramatically and/or increase the resource usage.
If it is a shared server or a VPS it could cause problems.

Originally Posted by chrishirst

Yep...

... Don't!

Storing images (and retrieving them) as BLOBs is a resource intesive process and will slow down the site dramatically and/or increase the resource usage.
If it is a shared server or a VPS it could cause problems.

Thanks.

Bu it will work if the website will have more then 100.000 image files?

Will what work?

It's not the amount of the images that matters, it's the processor time it takes in reading the BLOB then streaming the binary data to the browser.

If you simply store the path (physical or relative) in the database then the image data is read directly from the server HD.

Originally Posted by chrishirst

Will what work?

It's not the amount of the images that matters, it's the processor time it takes in reading the BLOB then streaming the binary data to the browser.

If you simply store the path (physical or relative) in the database then the image data is read directly from the server HD.

Dou you think I shoul have a separated HD just for the images folder and images database?

You can if you want, but this is not necessary.
Just put the pictures in a predefined folder (and rename them, to be sure that no conflict arise) and store that picture name in your db.
Then, when you want to serve it back, pick the right picture from the folder, using the name in the db.

Hi,

I am new to programmin in general and wonder if any of you can help me. I am trying to make a dynamic website, using mySQL, PHP and Dreamweaver CS4. I have the database roughly created and have login/logout, update/addand delete pages all sorted. What is giving me a headache is how to display images from an SQL query. I have the images in a \images folder, but I am not sure the correct syntax to store the img file path in the database. Also, I am not sure how to write the query that will look in the database for the filepath, and then display the image. Any help would be greatly appreciated

this is in reply to:
"If you simply store the path (physical or relative) in the database then the image data is read directly from the server HD."

James