I think I know the answer but guess I’m seeking confirmation…
Does the number of deleted fields within a database Thing have any impact on the DB performance?
I assume it doesn’t but am just wondering if a lot of deleted fields can cause any unintended bloat?
Thanks in advance folks!
stone
June 6, 2019, 11:52am
2
Hi @MartinFigg
Here’s an answer by co-founder josh about this:
“In order to increase my app speed, should I regularly clean my database to remove all items that have the validity flag set to “no” in order to speed up these searches ?
In a more general case, can we expect a bubble app to get slower and slower because the database is growing, even if we are not displaying more items (we are just keeping old data, but only display fresh one) ?
And when does this becomes critical (i.e., how fast is a search on server side before transmitting the data depending on the number of items in the database) ?”
Generally, having more stuff in the database that isn’t loaded in a search shouldn’t slow things down too much. We automatically build database indexes that let us quickly find things that match a search criteria. The very first time you do a particular kind of search, we don’t have an index yet, so that will be noticeably slower (perhaps very slow) on big databases, but we auto-detect that happening and build an index, so that in maybe 15 minutes to an hour, that search is fast. So, I wouldn’t worry too much about cleaning up old data. That said, if you know you never need a piece of data again, it doesn’t hurt to delete it.
Full answer:
Next batch of questions (skipping things that someone else already gave a good answer to in the thread):
“If I have a bunch of image thumbnails on a page and the source is a full sized image does that mean the page has to wait for all of the full sized images to download?”
Generally we’re good about resizing things on the server. But you can check for yourself: if you look at the image url in the browser, you’ll see something like: “?w=380.94643874044306&h=243.1&fit=crop” at the end of the …
When you delete a data type, it’s not actually deleted yet. It’s just hidden and you can restore it at any time.
If you wanted to permanently delete it, first delete it the normal way, then run a optimization of your app, this deletes unused data fields.
Find it at Settings > General > Scroll down
That’s also great for cleaning up unused CSS settings that build up over time as you are building in Bubble. This increases page load speed significantly.
3 Likes
Thanks very much for this info and pointers - feel comfortable about how we are handling the deleted fields now!
stone
June 6, 2019, 8:54pm
4
Awesome If you feel like the question has been answered, please mark the thread as solved. This helps other Bubblers find the answer.
If you have any others questions feel free to create a new thread.
-Øystein