Re: [Pytables-users] speed of selecting from table vs numpy.where with array

2009-07-01 Thread Richard Llewellyn
Oops. I thought I was reading the array off disk for the speed test, but apparently the array was already in RAM. Changing this so that I read the array, eg where(a[:] == id), takes about the same time as searching for the id value in a table. Sorry about that. Rich ---

[Pytables-users] speed of selecting from table vs numpy.where with array

2009-07-01 Thread Richard Llewellyn
I've been finding pytables useful for organizing big genomics data (e.g. storing and querying ~200 Gb all vs all uniparc smith-waterman hits from Uniprot). One thing that has surprised me a little: I was interested in the efficiency of querying small tables storing an index (integer) and an integ