SQLite ускорить SELECT

153
12 мая 2019, 08:40
ObservableCollection<Log> logs = new ObservableCollection<Log>();
using(var connection = new SQLiteConnection(Globals.connection)) {
    connection.Open();
    using (var command = new SQLiteCommand("SELECT id, text FROM logs", connection)) {
      using(var reader = command.ExecuteReader()) {
        while(reader.Read()) {
          logs.Add(new Log() {
            Id = (long)reader[0],
            Text = (string)reader[1]
          });
        }
      }
    }
  connection.Close();
}

При примерно 4500 строк запрос занимает 5 - 10 секунд. Как можно ускорить SELECT в SQLite?

READ ALSO