Fast Self-Hosted CRM Setup: Automating Customer Service Modules

Streamlining Your CRM: Cleaning Ticket Bloat and Speeding Up Support

Last month, an agency client asked me to look at their self-hosted CRM. They handle about 150 customer support tickets a day. Over two years, those tickets turned into a massive mountain of database rows.

The main dashboard was taking four to five seconds to load. Their support staff was losing valuable time just waiting for customer profiles to open up.

When your business grows, your database grows with it. If you do not keep things clean, your customer support team pays the price. Here is how we fixed their database bloat and kept their customer files running fast.

Step 1: Clearing Out the Session and Log Waste

The first place I looked was the session storage. Many self-hosted CRMs write temporary session data straight into the main database.

Since Perfex is built on CodeIgniter, it uses specific tables to hold user sessions. You can read more about how this framework handles active records on the official CodeIgniter framework site. Over time, if your cron jobs are not running properly, these session tables can swell to millions of useless rows.

I ran a simple SQL query to see which tables were taking up the most space:

SELECT table_name AS "Table",
round(((data_length + index_length) / 1024 / 1024), 2) as "Size (MB)"
FROM information_schema.TABLES
WHERE table_schema = "your_crm_database"
ORDER BY (data_length + index_length) DESC;

We found that the database had over 3GB of old session data and activity logs from 2024. We cleared out these expired logs and instantly freed up the bottleneck.

Step 2: Optimizing Relational Queries

When a customer submits a ticket, the CRM has to pull their active services, contact info, and ticket history all at once. If your customer service tools are coded poorly, the database has to run several separate queries, which slows everything down.

Instead of trying to patch and rewrite the core code of your CRM—which will get wiped out anyway the next time you update the system—it is always better to install a clean, well-coded addon.

For my client, we integrated the Customer Service Management module for Perfex CRM which we found on GPLPAL. This tool is built to handle relational data efficiently. It groups customer records, active tickets, and service histories into a single optimized panel, saving the database from having to search multiple tables individually.

Step 3: Setting Up a Maintenance Plan

To keep the CRM fast, we wrote a tiny automated script to handle weekly database maintenance. This script optimizes the ticket and session tables every Sunday night.

Here is the simple shell command we set up in our server's cron tab:

0 1 * * 0 mysql -u crm_user -p'your_pass' crm_db -e "OPTIMIZE TABLE tbltickets, tblticket_replies, tblsessions;"

This single line of code reorganizes the physical storage of the tables and fixes broken index files automatically.

Need More Custom Tools?

If you are a developer managing multiple client portals, you do not have to build every single database connection or customer portal from scratch. I always save time by using trusted repositories to find clean code templates.

For example, exploring a reliable PHP Scripts download directory is a great way to find safe billing tools, API connectors, and automated backup scripts that plug directly into your current setup.

Managing a business is tough enough. Keeping your customer service tools clean and fast makes it a lot easier for your team to do their jobs without fighting slow screens.