I have a website built in Angular/Nodej and MySQL hosted on AWS. Currently the queries are very slow because of the huge data.
Im looking for graphql api through app sync with a dynamodb database as the data source. We want to port in the data from csv files to the dynamodb and have graphql queries that allow for us to retrieve the data based on zip code or address field. Also querying address field should not look for exact matches but should look for partial matches (i.e. if the string query is contained in the address list those addresses should be listed)
Or the alternative method could be to use Elasticsearch.
I’m looking for someone who is expert in both approach.
If you are not familiar, please don’t bid.