Very slow performance

[pawelsalawa]

(This issue was migrated from the old bug tracker of SQLiteStudio)

Original ID from old bug tracker: 3315
Originally created at: Fri May 12 06:59:08 2017
Originally last updated at: Fri May 12 06:59:08 2017

When committing entries in the datagrid view, approximately 700 ms per row. Table has approximately 30 columns.

Pasting data into table prior to committing also very sluggish\n\nOperating system:\nWindows 7\n\nVersion:\n3.1.1

[pawelsalawa]

Originally created at: Fri May 12 06:59:08 2017

Added note
Table has 21k rows before entry.
Entry contains 950 rows.

[pawelsalawa]

Originally created at: Fri May 12 06:59:08 2017

If you do an INSERT statement (instead of pasting it) for a single row, including commit - does it work faster this way?

I'm asking to find out whether there is (or not) any database design factor that causes this.

[pawelsalawa]

Originally created at: Fri May 12 06:59:08 2017

What about inserting one row at the time using SQL editor and "INSERT INTO" statement? Is it just as slow?