[Pytables-users] Faster Performance: A set of nodes vs A new column that ranges within a set?

[Jacob B. <jac...@gm...>]

Hello PyTables Users & Contributors,

Just a quick question, let's say that I have certain identifiers that link
to a set of data. Would it generally be faster for lookup to have each set
a data as a separate table with an id as the tables name or to add this id
as another column to a universal table of data and then let the in-kernel
search query data only with a specific id?

I hope you can understand my question would 1,000 tables of 100,000 records
each be better for searching than 1 table with 100 million records and one
extra id column?

Thanks,
Jacob Bennett

-- 
Jacob Bennett
Massachusetts Institute of Technology
Department of Electrical Engineering and Computer Science
Class of 2014| ben...@mi...