Search found 274 matches
- 24 May 2021, 07:47
- Forum: Laravel package
- Topic: mysql optimization/clarification
- Replies: 24
- Views: 15031
- 24 May 2021, 07:01
- Forum: Laravel package
- Topic: mysql optimization/clarification
- Replies: 24
- Views: 15031
Re: mysql optimization/clarification
but can I update 2021.04.2, not x-dev ?
- 24 May 2021, 06:27
- Forum: Laravel package
- Topic: mysql optimization/clarification
- Replies: 24
- Views: 15031
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...
- 18 May 2021, 10:35
- Forum: Laravel package
- Topic: mysql optimization/clarification
- Replies: 24
- Views: 15031
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...
- 17 May 2021, 08:08
- Forum: Laravel package
- Topic: mysql optimization/clarification
- Replies: 24
- Views: 15031
Re: mysql optimization/clarification
Should this call always return the same object app( '\Aimeos\Shop\Base\Context' ) ?
- 16 May 2021, 17:27
- Forum: Laravel package
- Topic: mysql optimization/clarification
- Replies: 24
- Views: 15031
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()))...
- 16 May 2021, 10:49
- Forum: Laravel package
- Topic: mysql optimization/clarification
- Replies: 24
- Views: 15031
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...
- 16 May 2021, 10:14
- Forum: Laravel package
- Topic: mysql optimization/clarification
- Replies: 24
- Views: 15031
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...
- 15 May 2021, 18:23
- Forum: Laravel package
- Topic: mysql optimization/clarification
- Replies: 24
- Views: 15031
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...
- 15 May 2021, 16:29
- Forum: Laravel package
- Topic: mysql optimization/clarification
- Replies: 24
- Views: 15031
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 ?