Select Code to Download

-- 1000,000 rows
CREATE TABLE cell (
...
CREATE INDEX idx_met_cell_id ON met (met_cell_id)
CREATE INDEX idx_cell_lc ON cell_lc (cell_id)
CREATE INDEX idx_cell_dist ON cell_dist (cell_id)

[1] First retrieve all data from cell table
SELECT * FROM cell WHERE cell_id = :cell_id
...

[4] Retrieve the related met
SELECT * FROM met WHERE met_cell_id = <met_cell_id from query [1] abov
+e>

[08:38 AM] ~/Data/carbonmodel$perl carbonmodel.pl

...
timethis 100:  3 wallclock secs ( 2.85 usr +  0.20 sys =  3.05 CPU) @ 
+32.79/s (n=100)

timethis 1000: 33 wallclock secs (31.08 usr +  1.22 sys = 32.30 CPU) @
+ 30.96/s (n=1000)

timethis 1000: 783 wallclock secs (732.26 usr + 18.22 sys = 750.48 CPU
+) @  1.33/s (n=1000)

CREATE TABLE cell_blobs (cell_id INTEGER PRIMARY KEY, cell_data BLOB);