Skip to content

Instantly share code, notes, and snippets.

@arnold-parge

arnold-parge/best_db_sql_fetch_from_db.dart

Created May 31, 2020 16:48
Show Gist options
  • Save arnold-parge/b539f67f8fe6845fc74960a598d1dc4b to your computer and use it in GitHub Desktop.
Save arnold-parge/b539f67f8fe6845fc74960a598d1dc4b to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. arnold-parge created this gist May 31, 2020.
    8 changes: 8 additions & 0 deletions best_db_sql_fetch_from_db.dart
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,8 @@
    static Future<List<UserModel>> getAll() async {
    var fetchStartTime = DateTime.now().millisecondsSinceEpoch;
    var rawUsers = await AppSqliteDb.sqliteDb.query(UserModel.tableName);
    var fetchEndTime = DateTime.now().millisecondsSinceEpoch;
    appWarning(
    'Time taken to fetch 1000 users from db: ${fetchEndTime - fetchStartTime}ms');
    return rawUsers.map((snap) => UserModel.fromDb(snap)).toList();
    }