You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-user@db.apache.org by Al Eridani <al...@gmail.com> on 2013/05/20 22:26:37 UTC
Indication of progress during long commits
I've been asked to find out whether it is possible to get some indication
of progress during commits that take a long time. Any ideas?
Thanks!
Re: Indication of progress during long commits
Posted by Al Eridani <al...@gmail.com>.
> Can you break the large commit into several smaller commits then
> display progress there?
No, the purpose of the large, single commit is transactional.
> Out of curiosity; how long is your commit?
It depends, but the ones that triggered the request are of the order of
tens of minutes.
> Are you saving larger binary objects or large volumes of rows?
There are no binary objects, just multiple inserts, updates and deletes.
It's not a big deal if there are no hooks. We can live with the way the
system is.
Al
On Tue, May 28, 2013 at 4:53 AM, Raymond Kroeker <ra...@gmail.com>wrote:
> Hi Al,
>
> Can you break the large commit into several smaller commits then
> display progress there?
> For example instead of, "Saving Account..." you could break it into
> "Saving spreadsheet 1 of 3..."
>
> The other option might be to collect a small set of historical samples
> of how long the commit takes; and "fake progress" there. Less work
> than refactoring I agree, but it might be a near term win.
>
> Out of curiosity; how long is your commit? Are you saving larger
> binary objects or large volumes of rows?
>
> On Tue, May 28, 2013 at 6:02 AM, Rick Hillegas <ri...@oracle.com>
> wrote:
> > On 5/20/13 1:26 PM, Al Eridani wrote:
> >>
> >> I've been asked to find out whether it is possible to get some
> indication
> >> of progress during commits that take a long time. Any ideas?
> >>
> >> Thanks!
> >>
> > Hi Al,
> >
> > I don't know a way to do this today. However, it might be an interesting
> > piece of instrumentation to add to the engine. Maybe something JMX-based.
> >
> > Thanks,
> > -Rick
>
>
>
> --
> ---------------------------------------------------------
> Raymond Kroeker
>
Re: Indication of progress during long commits
Posted by Raymond Kroeker <ra...@gmail.com>.
Hi Al,
Can you break the large commit into several smaller commits then
display progress there?
For example instead of, "Saving Account..." you could break it into
"Saving spreadsheet 1 of 3..."
The other option might be to collect a small set of historical samples
of how long the commit takes; and "fake progress" there. Less work
than refactoring I agree, but it might be a near term win.
Out of curiosity; how long is your commit? Are you saving larger
binary objects or large volumes of rows?
On Tue, May 28, 2013 at 6:02 AM, Rick Hillegas <ri...@oracle.com> wrote:
> On 5/20/13 1:26 PM, Al Eridani wrote:
>>
>> I've been asked to find out whether it is possible to get some indication
>> of progress during commits that take a long time. Any ideas?
>>
>> Thanks!
>>
> Hi Al,
>
> I don't know a way to do this today. However, it might be an interesting
> piece of instrumentation to add to the engine. Maybe something JMX-based.
>
> Thanks,
> -Rick
--
---------------------------------------------------------
Raymond Kroeker
Re: Indication of progress during long commits
Posted by Rick Hillegas <ri...@oracle.com>.
On 5/20/13 1:26 PM, Al Eridani wrote:
> I've been asked to find out whether it is possible to get some
> indication of progress during commits that take a long time. Any ideas?
>
> Thanks!
>
Hi Al,
I don't know a way to do this today. However, it might be an interesting
piece of instrumentation to add to the engine. Maybe something JMX-based.
Thanks,
-Rick