TrinhTrungDung
/ docker-compose.yml
Last active
March 22, 2020 02:43
Create new container which has PostgreSQL database
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| version: "3" | |
| services: | |
| db: | |
| image: postgres | |
| container_name: test.db | |
| ports: | |
| - "5432:5432" | |
| environment: | |
| POSTGRES_DB: testdb | |
| POSTGRES_USER: testuser |
TrinhTrungDung
/ main.go
Created
March 20, 2020 11:59
Connect to the database created by docker container
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| package main | |
| import ( | |
| "fmt" | |
| "github.com/jinzhu/gorm" | |
| _ "github.com/jinzhu/gorm/dialects/postgres" | |
| ) | |
| func main() { |
TrinhTrungDung
/ main.go
Last active
March 20, 2020 12:04
Add sample table and migrate to the database
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| package main | |
| import ( | |
| "fmt" | |
| "github.com/jinzhu/gorm" | |
| _ "github.com/jinzhu/gorm/dialects/postgres" | |
| ) | |
| type User struct { |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| package main | |
| import ( | |
| "math/rand" | |
| "testing" | |
| ) | |
| const letters = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ" | |
| func genRandomString(length int) string { |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| func BenchmarkOrmCreate(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) | |
| for _, user := range users { | |
| db.Create(user) |
TrinhTrungDung
/ main_test.go
Created
March 20, 2020 12:34
Test benchmark using INSERT without batching
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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{} |
TrinhTrungDung
/ main_test.go
Created
March 20, 2020 14:38
Test bulk create using INSERT statement with batching
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| func BenchmarkBulkCreate(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) | |
| size := 500 | |
| tx := db.Begin() |
TrinhTrungDung
/ main_test.go
Created
March 20, 2020 16:04
Test helper function with dynamic batching size
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| func benchmarkBulkCreate(size int, 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() | |
| chunkList := funk.Chunk(users, size) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| func BenchmarkBulkCreateSize1(b *testing.B) { | |
| benchmarkBulkCreate(1, b) | |
| } | |
| func BenchmarkBulkCreateSize100(b *testing.B) { | |
| benchmarkBulkCreate(100, b) | |
| } | |
| func BenchmarkBulkCreateSize500(b *testing.B) { | |
| benchmarkBulkCreate(500, b) |
TrinhTrungDung
/ main_test.go
Last active
March 20, 2020 16:33
Test benchmark with different batch sizes
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| func benchmarkBulkCreate(size int, 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() | |
| chunkList := funk.Chunk(users, size) |
OlderNewer