Does anyone know if there is a significant performance hit when using the query builder instead of PHQL?
If I remember correctly some other ORMs used to convert the fluent builder interface into DSL-QL (or call it whatever you like) before converting to SQL this incurred some performance penalty.
I just ran a simple query ("SELECT * FROM Robot WHERE id = 1" on my dev box with
ab -n1000 -c100 and it happened that over 10 iterations, there was indeed a drop of 9 requests per second on average (179 vs 170) which is a considerable 5% on my rig.
Any thoughts? Otherwise, does anyone know what the execution plan is for the ORM?