hey :) Question what you think/know about Horizontal Partitioning of each project data into a "shard" database? distributed project database in a sense that all the project have the same scheme But they have separated database. http://en.wikipedia.org/wiki/Partition_(database)
for example projectA have tables (Shot, Asset) and projectB have the same tables with the same fields, but projectA and projectB are on different database or even servers. And using a common lookup project table, you can find which project points to which database, for you code to work with Why we're thinking about it? having each project individual database have some advantages: - easier to backup and restore ( much smaller set of data ) - easier to archive together with the entire project files ( cause that DB is isolated from the rest of the projects data ) - less table locking wait time, cause each project have different database and tables badness coming from this? - complexity ... each item needs a unique_id across all the tables, something like ( projectID_ID ) - complexity ... where do you store common tables ( Users for example ) - you can't do "join" across databases... do get all artists Tasks across shows become multiple queries, one per project any thoughts? -- You received this message because you are subscribed to the Google Groups "Python Programming for Autodesk Maya" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/python_inside_maya/6dbde745-cfdf-4609-ab09-714f99d37ba4%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
