jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nigel Sim <nigel....@gmail.com>
Subject Re: Performance of a large number of small nodes
Date Thu, 27 Aug 2009 23:35:43 GMT
Hi Bertrand,


2009/8/27 Bertrand Delacretaz <bdelacretaz@apache.org>

> Hi Nigel,
>
> On Thu, Aug 27, 2009 at 5:40 AM, Nigel Sim<nigel.sim@gmail.com> wrote:
> > ...In Jackrabbit the path looks like
> /<instrument>/<dataset>/YYYY/MM/DD/<value>
> >
> > I can probably improve the ingest time by an order of magnitude by more
> > intelligent session handling, but the retrieval also needs to be improved
> > and I don't know how. In the production system, using PostgreSQL as the
> back
> > end, with 100,000 points across 50 instruments, it takes about 3 seconds
> to
> > execute the query to retrieve the dataset. This needs to be < 1s at
> worst,
> > as it feeds other systems....
>
> What's the query?
>
> Find all values for a given instrument and dataset in a specific period of
> time?
>

Spot on.

Nigel

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message