Lists of things questions

[hacker]

Hey,

I have a few questions of lists.

For example, I have 2 types, Albums and Songs, and Albums has a field called Songs (lists of Songs)

I have 2 consecutive actions, clear the list of Songs from an Album, and then add list of Songs to that same Album.

1. How fast can Bubble handle clearing a list and adding things to the list?
2. Is there a limit? Can it handle clearing a list of 400 Songs and then adding 800 Songs (not a backend workflow)?

Also, what happens if an Album has a list of Songs, and then I delete a Song.

1. Do I need to have a delete Song and remove Song from the list of Songs of the Album?
2. Or deleting the Song automatically removes it from the list?

Thanks in advance

[cmarchan]

Hi @hacker !

First questions:

1. I would test and see. If you decide to do this please share your findings
2. I understand that for lists less than one hundred things are fast. For larger lists the only way to know for sure would be to test. Same as above should you decide to test.

Second set of questions:

1. A deletion is a deletion. A removal is a removal. Hope this makes sense.
2. If you delete an entry it will be deleted from the dB and thus not show in a list. If you just remove it from a list then it continues to exist in the dB but not in that list.

Hope this helps a bit!

[hacker]

Thanks, @cmarchan,

@cmarchan

• I would test and see. If you decide to do this please share your findings

I think I am unable to test it with large lists, I am changing the way I handle lists (now only searches)

@cmarchan

1. I understand that for lists less than one hundred things are fast. For larger lists the only way to know for sure would be to test. Same as above should you decide to test.

Great, thanks

@cmarchan

1. If you delete an entry it will be deleted from the dB and thus not show in a list. If you just remove it from a list then it continues to exist in the dB but not in that list.

Yes, I understated this. I was only mentioning that when I delete something, there is no need to remove it from the list because it is gone, right?

Also, Do you know something about this?

Live app - Double relationship

Hey, I don’t know if having double relationship between 2 Data Types have advantages? Let me explain: I have 2 Data Types with some fields Album a. name (type text) b. songs (list of Songs) Song a. name (type text) b. file (type file) c. album (type Album) Is there any benefit that Album has the field songs? Thanks in advance

Thanks again

[cmarchan]

Hi @hacker

• Think of a data type entry as an entity. If it is deleted from the dB it is deleted everywhere. It is gone. So … if this entity was deleted from the dB and was part of a list of another different entity … it is gone now.
• Double relationship. Lots of stuff to talk about here. One simple comment on the situation you present is that the song being related to the album makes the list of songs of the album pretty much irrelevant. Unless … there is a purpose for that list of songs other than just being part of the album. Of the song where to be part of other albums then keep the list of songs in the album and delete the field album in the song object.