mysql - How to create pseudo document oriented model? -
currently, using rails mysql backend. unfortunately, application has scaled in data not expected or foreseen when started. now, facing lot of performance issues increasing entries in database , activerecord taking hit due in-numerous queries fired result of enjoying relational logic.
i have come point feel paying penalty enjoying advantages of proper relational model. since speed has come under hammer, had research on document-oriented models mongo db , found offer speed compensating relational features.
my question here is, how migrate relational model document model. perhaps, store temporary schemas or tables returned , dump them bulk document on fly instead of setting proper document-oriented db (at least during initial phase). space not issue me. care time. then, cannot in 1 single sweep. know how approach problem, links/references kind of problem has been solved before appreciated.
i highly recommend against migrating document db unless data better suited such database.
migrating speed reasons bad idea, , should instead slow queries in existing ar based system , optimise them.
Comments
Post a Comment