Merging columns for speed improvement

[nadavma2]

Hi, I have a question about app speed:

I have a search that goes through a list of thousands of products, using keyword matching across 4 different columns. Would combining all the keywords into a single column improve adalo speed?

Thanks a lot!

[nadavma2]

@Victor

[Victor]

@nadavma2 you can make an experiment by yourself and share the result.

This question is difficult to answer as the performance change depend heavily on multiple factors: how Adalo processes search in the list on the frontend, what does it send to the backend and how backend DB search is being performed. Such information isn’t accessible to Adalo users.

I would expect that a DB query with a filter on a single column should work faster, but that depends on multiple factors (what is the underlying SQL query type, is this column indexed, etc etc etc).
Maybe @wjgilmore can shed some light on this.

Best,
Victor.