[Augustino]

Hi

I need use GD, actually I have a script generating images using Blobs fields from My-SQL, the which is working very fine

I have read than using SQL, use more resources of the server

But, I think than reading the files using
fread() function, the execution time can be worst

Really for me is more important the execution time and the time to load the page than the resource usage

What Should I use?, Blobs Fields in MySQL or read files using GD Library and Why?

Best Regards and Happy Ney Year

[mab]

Storing the files as a file within the file system on the server should result in the fastest access time, that of the file I/O operations. If you read the entire contents of the file at once. The memory needed for that variable would be equal to the size of the file.

Your database contents also gets stored in files within the file system on the server. However, to read this, the database server must locate the record within the database (depending on indexing, this could take several times longer than the directory operation needed to open this if it was stored directly as a file.) The database server must then read the record and pass it to the PHP client library functions that PHP uses. The client library code then pass the data to PHP in the resource result. The resource result will be at least the size of the data requested and will remain in memory until it is freed up or the script ends. You then must fetch the data from the resource result. This then uses twice the amount of memory.