This forum is in READ-ONLY mode.
You can look around, but if you want to ask a new question, please use Stack Overflow.

SonataAdminBundle - ListBuilder using Mysql Slave

Discuss Symfony 2 bundles here

SonataAdminBundle - ListBuilder using Mysql Slave

by aps694 » Fri Sep 12, 2014 11:59 am

Hello All,

I am using Symfony2 and SonataAdminBundle for my backend system. The data is gradually increasing which is slowing down my backend system. I have looked/searched for SonataAdminBundle optimization and found that many Users complained about Sonata's pagination issues for slow performance.The backend queries are taking much time hence slowing down my Mysql Master DB.

Now what I want?

I want to generate all my List & Show pages i.e. "/list" & "/show" pages using Mysql Slave connection, so that all the SELECTS run on my Mysql Slave DB and for Inserts & Update I want to use Mysql Master DB.

Is it doable? Can anyone suggest me / give me any clue?

Many thanks ..
aps694
Junior Member
 
Posts: 1
Joined: Fri Sep 12, 2014 10:53 am