ok thank you On Sun, Oct 28, 2012 at 4:42 PM, Niphlod <[email protected]> wrote:
> glad that one was fixed. > BTW, fetch the sets only one time... instead of > for record in db(db.plugin_seq.id > 0).select(): > for primer_record in db(db.primer_seq_files.id>0).select(): > > do > > plugin_seq_tb = db(db.plugin_seq.id > 0).select() > primer_seq_files_tb = db(db.primer_seq_files.id>0).select() > > for record in plugin_seq_tb: > for primer_record in primer_seq_files_tb: > > > so you won't fetch the entire primer_seq_files table for every row of the > plugin_seq table > > -- > > > > --
