I am running a self hosted version of AppSmith on Docker.
I am finding that it runs very slow, I have set up a MYSQL container on docker to host the information and currently only have 6 entries on the database, so am concerned that if it is this slow with 6 entries, once I set it live and add more entries it will likely only get slower.
I have a few different pages pulling info from different tables on the same MYSQL Database. I find though that different pages seem to run at different speeds, the one that runs the slowest is the main page.
The only conclusion I can draw is that is runs slower because there are more JS functions and SQL queries associated with that page, however there are only
8 Queries
18 JS scripts
The queries are the standard, SELECT, INSERT, DELETE, UPDATE along with a few others to populate dropdown lists with information from other tables
Example
SELECT QUERY
SELECT * FROM JobRecord WHERE JobTitle like '%{{Table1.searchText || ""}}%' AND JobStatus != 'Archived' AND JobStatus != 'Sourcing' AND JobStatus != 'Quoted' ORDER BY {{col_select.selectedOptionValue}} {{order_select.selectedOptionValue}} LIMIT {{Table1.pageSize}} OFFSET {{(Table1.pageNo - 1) * Table1.pageSize}};
CALL FROM OTHER TABLE FOR DROPDOWN
SELECT Company FROM Accounts
The Javascript that I am using is to perform calculations to populate total prices etc after entering/editing details
Example
export default { function() { let total; { total= Number((((Number(a.value) + Number(b.value)) /100) * Number(c.value)) + Number(a.value) + Number(b.value)) } return total.toFixed(2); } }
I have seen this particular page take over 1min to load/respond and even editing can take a long time going from one widget to the next.
Any help would be much appreciated.
