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
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.