I’m wondering if people have any tips for maintaining good perfomance as the records counts in the SalesLogix database grow.

Question:

I’m wondering if people have any tips for maintaining good perfomance as the records counts in the database grow. We are currently using 7.2.1

 

Answer:

There are many things that make the history (as well as other) table slow. Here’s a few::

 

   A – Over time, the history table tends to end up with a lot of foreign keys that are invalid. You need to NULL out all the invalid keys or point them to real records.

 

  B – Missing indices on foreign key fields. EVERY foreign key field in every table should be tagged w/an index.

 

  C – Not re-indexing the db on a regular basis. For large highly active db’s, this should be at least once a day (after hours of course).

Submit a Comment

Your email address will not be published. Required fields are marked *

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) and Creatio (bpm'online) news and product updates!

You have Successfully Subscribed!