Reduce Server Response Time

I am using $80/Month droplet and experiencing slow server response time,As per my research the database size is affecting the server response time.I also have a CDN services with Cloud Flare. Current database size is 110MB (using only 4% of disc space) .When i connect other database of size 1 MB the server response time gets improved and gets very fast.Any ideas to solve this issue? Please Help…

Thank You. GW


Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Hey, I’m running my blog on Digital Ocean Server with 1 GB RAM but while checking for google speed insight, I’m getting slow server time. I’m using the best caching plugin. Why it’s so?

Hi there!

I think you should give us little more information about your system. What does database engine you are using (e.g. - MySQL, PostgreSQL, MonogoDB…)? And is that database some of your solutions, or some already well-known app (like Wordpress…) ?

I had a chance to work with MySQL databases, and I can say that 110 MB is nothing. I had database which size is few GB, and it was working very well. If this is your database solution and you’re using something like MySQL I would first pay attention to indexing. In my personal experience indexing can massive improve loading and query execution time. For first look for ID fields and make sure they have Primary Keys if possible. For even more optimization, you can look for most used fields under WHERE clauses and make sure they have (index) key. Go thought docs and read more about it, but it can really improve times. After that you can research about query caching. It can also improve time so it’s worth trying. In case of MySQL, here you are a few links: Indexing Optimization and Indexes Query caching docs

If this is some known app, say what, maybe there is some known fix.

As I said, 110 MB is not big database, database usually grow very very large and works correctly. Also you have powerful server that performance should not be a problem.

Maybe with more details I or someone else can you give more details, but this is my 5-cents.