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

Popular posts from this blog

python - Scipy curvefit RuntimeError:Optimal parameters not found: Number of calls to function has reached maxfev = 1000 -

c# - How to add a new treeview at the selected node? -

java - netbeans "Please wait - classpath scanning in progress..." -