Answers.Body: <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>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-10-16T16:33:21.697Z
Answers.Text: You could always throw PHP 7 on there which is [crazy better](http://pixelandtonic.com/blog/php-7) at memory management, too! :)
Answers.UserDisplayName: Brad Bell
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-10-16T16:49:49.247Z
Answers.Text: Setting up a digital ocean droplet and PHP 7 through Server Pilot. I'll report back once it's up.
Answers.UserDisplayName: brunam
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-10-16T18:39:13.663Z
Answers.Text: 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.
Answers.UserDisplayName: RitterKnight
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-10-16T21:42:23.443Z
Answers.Text: 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.
Answers.UserDisplayName: brunam
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-10-16T21:45:54.067Z
Answers.Text: @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.
Answers.UserDisplayName: brunam
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-10-16T21:46:43.927Z
Answers.Text: @brunam crazy, right?
Answers.UserDisplayName: Brad Bell
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-10-16T21:56:56.010Z
Answers.Text: Wow! That's not a small performance decrease.
Answers.UserDisplayName: Anna_MediaGirl
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-10-16T16:10:04.950Z
Answers.LastActivityDate: 2015-10-16T16:10:04.950Z
Answers.UserDisplayName: naboovalley
Body: <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>
  
Tags: <server>
Title: Recommended CPU/RAM VPS settings to query 50,000 entries
ThreadText: # 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**: @username_2 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**: @username_0 crazy, right?  
  > **username_4**: Wow! That's not a small performance decrease.  
  
  ---
  
  