We currently have things set up and working as described below. Trying to understand if it makes more sense for us to have our node/express API on Cloud Functions, App Engine or something else?
Google Cloud SQL (MySQL 8.0)
Fairly simple database but with some complex searching queries and lots of querying from Cloud Functions and our frontend. There are also lots of simple ID-based queries made from the back and frontend.
Frontend
Using Firebase Hosting for our react.js site. Nothing complex here, just lots of API requests to our API on Cloud Functions to load user data, search results and so on.
Cloud Functions
We have some functions running, other than the express API, which work well but our main focus is to understand if the express API we have on here should be moved. We'll soon be invoking the API function around 1 million times per month from the frontend.
Some questions I have:
- Is it more efficient, per request, to run App Engine for the API?
- Which is likely more cost efficient?
- Are Cloud Functions or App Engine generally better suited for APIs?
I know App Engine requires a bit more work and that's fine. Thanks in advance for the help.