Mysql Statements With Priority

Hello, does somebody know if there is any possibilities to stablish a PRIORITY on INSERTS and SELECTS statements keeping the functionality of ActiveRecords?

We want to low the priority for INSERTS on import process (importing 4000 AR is very stressfull for our server and crash it everytimes)

You have more infor for PRIORITIES here:




Before I can anwser I have to get more details about your problem.

What exactly you want to achieve?

The sql traffic come by users or by multiple sql queries for each user?

Hello Kon, I actually want to achieve an insertion with low priority in mysql using Yii ActiveRecords.

AR is entirely the wrong approach. You will do far better to use DAO and LOAD DATA.