<p>The CPU won't be the issue more the RAM if you expect to pull in all those results. But it's not much anyways.... A 1 CPU/1GB RAM on Digitalocean will be enough. </p>

CC BY-SA 3.0
2015-10-16T16:33:21.697Z
You could always throw PHP 7 on there which is [crazy better](http://pixelandtonic.com/blog/php-7) at memory management, too! :)
Brad Bell
CC BY-SA 3.0
2015-10-16T16:49:49.247Z
Setting up a digital ocean droplet and PHP 7 through Server Pilot. I'll report back once it's up.
brunam
CC BY-SA 3.0
2015-10-16T18:39:13.663Z
How often does the data need to be "updated"?  Not sure what your app is doing but if you can afford to do any sort of caching, that'll reduce server load immensely.
RitterKnight
CC BY-SA 3.0
2015-10-16T21:42:23.443Z
Unfortunately it can't cache. I'm using craft as a sweepstakes entry system and I have to check to make sure there aren't duplicate entries with a json validation system. Works pretty slick.
brunam
CC BY-SA 3.0
2015-10-16T21:45:54.067Z
@BradBell switching to PHP 7 gave me killer increases... Went from a 2.3s query to a 330ms query on 17,000 entries and only using around 500mb of RAM to do it.
brunam
CC BY-SA 3.0
2015-10-16T21:46:43.927Z
@brunam crazy, right?
Brad Bell
CC BY-SA 3.0
2015-10-16T21:56:56.010Z
Wow! That's not a small performance decrease.
Anna_MediaGirl
CC BY-SA 3.0
2015-10-16T16:10:04.950Z
2015-10-16T16:10:04.950Z
naboovalley
<p>I'm running a very simple query on a text field...</p>

<pre><code>{% set query = craft.request.getQuery('email') %}
</code></pre>

<p>Locally, with one entry on my machine, I'm getting a response time of 332ms. We were assuming around 3,000 total entries, but 3 days in, I'm at 15,000 and climbing by hundreds per hour. </p>

<p>What would be a good starting point for CPU/RAM on a VPS if I assume that we could hit 50,000? </p>

<server>
Recommended CPU/RAM VPS settings to query 50,000 entries
# Recommended CPU/RAM VPS settings to query 50,000 entries

(Asked by: username_0 on 2015-10-16)

I'm running a very simple query on a text field...
{% set query = craft.request.getQuery('email') %}

Locally, with one entry on my machine, I'm getting a response time of 332ms. We were assuming around 3,000 total entries, but 3 days in, I'm at 15,000 and climbing by hundreds per hour. 
What would be a good starting point for CPU/RAM on a VPS if I assume that we could hit 50,000?

**Tags:** server

---

## 1 answers

### Answer by username_1 on 2015-10-16. Score: 1 | Accepted answer

The CPU won't be the issue more the RAM if you expect to pull in all those results. But it's not much anyways.... A 1 CPU/1GB RAM on Digitalocean will be enough.

> **Comments:**
> **username_2**: You could always throw PHP 7 on there which is [crazy better](http://pixelandtonic.com/blog/php-7) at memory management, too! :)  
> **username_0**: Setting up a digital ocean droplet and PHP 7 through Server Pilot. I'll report back once it's up.  
> **username_3**: How often does the data need to be "updated"?  Not sure what your app is doing but if you can afford to do any sort of caching, that'll reduce server load immensely.  
> **username_0**: Unfortunately it can't cache. I'm using craft as a sweepstakes entry system and I have to check to make sure there aren't duplicate entries with a json validation system. Works pretty slick.  
> **username_0**: @BradBell switching to PHP 7 gave me killer increases... Went from a 2.3s query to a 330ms query on 17,000 entries and only using around 500mb of RAM to do it.  
> **username_2**: @brunam crazy, right?  
> **username_4**: Wow! That's not a small performance decrease.  

---

