How to speed up writing array to sqlite db on unity?

Question

Android

Hello, the task is to fill the database with data from the array, there are 30.000+ elements in the array, and it takes longer than 7 minutes, to measure, it takes 5:15 minutes to loop 50k requests, and this is on a PC (target platform is android), in general, this Is it normal or am I doing something wrong?

public static void ExecuteQueryWithoutAnswer(string query)
  {
    OpenConnection();
    Debug.Log("001");
    for (int i = 0; i < 50000; i++)
    {
      query = "insert into Main (Name, LongCode, ShortCode, Price) values (1,1,1,1)";
    }
    command.CommandText = query;
    command.ExecuteNonQuery();

    }
    Debug.Log("002");
    CloseConnection();
  }

PS added a loop to the following construction, now the database is filled in a couple of seconds

using(SqliteTransaction transaction = connection.BeginTransaction())
{

}

Answer 1

Make one request, not 50 thousand.
Combine requests into one through a semicolon.
At least 100 lines.
Before executing requests, start a transaction
After - complete