Searching in diferent database

Hello, I have some doubts

I have mobile shop store , i use baserow as my database .
For each categories i use each table in baserow .
Is it possible to search for a text in each table of baserow fastly ?

Is this is good way to store datas in each table according to their categories

Thanks for everyone

You can get all columns in different tables at once. Then search.
To make the system fast you can start fetching columns as soon as user opens your app…