Correct me if I am wrong, as of right now, relationship between multiple db shards, like sorting, grouping and joins have to be done in application level.
Joe On Mar 26, 11:02 am, Michael Bayer <[EMAIL PROTECTED]> wrote: > On Mar 24, 2008, at 7:46 PM, crybaby wrote: > > > > > I am thinking of setting up a small sharding db as an example. I have > > a question about how one would be able to combine sort result from > > multiple db and still maintain the sort order? > > > Anyone have any suggestions? > > since noone has made any suggestions here, my thought on the subject > is that theres no magic bullet here - if you are pulling from multiple > DBs, ordering would have to be achieved on the Python side using a > sorting algorithm. In some cases the sorting may be simplified, such > as placing A-G on one shard, H-N on another, etc. you could optimize > ordering by letter using straight concatenation. So per-use-case > things like that would have to be implemented. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---