samedi 14 mars 2015

in matlab, query sqlite 1000 times, 100 records each time, not enough memory

in matlab, query sqlite 1000 times, 100 records each time, not enough memory



for sample_index = sample_indices % 1000 samples
command_text = sprintf('select * from test_table where id="%s" limit %d,%d', id, sample_index, feature_count);
statement = database.prepare(command_text);
for i = 1:feature_count % feature_count = 100
statement.step();
for i=1:6
X(current_sample_index, current_feature_index) = statement.columnValue(1+i);
current_feature_index = current_feature_index + 1;
end
end
current_sample_index
current_sample_index = current_sample_index + 1;
statement.dispose();


end


Aucun commentaire:

Enregistrer un commentaire