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
Post a Comment