Increase the performance of yii2 project

Increase the performance of yii2 project


Recently, I was working on yii2 project with php 7.2 ,we were facing an issue on yii2 schema database ,in which we were using it yii2 as layer and was calling another yii2 API .At long run we were able to find that YII2 as some default rules in schema.

Points:
1) By default we are using active record ORM by YII2, So by default yii2 scans the database schema for every SQL query action.
2)To avoid it we used yii2 schema caching along with that ,we create CRON job to executes code from below link.
https://forum.yiiframework.com/t/how-to-clear-schema-cache/35109/6
3) The CRON will refresh the schema of all tables and clear the cache.

Please share your comments ,if there any other way to increase the performance of yii2.

REFERAL:

https://www.yiiframework.com/doc/guide/2.0/en/tutorial-performance-tuning#enable-schema-caching

Comments

Post a Comment

Popular posts from this blog

Find pair of n numbers in php

Image
Recently I was working on mobile project in which we were working on service code in php, To find the pair in certain number in list.  Example:  $total = 4; $pair_total = $total * ($total - 1) * 0.5; // 6 So here we are able to find the pair combination using this formula.And pls comment if there any tricks similar to this.
Read more

php: nested if in select tag

nested if needs to be grouped to avoid unexpected error: Ex: // //Parse error: parse error, unexpected ':' $slect='<option value="1" '.$val== "1" ? 'selected="selected"' :''.'>slect1</option>'; //Work: $slect='<option value="1" '.($val == "1" ? 'selected="selected"' :'').'>slect1</option>'; echo $var;
Read more

yii framework simple shopping cart tutorial for beginners

Provides shpping cart functionality for models. Cart is a container object that holds items collection and have handy methods to work with it. It uses user session as a cart data storage. Installing and configuring 1 way: Registration in the config file Add to protected/config/main.php : [php] 'import'=>array( 'ext.yiiext.components.shoppingCart.*' ), 'components' => array( 'shoppingCart' => array( 'class' => 'ext.yiiext.components.shoppingCart.EShoppingCart', ), ) 2 way: Registration by necessity [php] $cart = Yii::createComponent(array( 'class' => 'ext.yiiext.components.shoppingCart.EShoppingCart' )); //Important! $cart->init(); $book = Book::model()->findByPk(1); $cart->put($book); Preparing a model Models that you are planning to put into the cart should implement IECartPosition interface: [php] class Book extends CActiveRecord implements IECartPosit...
Read more