Search found 274 matches

by MikaelNazarenko
24 May 2021, 07:47
Forum: Laravel package
Topic: mysql optimization/clarification
Replies: 24
Views: 14804

Re: mysql optimization/clarification

aimeos wrote: 24 May 2021, 07:10 Only if the next minor version has been tagged.
I am sorry, clarify please what do you mean ?
by MikaelNazarenko
24 May 2021, 07:01
Forum: Laravel package
Topic: mysql optimization/clarification
Replies: 24
Views: 14804

Re: mysql optimization/clarification

but can I update 2021.04.2, not x-dev ?
by MikaelNazarenko
24 May 2021, 06:27
Forum: Laravel package
Topic: mysql optimization/clarification
Replies: 24
Views: 14804

Re: mysql optimization/clarification

No problem, I am glad to cooperate! these are my packages versions: aimeos/ai-admin-jqadm 2021.04.6 Aimeos Vue.js+Bootstrap admin interface aimeos/ai-admin-jsonadm 2021.04.1 Aimeos ai-admin-jsonadm extension aimeos/ai-client-html 2021.04.7 Aimeos ai-client-html extension aimeos/ai-client-jsonapi 202...
by MikaelNazarenko
18 May 2021, 10:35
Forum: Laravel package
Topic: mysql optimization/clarification
Replies: 24
Views: 14804

Re: mysql optimization/clarification

aitrans() function consists app( '\Aimeos\Shop\Base\Context' ) this call app( '\Aimeos\Shop\Base\Context' ) - seems doesn't trigger singleton and as result it returns always new object, and therefor context inside itself performs extra mysql queries.. But if I use it so: app( 'aimeos.context' ) - th...
by MikaelNazarenko
17 May 2021, 08:08
Forum: Laravel package
Topic: mysql optimization/clarification
Replies: 24
Views: 14804

Re: mysql optimization/clarification

Should this call always return the same object app( '\Aimeos\Shop\Base\Context' ) ?
by MikaelNazarenko
16 May 2021, 17:27
Forum: Laravel package
Topic: mysql optimization/clarification
Replies: 24
Views: 14804

Re: mysql optimization/clarification

Honestly I don't know, but I tried the below code in blade view and in search() method of dashboard Standard: dump(spl_object_id(app( '\Aimeos\Shop\Base\Context' )->get())); dump(spl_object_id(app( '\Aimeos\Shop\Base\Context' )->get())); dump(spl_object_id(app( '\Aimeos\Shop\Base\Context' )->get()))...
by MikaelNazarenko
16 May 2021, 10:49
Forum: Laravel package
Topic: mysql optimization/clarification
Replies: 24
Views: 14804

Re: mysql optimization/clarification

But I think the biggest problem even with project with oldest aimeos project... I just recorded general mysql log for one request in BE dashboard. Of course I have cleared log before and just one time opened dashboard in browser.. A lot of queries and connections ( 150 connections just to visit BE d...
by MikaelNazarenko
16 May 2021, 10:14
Forum: Laravel package
Topic: mysql optimization/clarification
Replies: 24
Views: 14804

Re: mysql optimization/clarification

Hi ) for($i = 0; $i < 100; $i++) { /** @var \Aimeos\Shop\Base\Context $context */ $context = app( '\Aimeos\Shop\Base\Context' ); $context->get(); } The above code makes the error. It get extra connection for each call. I checked like you suggested if I understand you right like this: $this->app->sin...
by MikaelNazarenko
15 May 2021, 18:23
Forum: Laravel package
Topic: mysql optimization/clarification
Replies: 24
Views: 14804

Re: mysql optimization/clarification

I have done a quick test. In blade view I added this code: for($i = 0; $i < 10; $i++) { aitrans('April'); } And modified a bit /vendor/aimeos/aimeos-laravel/src/Aimeos/Shop/Base/Locale.php: public function get( \Aimeos\MShop\Context\Item\Iface $context ) : \Aimeos\MShop\Locale\Item\Iface { if( $this...
by MikaelNazarenko
15 May 2021, 16:29
Forum: Laravel package
Topic: mysql optimization/clarification
Replies: 24
Views: 14804

Re: mysql optimization/clarification

Is your above post regarding aitrans() problem ? Or my problem with older aimeos installation where it is not clear why 35 connections is not enough ?