> On 3/18/06, Daniel Franke <[EMAIL PROTECTED]> wrote:
> > At Thursday I wrote:
> > > Since there's so much interest in this, I'll submit a couple of timings
> > > as soon as possible =)
On Monday 20 March 2006 15:27, Jay Sprenkle wrote:
> Thanks for posting those!
> Is that good enough performance for you?
It should be fine. Those Queries are done before analysing the data. Since
that software (again) uses flat files, we export the validated date chunks
once. If this takes a minute or two, nobody bothers. The subsequent analysis
can easily takes hours or even days ...
One query took about 10 minutes. As D. Hipp pointed out, another index will
speed that one up as well. My (uninformed) beforehand guess was that queries
could take hours to complete. That's not the case and therefore I don't have
to switch database backends =)
Btw, according to top, memeory usage never exceeded a couple of MB while
accessing the db. I assume this associates to the (default) cache size?
Daniel
