CODEWITHSUNDEEP
phpmysqlzend-framework
kamikaze_pilot
kamikaze_pilot

Reputation: 14844

is there a limit to zend framework's fetchAll method?

so I was trying to use zend's fetchall function to retrieve all 194543 rows within a table...but then nothing came up and when I tried to debug the code, right during the fetchAll line, the debugger would just stop...

is there actually supposed to be a limit to how many rows I can fetch with fetchAll and if so how do I overcome this limitation so that I can fetch everything and put it into a php variable?

Upvotes: 2

Views: 1819

Answers (1)

cwallenpoole
cwallenpoole

Reputation: 82048

Zend's fetchAll is a wrapper around PDO's fetchAll, which can be memory intensive, and I've heard of some servers being set up so that it is difficult to create arrays with over 70k entries anyway. The PHP docs do have some suggestions on how to handle this, but I think you may want to re-think this. Why can't you use fetch instead?

Upvotes: 4

Related Questions