Yii2 Report Advice

Hi Guys,

I need to create a report tool using Yii2 and I have millions of records on my database.

I just want to know what would be the best approach to create this tool without overloading my server.

I used to work with Yii 1 and every time that I would check my report tool my entire website would get slow and I don’t want to go through that again with Yii 2.

Anyone has any advice for me in order to use the best approach to achieve that?

Thanks in an advance.