We have a relatively large database. Users upload their data through a form & it’s displayed live through the repeater.
The problem is it’s taking a seriously stressful amount of time to load, making it unusable. Check it out here:
https://www.artzone.co.nz/galleries
Does anyone have any tips or tricks for how to speed up the load time?
Note: Reducing the size & amount of imagery doesn’t seem to effect the load time.
Thanks! : )
A few points:
You can play with the number of items to display. Instead of 200 (you have a little over 100 in your database), use the default of 20. It give a quicker response, and you can always add paging or show more. It’s better to give quicker results than to attempt to display the entire list.
You have a conflict in the way that you are populating your Repeater…
The Repeater is connected to the dataset:
And you are performing a query:
You don’t need the query code, and in fact, it is wrong since it causes a conflict with the dataset connection. Also, you don’t have an onItemReady() function to properly render the Repeater items.
Another problem I see is that you are referencing page components that don’t exist:
I hope this helps.
Thank you so much! Will fix these errors now & see if it performs better. Much appreciated.
First of all, thanks for your suggestions.
You stated that there is a conflict in this method of populating the repeater and it was not really clear to me what you mean by that. The thing is that I have done the same thing a lot of times so I wonder what is the conflict and depending on your response I might be able to improve my website.
