jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bertrand Delacretaz <bdelacre...@apache.org>
Subject Re: Performance of a large number of small nodes
Date Thu, 27 Aug 2009 11:09:31 GMT
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?

-Bertrand

Mime
View raw message