Plain SQL and DQL and Doctrine 2 ORM better performance?

Question

I tried implementing all of the three ways to fetch some data. I noticed that doctrine 2 ORM was faster than others. But when I searched about performance of the three on internet, I noted that SQL and DQL work more faster. If it is so, then what is the difference between the three ?

Which is more preferable to be used when fetching data

score 1 · Answer 1 · answered Mar 27 '14 at 09:52

1

You make a distinction between DQL, and ORM, but you don't specify what you mean by "ORM". If you are using DQL, you are using the ORM. It would be nice to see an example for each one of them, to clarify what you mean, and how you concluded that ORM was the fastest.

DQL is Doctrine's own language, and transforms to SQL. After the executing the SQL query, it will take the result set, and transform those into objects.

With that said, SQL performance is always going to be superior to DQL, because SQL does not do any transformations on the result.

answered Mar 27 '14 at 09:52

K. Norbert

10,494
5
49
48

Thanks, We was made a function in controller. – Sunilspr7 Mar 27 '14 at 10:19
We was made the Select data function in simple SQL and DQL. But SQL query take more time to fetch the data in table. How it is possible? – Sunilspr7 Mar 27 '14 at 12:00
Probably the SQL query that you wrote is different from the one that the DQL is transformed into. – K. Norbert Mar 27 '14 at 12:10
If Doctrine is slower than Simple SQL .Then why its being used in Java platform. – Sunilspr7 Mar 27 '14 at 12:18
1

Doctrine is a PHP library, it has nothing to do with java. – K. Norbert Mar 27 '14 at 12:48
sorry our mistake, I was asking about ORM. – Sunilspr7 Mar 28 '14 at 09:23
ORM is a general term, it's not related to java either. – K. Norbert Mar 28 '14 at 11:03

Plain SQL and DQL and Doctrine 2 ORM better performance?

1 Answers1