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 <pfreixes@gmail.com> wrote:
> Hi,
>
> On Thu, Oct 6, 2011 at 9:14 AM, CGS <cgsmcmlxxv@gmail.com> 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
>
|