Multi-column search and app speed

Get Help
1

Hi, I have a few questions about app speed:

  1. 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 the app’s speed?

  2. Also, if I have several actions that currently run simultaneously, would splitting them into two separate steps (for example: first creating a record, and then updating it) help improve performance?

Thanks a lot!

2

@Victor Maybe you can help with this?

3

I think it will help using a single column in the database for your search:

You can create a new column in your products database, that will include all the information combined you need to search in, and then in the search bar you only will check the “Search index” column.

Example if you have 4 different columns:
Name | Surname | Birthday | City

You will create a new column “Search index” that will include in a single field these data:
Name Surname Birthday City

4

Hey thanks for the answer!
The thing is I have hundreds of nicknames for each product, the question is whether it is better to split it into several columns or one column in terms of how adalo is structured

5

I have no idea about this.. But i’m following the replies if someone knows the best answer! :smiley:

6

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.