Real State app data bases photos

eduardo_gsp_oliveira · 2024-09-21T15:14:45.383Z

Hi everyone ,
I am trying to creat an app for Real State company, and I would like to know wich case is more eficient and spend lass WU

1 - Create one data type with all property info, including all photos
or
2 - Creat a data type with all info and just one photo, and create another data type with all photos

I had this concern because i don’t know if is a good idea to put so many information in just one table

HariPrasad · 2024-09-21T15:30:36.131Z

Hey @eduardo_gsp_oliveira I would suggest you go with 2nd case because having everything in one data-type will load more data and result in wu consumption increase.

tunacardak · 2024-09-22T21:04:25.936Z

It depends how many photos you will show. Bubble doesn’t load all the data until it needs to. Can you share the part of the ui you will show the photos?

eduardo_gsp_oliveira · 2024-09-24T21:07:44.002Z

Hi HariPrasad, thanks for answer me.
I understand the same, but i have another friend that told me to do the first case, he said that to put every photos at the same data type will count just one search, so will reduce de WU
Is this make any sence?

HariPrasad:

Hey @eduardo_gsp_oliveira I would suggest you go with 2nd case because having everything in one data-type will load more data and result in wu consumption increase.

eduardo_gsp_oliveira · 2024-09-24T22:48:44.017Z

Hi Tunacardak.
The idea is create a real estate app, for a company register some properties to sell and will put the photos about thoses properties.
The limit will be like 60 photos, and usualy is about 30 photos
The dout is:
Create a data type ‘propertie’ with adress, owner, values and a field photos (image type and multiple entries).
Or
Creat a data type ‘propertie’ and a data type ‘properties-photos’, in the data type propertie put a field photos and link with data type ‘propertie-photos’.
Wich one has lass consuption of WU

tunacardak:

It depends how many photos you will show. Bubble doesn’t load all the data until it needs to. Can you share the part of the ui you will show the photos?

tylerboodman · 2024-09-25T00:25:11.370Z

If you need additional features like adding a name or caption to each photo, this could be a good idea:

Property
[all the property related fields]
Cover Picture (Picture)

Picture
image (image)
caption (text)
sortOrder (number)
Property (Property)

This allows you to have a caption per image and also a sort order so users can rearrange the order and you modify the number in the background.

You would get each image by Search for Picture, constraint Property = Current page's Property sorted by sortOrder

You can have multiple Pictures associated with a Property, but still put one as the cover page directly. Also a benefit is you can load just the first 10 pictures and have a “show more” or when they scroll in a repeating group it reveals more. No need to load all 60 pictures onto the page right away from a list field.

tunacardak · 2024-09-25T07:46:15.719Z

Bubble repeating group is smart. It only loads data when it needs. Just avoid showing all the images at once.

eduardo_gsp_oliveira · 2024-09-25T18:03:12.353Z

Hi Everyone
Thanks a lot for all the explications
My question is solved, I just don’t know how to closed this topic
What i need to do now?