Hi Bertrand,
2009/8/27 Bertrand Delacretaz <[email protected]> > Hi Nigel, > > On Thu, Aug 27, 2009 at 5:40 AM, Nigel Sim<[email protected]> 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
