By user2432951 I’m making an cross-platform application that should write values to a SQLite database. Right now it writes really slow and it freezes after a while.
I’m calling this code each 10ms:
SQLQueryInsert.SQL.Text := ‘insert into task (id, latitude) values (:id, :lat)’;
SQLQueryInsert.Prepared := true;
SQLQueryInsert.ParamByName(‘id’).AsInteger := 1;
SQLQueryInsert.ParamByName(‘latitude’).AsFloat := 12332145;
SQLQueryInsert.ExecSQL();
Any suggestions? …read more
Via: StackOverflow