Displaying 1 result from an estimated 1 matches for "logdata_001".
Did you mean:
logdata_002
2007 Jan 23
11
dynamic tablenames
...ment data is stored in a raw positioned file format, which I''m not
keeping).
For performance reasons I''m thinking about storing the data for each
entity in separate tables. So instead of a ''logdata'' table with >200
million rows, I''d create ''logdata_001'', ''logdata_002'',... tables where
the rowcount of even the biggest entity logdata stays below 3 million.
Rails seems to have no problem with me setting the tablename
(set_table_name) on each incoming request before accessing the database.
I have this gut feeling though...