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? -Bertrand
