doctrine2 - Doctrine 2 way too slower than Laravel's Eloquent -


i'm trying use doctrine 2 (laraveldoctrine) instead of eloquent.

performing simple query of getting paginated data:

// doctrine $orders = $this->orderrepository->paginateall(50); // eloquent $orders = $this->orders->paginate(50); 

i end doctrine queries taking time (info laravel debugbar):

  • doctrine queries took 3.86s

1.79s

select distinct id_0 (select o0_.id id_0, o0_.customer_id customer_id_1, o0_.customer_ref customer_ref_2, ... orders o0_) dctrn_result limit 50 offset 0 

16.63ms

select o0_.id id_0, o0_.customer_id customer_id_1, o0_.customer_ref customer_ref_2, ... orders o0_ o0_.id in (?) 

2.05s

select count(*) dctrn_count (select distinct id_0 (select o0_.id id_0, o0_.customer_id customer_id_1, o0_.customer_ref customer_ref_2, ... orders o0_) dctrn_result) dctrn_table 
  • eloquent queries took 50.38ms

36.73ms

select count(*) aggregate `orders` 

13.65ms

select * `orders` limit 50 offset 0 

i'm not pasting whole doctrine queries here there's 65 columns in table, used 'as', identically mentioned columns.

is intended doctrine 2 behavior slow or missing something?

i used annotations meta data mapping , doctrine\orm\entityrepository accessing data.

thank in advance.

best regards.


Comments

Popular posts from this blog

how to insert data php javascript mysql with multiple array session 2 -

multithreading - Exception in Application constructor -

windows - CertCreateCertificateContext returns CRYPT_E_ASN1_BADTAG / 8009310b -