After some help on the performance and speed of my app. I am on the paid plan at the moment and the app is really struggling with both the web view and when i view data in the editor.
The app is based for store audits, as such the store is required to fill out various fields and take pictures. In total there is 90 questions for a store with say 20 of them been images.
My database structure is simply a table that stores the question, store, answer and image (if it has one). So far we have carried out 4 stores - so around 400 lines maximum in the table.
The app though is grinding to a halt, i am trying to retrieve data in the editor and it is taking around 40 seconds to load 50 records and often bombs out.
Is there any suggestions on how to handle this? Should i save my images in a different location and have a link or something to pull them through?
Any help would really be apptreciated