Hi, I have a problem. I'm creating an application and I need to access a table in the database with over 1M records. Despite the fact that the number of products summed up doesn't exceed 200 per row, there are many rows, and the query doesn't have enough time to execute. I performed the same query in a different manager, and it took 3 minutes and 30 seconds. Is there an alternative way to do this or to increase the timeout further? Additionally, migrating my database to retool is not very feasible for me.
It sounds like the best thing to do would be to make sure that you have an index on the table(s) in the database to help support your query. Even large tables respond FAST if you have them setup with an index on the key columns that you are filtering by.
Questions:
- What database are you using?
- Do you have someone who knows how to help build an index on the table in the database?
-
The database I am using is MySQL.
-
I tried using indexes, and it significantly improved the query execution time.
Thank you.