well, the title says for it self. i have some search that are REALLY important to analise our business etc. but it happens when we click on search, it spends 60k+ workload units on a single search. this is not working, since it costed like 20$ for EACH search.
my DB has around 20k items and I imagine this is the problem. But i don’t know a better way to fetch the data.
bubble points to this search (green circle), which is a conditional of a repeating group. but this search has a constraint to search contacts in ANOTHER repeating group (orange circle)
I’m sure the problem is the orange circle search in another search but is there a work around to this?
because this was the only way i found to get the results I need.
here’s the search for contacts. this search is a HUGE search, because it can give me back ALL o f my contacts. and i assume this is really heavy.
the thing is: the main search (green circle) looks for sales in the data base, but there are some constraints from ANOTHER DB (contacts) that may influence the search for SALES. that’s why the main search looks for SALES but it needs to search fields from another DB (contacts) it’s kinda a merged search. i dont know how to do that in another way.
to have a search that depends on another search is really killing my WU