How do I optimize my database for more speed?

The database access seems to slow down at different times.

The optimization of a database table (or tables) can greatly reduce the time needed to access information. Think of it like a file cabinet. If everything is thrown in there, it's harder to find things. So lets organize the file system and optimize the database.

We recommend optimizing your database on a fairly regular basis - about once a week if you have a busy site. If you have a very busy site, maybe a little more frequent.

Here's how;

1) Go to /cpanel
2) Click the MySQL Database section.
3) At the bottom of that screen click phpmyadmin.
4) Click on the database you want.
5) It shows all the tables in the main part of the screen. At the bottom click the "Select All Tables" link.
6) Once there is a checkbox in each of the tables, on the bottom right use the dropdown menu and pick "Optimize Table"

This will optimize your database and speed up the searches on your pages.



Reviewed: 11/05/2016

  • Email, SSL
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

What if I need more hard drive space or bandwidth? - delete

Submitted by user: I need more HD space.. There are a few other companies out there that are...

What language can I program in? Where can I download scripts?

For the most part PHP is the most common scripting on the web. Many other scripts and programs in...

Help - my site's been infected by a Virus

The viruses that attach themselves to web pages are unfortunately common, and though they are...

Fix for FrontPage hit counter on subdomain

Problem: You're using MS Front Page with web bots. The hitcounter works fine on your main domain,...

Can you tranfser files from my old host to you?

If your current web hosting provider has cPanel all you would need to do is create a BACKUP of...