Hello,
I am using AlaSQL in a Node.js application.
What I do in build time:
- load JSON files into JSON objects.
- create database with 3 tables based on that files.
- fill the table with the JSON objects
The total amount of data sets is about 2500.
What I do in runtime:
AlaSQL queries, which need to be synchronous and have 2 joins, so all 3 tables are included.
Issue:
When I query the data I get a response time of several minutes. Does anyone know how to fix that or how to do it better?
What I tried:
- adding primary key (index) to data sets
- reducing data
Unfortunately did not work
Thank you in advance.