Is mongodb a no-go for this application? -

good sirs. i've started planning new project, , seems should stick relational database, (even though want play mongo). tell me if i'm mistaken!

there box models, each of can contain hundreds thousands of items.

at time, user can move item box. example, using railsy pseudocode...

item = item(5676) item.box // returns 24 item.update(box:25) item.box // returns 25 

this sounds simple sql join table me, expensive array manipulation operation mongodb.

or removing object out of 1 (huge) array , inserting in (huge) array not big problem mongo?

thanks wisdom. i've started mongo.

if want use big arrays, stay away mongodb. tell personal experience. there 2 big problems arrays. if start grow, document grows , needs moved on disk. very, slow operation. plus if need scan array 10000 element, slow needs check 9999 before that.