What is the best way to search through few tables at once?

I have 6 separated tables. Each have thousands rows. And all tables are getting new rows regularly. I need to search trough all of them at once. Should I use regular “Advanced search”, or should I index all the data to the json file, upload it to the client side and search through it?

JS, SPA

Hi, Anton,

I think we need some more information to give you any sort of advice. Do you have any relations between the mentioned tables?

By the way, what do you mean by indexing your data to json file and uploading it to the client?

Regards,
Sergey

  1. I do have relations between all this tables, but it is not helpful in this particular case.

  2. Indexing - I mean export all data from 6 tables and merge it into one json file. On user search from frontend, user will download the json file and search will go through it. The results: array of objectIdentificators .
    Json file will have structure like this:
    FirstTable : {
    objectId(row1 id): “all searchable data from the current row”,
    objectId(row2 id): “all searchable data from the current row”,
    objectId(row3 id): “all searchable data from the current row”,
    etc… }
    SecondTable: { … }
    etc…

The second option (with json export) doesn’t seem pretty obvious and flexible to me, so I would try to avoid it.

I suppose you should have some table which is parent for all the other ones, so that it makes possible to query only this table and load required relations with depth. Why is it an unsuitable option in your case?

To put things in perspective, it would be helpful if you could describe specific scenario. When you say search all at once, are you talking about some sort of JOIN query (if it were available)?

I guess, I should read docs more carefully) I will try to use parent table, as Sergey said.Thank you) Your support works great) It’s one of the major advantages in front of Parse.com)

Well, I’m glad I could help you!
Feel free to ask if you run into any difficulties with the suggested approach.