First off, Phalcon is amazing - thank you so much!
I worked on an experiment with it last week and found an interesting problem. If I prepare the sql statement (passing in params), I only get back 100,000 rows per instance/thread of Phalcon. I tried making a loop setting limits and offsets, but you still only get 100,000 rows total returned. (for example, I could request 25,000 rows 4 times, or 10,000 rows 10 times, or 50,000 rows 2 times, but no more then that). This also seems to be a maximum when calling Model::count();
Passing in raw sql with with the parameters hard coded in works just fine.
I was able to work around it, but it was driving me a little nuts.
Thanks again for the amazing work - awesome job!