Advanced filtering decreases the speed of loading content

mlcodec19prediction · 2025-02-20T08:14:48.097Z

Hai bubble developers,
Thanks in advance.
I am facing a problem, my page is loading very slowly due to this advanced filtered. If there is any alternative way for this.

Screenshot 2025-02-20 121233665×507 28.8 KB

This image show the problem it is not loading the order id .

Screenshot 2025-02-20 121140863×486 38.6 KB

You can see this is advanced filter I have given.

rafael.tgt · 2025-02-20T13:12:35.029Z

have you tried to constrain the B2B customer on the Do a search instead of filtered operation?

mlcodec19prediction · 2025-02-20T17:36:02.067Z

Yes , but there is no option for B2B customer on the constrain of the Do a search.

rafael.tgt · 2025-02-21T12:38:14.355Z

Sorry, now I see that B2B is related to orderid and not directly to Order_details. With the info provided, maybe the issue is because bubble is doing a request for every order_detail to get its orderid related record and then its B2B customer - you may need to directly tie B2B customer to order_detail to improve performance

mlcodec19prediction · 2025-02-22T15:22:03.410Z

Thanku for your help.
Can you please specify the searching way. As per your direction I have created a new field b2b customer in order_detail. But without advanced search how I form the search line.

rafael.tgt · 2025-02-24T12:41:07.852Z

If you create a new field in order_detail, you can insert the constraint directly on the do a search - without the need for :filtered