for
for i:=0;i<500;i++ {
// Create a string of 500 values to be inserted at once
}
// Insert the 500 values
commit()
Conceptually, I'd like to have something like;
// Create connection to DB
// Begin a transaction
// Prepare a statement
go timelyCommits(tx) // spawn a commit ticker
for {
// Constantly create string of values to be inserted like:
// Values (1, "one"),(2,"two"),(3,"three")...(1000,"thousand")...
// Insert without commit
}
func timelyCommits(tx){
for {
time.Sleep(1 * time.Second)
tx.Commit()
}
}