Hi there and happy holidays!
I’m building a new app and my biggest concern here is how to make it run as fast as possible.
I have a few SQL queries, each of them queries one table and each table is linked to the others. So when I query table A, I’ll get ids of rows from table B.
My goal here is to create objects out those queries and store each object into a parent object in a state.
At the end, I’ll use this object to render values into an HTML component.
Those of you who have been there before, would you :
I wonder if declaring global variables will help processing faster or not. My concern here is the JS part as it runs client-side and might deteriorate my overall performance.
Also, I know for sure I’ll have to deal with LIMIT and OFFSET for one of my SQL query. Never been in this territory before, what’s the best usage here? I’ll probably limit results to 100 rows so I can keep querying fast.
Thanks for your tips!