Correct. I would choose the same. ;) I'm glad I could help and good luck!
Cheers, CGS On Thu, Oct 6, 2011 at 10:43 AM, Pau Freixes <[email protected]> wrote: > Hi, > > On Thu, Oct 6, 2011 at 9:14 AM, CGS <[email protected]> wrote: > > Hi, > > > > Unfortunately, there isn't too much to do about but to change a bit the > > design of your DB. That means: > > > > Option 1: > > Change from continuous writing to bulk writing. That means you should > create > > a buffer for your writers in your application and when the buffer is > full, > > flush it to DB by the mean of bulk operation. In this way your writers > will > > allow DB to do some other operations in between bulk operation requests > and > > the writing time gets shorter. > > I can try to use a bulk buffer write and flush the buffer after N time or > happens some changes, with this method I will have a window time for > compact database. > > Thanks. > > -- > --pau >
