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