Wrong mailing list.
On Tue, Jul 22, 2014 at 10:29 AM, Daniel Drehmann < [email protected]> wrote: > Hello. I am new to mongodb and mongoose and therefore I have some > performance/improvement questions. In the past I did some applications with > databases where performance was never an issue, but in my current project > it is. It is a real time analytics tool.There I need to make very often > updates (where I only insert small pieces of values to an array) and very > few read operations. > > In my project I have the following schema for mongoose: > > var datawrapperSchema = new mongoose.Schema({ > name: { > type:String, > required: true > }, > origin_id: { > type:String, > required: true, > unique: true > }, > datasets : [{ > key : { type:String }, > type : { type:String }, > values : [{ > value: String, > timestamp: String, > level: String > }] > }] > }); > > > As you can see an array of datasets is nested in my datawrapper and an > array of values is nested in my datasets. Is this good practice or should I > try to separate the schemas for performance? > > Now I want to update very often the values in my datasets. I think for a > faster update performance I should use separated schemas to address the > datasets directly. I noticed that the roundtrip time (from client to > backend,write update in db, and back to frontend) increases in time. The > first roundtrip times are 40 ms and after 5 minutes they are around 200 ms. > Is can't imagine that this should be normal. > > Another problem is that my read operations on datawrappers which get > updates are really slow. I heard of an global lock and write>read, but how > to solve this? > > Thanks for your help! > > -- > You received this message because you are subscribed to the Google Groups > "mongoose-users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/mongoose-users. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "mongoose-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/mongoose-users. For more options, visit https://groups.google.com/d/optout.
