1

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?

1 Answer 1

1

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.

7
  • 3
    You could always throw PHP 7 on there which is crazy better at memory management, too! :)
    – Brad Bell
    Oct 16, 2015 at 16:33
  • Setting up a digital ocean droplet and PHP 7 through Server Pilot. I'll report back once it's up.
    – brunam
    Oct 16, 2015 at 16:49
  • 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. Oct 16, 2015 at 18:39
  • 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
    Oct 16, 2015 at 21:42
  • 1
    @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
    Oct 16, 2015 at 21:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.