Hi Matomo Team,
I am Abhishek Sharma, Backend Developer at DotPe. We provide an innovative solution that lets brands and retail buyers engage and sell products through an online platform. It replaces physical showrooms and trade shows, eliminating the need for a physical location and physical samples to show new collections.
We are trying to integrate Matomo On-Premise on our servers. We successfully did so, a few days back for 50,000 active domains on our system. But yesterday we realise that it is creating some problems as the data grows. After spending some time we figured out that this query
SELECT option_name, option_value FROM `matomo_option` WHERE option_name LIKE '%report\\_to\\_invalidate\\_%\\_%';
causes some problems in the system as it takes a lot more time to get executed than it is expected.
We liked your project and wanted to integrate it into our system but the hurdles don’t allow us to do so. I request you to please help me out with this, if possible. I shall be thankful to you. Expecting a positive reply from your side.
Thanks and Regards