Menu
SuiteCRM Pull Request Party hosted by SalesAgility
Welcome, Guest
Username: Password: Remember me

TOPIC: Slow response due to high amount of data

Slow response due to high amount of data 4 months 1 week ago #77768

  • rishich
  • rishich's Avatar
  • Offline
  • New Member
  • Posts: 1
  • Karma: 0
Hi Folks,

I am facing issue of slowness, Since my database has 15lakh data now and will increase to 1crore in future.
Now If I make a search then it will take very long time to respond. My activity string also take very long time to respond. I have already done the indexing in MySQL 5.7 database.

Please help me on this.
Thanks in advance.
The administrator has disabled public write access.

Slow response due to high amount of data 4 months 1 week ago #77793

  • pgr
  • pgr's Avatar
  • Offline
  • Administrator
  • Posts: 10244
  • Thank you received: 1533
  • Karma: 353
lakh? crore? :huh:

If you need to handle such a large installation you need to adequately plan and deploy database hardware, and probably tweak some queries and have a proper data clean-up strategy in place.

There are a few tips here
pgorod.github.io/Database-tables-size/

But you will likely need specilist DBA work, or specialist SuiteCRM services (like those sold by SalesAgility)

My SuiteCRM In-depth blog.
Thank you for always stating your SuiteCRM version, checking your logs, reading the Docs, and searching before you ask!
The administrator has disabled public write access.
Time to create page: 0.042 seconds
Powered by Kunena Forum