List and map very slow to load

Hey,

The time to load “les familles d’activités” (it means “the family activities”) and load the map is very long… Have you an idea of why it’s so long? and what can i do to display all that very quickly?

You need to know that :

  • I have around 140 pictures/markers maximum to display in the list / or on the map.
  • Each users can filter the list and the map with 5 caracteristics linked on each families/activities
  • I tryied to display map with and without filters and the loading time is the same.
  • I tryied to restrict the number of activities to 20 but the loading time was the same.
  • I tryied to only display content of 4 pictures / markers to see if the problem come from the quantity displayed.

So… i leak of idea to know what to now to accelerate the loading of the list/map…

Any idea to suggest me ?

@LuckyTravel that’s quite slow indeed.
Is it a PWA or native iOS version? If you test PWA vs iOS - is the speed the same? What happens if you remove any additional filters? Are images optimised?

I’d also look at what’s happening in network tab (examine queries and see what is the longest one), but that requires some skills.

Best,
Victor.

I don’t know what’s PWA… I just know the name… But i just recorded the screen of my phone (iPhone).

About what i’ve seen, sometimes it’s short (on the both), sometimes it’s long for one and short for the other one, and sometimes it’s long for the both… The both have the same problem when i use that from my phone and what i use that on my computer. So for me, it doesn’t sounds to be a problem of connexion.

If i remove the filters, it takes exactly the same time… So… filters don’t sounds to impact the performance of the display…

If the images are optimised? no… but how optimise that? About what i’ve seen, if i switch pictures on webp, Adalo doesn’t accept that… :frowning:

”I’d also look at what’s happening in network tab” → I think that i see what you mean but i know to do that on a website. How do that with a mobile app? i do that directly on the preview version from the computer? that’s what you mean?

@LuckyTravel
PWA = Web app. This means you didn’t make the build of the app in iOS or Android and didn’t install it, but just opened it on your phone via the browser or sharing link. This is not related to screen recording.

Image optimization means that you’re not trying to load images size 10000x10000 of many megabytes, but you use images of lower resolution and lower filesize. There is no need to have a huge picture if you’re displaying it on a small part of the screen. Just in case: I do not know anything about images you’ve uploaded - I am explaining what is image optimization.

If the app is not performing well in the web version, then it will not perform well on any platform, computer or phone. So you can examine what’s happening on the computer to understand the potential issues.

You need to understand in which cases the performance is bad (always? only on the native app? on the web?) and then try to find what’s causing the performance degradation.

Best,
Victor.

Thank you for the explaination of PWA and the images optimisation :slight_smile:

On the web version
* For the families list, this is the result that’s display when i clicked on “inspected” from Microsoft Edge (and that i changed nothing since yesterday) :

Request URL : https://database-red.adalo.com/databases/9679k3w8fsh8xy7gh5faa2ivk/tables/t_5k3ooqeslsl6dt50930grndgw?appId=f31a0ef5-fc24-40f1-a398-64e82e469350&componentId=2g7j1o5m8jcxhudd0acpc98i9&bindingIds=4uf33lo4b5me60xik1psrsdv5&imageMeta=true&evaluateBindings=true&include=manyToMany~c_6n006g1rg8gr7cj67vqgzx4t1%2CmanyToMany~c_0bdb0xvfn2equ2axl4z9pbjtq%2CmanyToMany~c_9s249w8rfgx4848r9ron4j0jy%2CmanyToMany~c_3z4z992qwekm4dagg4l1gsazm%2CmanyToMany~c_b5g6uwlmr7nl9p7db666me3kz%2ChasMany~c_b9qjwsjmjr9tz73gtzs4tmegj%2ChasMany~c_b9qjwsjmjr9tz73gtzs4tmegj.belongsTo~c_b9qjwsjmjr9tz73gtzs4tmegj&counts=&sort=c_1lgohtrhyadf08hkhm2zcr2ld

* For the map, i just switched the custom pictures with the default markers (like that, we are sure that the problem don’t come from the pictures optimisation) and this is the result that’s display when i clicked on “inspected” from Microsoft Edge :

Request URL :

https://database-red.adalo.com/databases/9679k3w8fsh8xy7gh5faa2ivk/tables/t_eb28ba4cc6794dbaa5864f14f6ce50cf?appId=f31a0ef5-fc24-40f1-a398-64e82e469350&componentId=cbr15fjmag8frkvrguinbhlny&bindingIds=bg3jw6rpu1aigpjndkmnd2wb0&imageMeta=true&evaluateBindings=true&include=&counts=

For you, the problem come from where?

It sounds to come from Adalo servers no?

@LuckyTrave maybe the issue is caused by a long response from Adalo backend, combined with the response size.

What I see in the 1st case though is that you might have pretty complex filters, including M2M ones. Also for some reason you’re returning 50 entries (I am not sure why). The size of each entry is pretty large.
Maybe you need to enable dynamic loading on the list, evaluate your filters, and see if you could optimise the collection structure. The thing is that you need to show just a few pictures, so other information is kind of excessive.

The 2nd case works pretty fast for me - the JSON from database loads in 2 seconds (which is ok for 137 records). So I think the speed is related to the map component. However, still there is a lot of info in each record. An interesting idea to test is to create a “reduced” collection only with markers (addresses) and see if that improves the speed.

Please keep in mind that this looks like “making a diagnosis by mail”. Proper performance audit requires hand’s on access to the app, experimenting, and may need quite some time.

Best,
Victor.

Hey,

Ok, i iwll try to create the same content of the screens but cleanest and as simple as it’s possible to do to see if it’s better or not :slight_smile:

Currently, in the database, we have around 51 families of activities, and 137 activities. I plan in the future to have maybe 200 families and more than 1000 activities. Do you think that Adalo is able to support that as something of smooth during the utilisation ? or do you think that it will be very very slow to load ?

Is it possible to pre-load the content of the both screens (the map and the activity families), like that, when someone will arrive on the homepage, the content will pre-load, then, when the user will select the activity families or the map, all the content will already be displayed without time of loading. That’s possible to setup something like that or not ? (By staying only in Adalo, or, by the fact to use something else outside of Adalo)

Best,
Damien

Hey,

Have you seen my last message?

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.