Test benchmark using INSERT without batching

main_test.go

func BenchmarkCreate(b *testing.B) {
	db, err := gorm.Open("postgres", "host=localhost port=5432 user=testuser dbname=testdb password=123456 sslmode=disable")
	if err != nil {
		fmt.Println(err)
	}
	defer db.Close()

	users := stubUsers(b)
	tx := db.Begin()
	valueStrings := []string{}
	valueArgs := []interface{}{}
	for _, user := range users {
		valueStrings = append(valueStrings, "(?, ?)")
		valueArgs = append(valueArgs, user.Name)
		valueArgs = append(valueArgs, user.Password)
	}

	stmt := fmt.Sprintf("INSERT INTO users (name, password) VALUES %s", strings.Join(valueStrings, ","))
	err = tx.Exec(stmt, valueArgs...).Error
	if err != nil {
		tx.Rollback()
		fmt.Println(err)
	}
	err = tx.Commit().Error
	if err != nil {
		fmt.Println(err)
	}
}