My app uses Comments with approx 20 users. We reached approx. 1000 rows and it becomes extremely slow to access the page and even more difficult to add (edit) e comment. Any idea why and how it can be fixed?
1 Like
Hey Piero, I think your slowdown maybe occuring because you have created your comments table on a regular Glide table.
A regular Glide table will ensure the user’s device downloads all the rows in that glide table, before the device can render the comments componenet.
Therefore, you will be waiting for 4-5 seconds (depending on the user’s internet speed) before the comments section loads.
The solution, is actually quite simple: move your comments to Glide Big Tables! Glide Big Tables will handle millions of comments and load them in a jiffy on any network speed.
1 Like
Thanks, but I think it works only on business or enterprise plans. I cannot do that, for only 20 people. Is it possible to your knowledge to delete old comments? Glide table it is not accessible for comments.
Let’s say you are still using a normal glide table for your comments section.
Your solution would be to cap the glide table limit at about 500-600 rows.
Therefore, a smart move would be to allow month to month deleting of comments.
Now, there is one way I have in mind that you can do this, i’ve made a short 4 minute video showing you how. I hope it helps:
View it here: How to maintain the row limit in your glide table. Avoid a slow glide table! - YouTube
or here: Screen Recording 2023-07-29 at 6.43.52 PM.mov - Google Drive
PS: Do keep in mind that the archival process will cost you updates. 1 update per deletion.
1 Like
Are you using Pages? On my App (old “Pro” version of GlideApp) I cannot see Glide table for comments. I see it duplicated on Google sheet, but as they say on documents, even if I delete the raws on Goggle, this doesn’t affect Glide table, that remain full of original rows.
I’m sorry Pero, I am not at all familiar with the old Glide Apps. You can still port to the new glide Apps and import your old table to the new glideapp.
@Darren_Murphy Could you provide a solution for this?
Yeah the old comments component in classic apps stores data internally in Glide. We don’t have access to that data like we do with normal tables. Your best option is to manually delete comments through the component in the builder, or simply change the value that’s used for the topic, so you can start over with a new set of comments.
The old comments component has very basic functionality. It was never meant for a full on conversation. It’s not something that Glide is supporting anymore and did not bring it into the New Apps.
4 Likes
Yes. I saved old comments on GS and changed the value. It works. For sure I will use the new version when updating. Thank you!
2 Likes
The solution, is actually quite simple: move your comments to Glide Big Tables! Glide Big Tables will handle millions of comments and load them in a jiffy on any network speed.
Interesting, how does Big tables work that it is so efficient?
The biggest single difference is that data in Big Tables is “lazy loaded”. That is, data is only sent to the user device when it’s needed. Whereas with regular tables, the entire contents of the table is loaded onto the users device the first time the table is referenced. This is why Big Tables can scale so much more (almost infinitely, in theory).
3 Likes
What about offline editing?
Should we have more info on what works in the offline mode? Adding rows work, but what about editing, and other functionalities?