Quote:
Originally Posted by FreeHugeMovies
This might get interesting.
"Those guys are bullshit!!!
Of course the image are stored in BLOB, how can you store in db if it is not in a BLOB format????
The problem is not the DB etc etc.
I'm just telling you that the image are too big. The image size I think is > 3MB.
I will try if I can resize it.
"
|
$query = "select id, content from big_table_of_images";
// do some nifty for loop or while loop, doesn't matter...
// inside that, use the gd library to resize on the fly
// then update big_table_of_images set `content` = $new_size where `id` ='$row['id'].';
not too hard, maybe 10 minutes worth of work. but i'll say again, you will be able to scale much better if you keep it out of db and simply reference it...
goodluck
