WP hosting selection to optimize large SQL database

Hi, I’m building a WP site centered around Gravity Forms for Australian users. But I’m new at this.

I’m having trouble choosing between the various hosting options: VPS vs. shared hosting vs. home web server.

Is there a hosting option I should select that would optimize performance+speed of Gravity Forms, in the sense of speeding up SQL requests or something like that? And which can scale when the database gets larger and traffic increases?

Gravity Forms doesn’t require any specific SQL setup. It’s a WordPress plugin and therefore runs on top of WordPress, it uses the WordPress database access abstraction class for database queries, so any WordPress oriented hosting should be fine. But obviously if you plan to manage a huge database and lots of concurrent users you will want to get the best hosting plan possible and maybe a customized setup, nothing specific to Gravity Forms but to the resources that you plan to use for the site, so your best bet is to contact with your host service for advice.

Thanks, I think I understand about hosting. I’m going with a VPS and LEMP stack with Wordpress

If you plan to manage a huge database and lots of concurrent users you will want to get the best hosting plan possible and maybe a customized setup

Sorry, I’m still unclear on this bit. If I have a large database (compared to say the average) and heavy traffic on forms, what resource would it be important to have enough of for optimal performance and to avoid lag? (e.g. RAM, CPU, drive speed)

I’m having trouble understanding how Gravity interacts with the DB. But all else being equal, and assuming SQL queries and the DB were all optimized, what resource should I prioritize to help Gravity run as fast as possible?

If you anticipate growing very large a good cost effective solution might be a compute optimized EC2 instance on AWS.

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.