I am migrating a CB app from DAO (queryexecute) to quick. I know ORM has an EntitytoQuery. Does quick have something similar? I was playing with changing some views to work with Entities using getters. I have a pagination form I changed from cfloop query to cfloop index and getters. Works. (Can’t use sql pagination due to my MS SQL version)
I then ran into a problem with a slowdown on one form that loads 250 users and paginates the page. It was taking 5 secs in preEvent to PostEvent. I changed the query to query.retrieveQuery().get() and that fixed it but I then had to change my view to use prc.query[i].field instead of prce.query[i].getField().
What is the correct way? Why was the former so slow? (I guess loading the whole entity?)