PHP $result->fetch_array(MYSQLI_ASSOC) BLOB efficiancy

[knowj]

if i had for example

$result = $this->database("SELECT * FROM `products`");
while ($row = $results->fetch_array(MYSQLI_ASSOC))
{
echo $row['name']; //etc....
}

and one of the fields was a medium blob containing X amount of data for each row this would hog up a load of memory/system resources?

What would be the best method to prevent the BLOB data from being entered into results and using resources because at the moment each row is holding between 100kB and 200kB and if my logic is correct this is a lot of wasted resource.

thanks in advance
j

[arty56]

knowj wrote:

if i had for example

$result = $this->database("SELECT * FROM `products`");
while ($row = $results->fetch_array(MYSQLI_ASSOC))
{
echo $row['name']; //etc....
}

don't use select *
select each field seperately

if you have 5 fields and you don't want field3 to be included in result then

$result = $this->database("SELECT field1,field2,field4,field5 FROM products");

[knowj]

I thought that was the case. I just wondered if there was a way to return all but with an exclusion.