Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import "github.com/jinzhu/gorm"
- databaseURL:= "user=abc password=abc dbname=db host=localhost port=5432"
- db, err := gorm.Open("postgres", databaseURL)
- if err != nil {
- fmt.Printf("DBERR %s", err.Error())
- }
- db.DB().SetMaxIdleConns(10)
- db.DB().SetMaxOpenConns(10)
- db.LogMode(true)
- m := &MessageDetailRecord{
- AccountId: 123,
- SubAccountId: 456,
- }
- query := "INSERT INTO Table(accountid, subaccountid) VALUES (?,?);"
- a := time.Now()
- tx := db.Begin()
- for i:=0 ; i<100 ; i++ {
- _ = tx.Exec(query, m.AccountId, m.SubAccountId).Error
- }
- tx.Commit()
- delta := time.Now().Sub(a)
- fmt.Println(delta.Nanoseconds())
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement