There is a way to know which table to query. Sure. Say 4 hosts with 4 tables each. Every item has an id. The last digit (hex) signifies the table and host.
Some queries are going to need go across all tables. Is that possible at all? On Jun 2, 5:29 pm, Jeremy Evans <[email protected]> wrote: > On Jun 2, 5:19 pm, Hiten <[email protected]> wrote: > > > Hi, > > > I understand that the sharding support in models handles a database > > split across multiple hosts. Is there a way to also handle a case > > where the database is split across hosts and tables? > > e.g.: a case where data is split over 3 hosts, each with 4 tables. So > > the desired row could be in any of 12 tables. > > > I understand how to handle multiple hosts, but is it possible to > > handle multiple tables? Models seem to be table-based. > > Models are table based, but that can be worked around. I assume there > is some way to know which table to look in for any given query? If > so, please describe the situation and I can explain what you would > need to do in Sequel for it to work. > > Jeremy -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en.
