We have moved our forum to GitHub Discussions. For questions about Phalcon v3/v4/v5 you can visit here and for Phalcon v6 here.

Join to resultset

Hello,

Is it possible to join table to existing resultset? I am working on big data and all-in-one query is painfull (10min). I would like to do part of query, select records and then join rest.

Regards, Mikolaj



85.5k

you can use limits ?

select bla bla bla.. LIMIT 10, 20 -> which will fetch only 10 results, which should be fast.

after that you can use basic array functions ( like array_merge )

even tho this sounds pretty bad, hopefully someone else come with better solution :D

Yes, I am using LIMIT but it's not the solution. However thanks for help.