Hello together,
whlie working on two result sets at the same time, setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute is obligatory. But what about the performance? Has anyone noticed a performance increase (or decrease)?
thx
SebastianI've no idea. Write a benchmark yourself.
Personally I always use fetchAll() and load it into a big PHP array - which is fine especially if you know the result set is going to fit in memory.
Mark
whlie working on two result sets at the same time, setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute is obligatory. But what about the performance? Has anyone noticed a performance increase (or decrease)?
thx
SebastianI've no idea. Write a benchmark yourself.
Personally I always use fetchAll() and load it into a big PHP array - which is fine especially if you know the result set is going to fit in memory.
Mark