Re: [PHP] Object Query Language optimization

2011-05-21 Thread jean-baptiste verrey
hi, "I often use SQL that is far, far more complex than this." well, this is why my OQL is pretty simple, it does not intend to do any crazy stuff that you can do with SQL (as I can load objects from SQL as well) I had a look at other ORM, and the problem is that some are extremely complicated (D

Re: [PHP] Object Query Language optimization

2011-05-21 Thread Mark Kelly
Hi. On Saturday 21 May 2011 at 15:56 jean-baptiste verrey wrote: > I'm writing an Object Query Language [snip] > (queries don't get much more complicated than that, you have multiple > alias.fieldName in the select, then multiple joins) I often use SQL that is far, far more complex than this.

[PHP] Object Query Language optimization

2011-05-21 Thread jean-baptiste verrey
hi folks, I'm writing an Object Query Language which is pretty simple, you do request such as *SELECT e.*,c.firstName * *FROM employee e * *JOIN contact c ON e* *WHERE e.id=*? (queries don't get much more complicated than that, you have multiple alias.fieldName in the select, then multiple joins)