Skip to content

Instantly share code, notes, and snippets.

@sitano
Created May 25, 2015 10:41
Show Gist options
  • Save sitano/a9260aac7bd40bc5310b to your computer and use it in GitHub Desktop.
Save sitano/a9260aac7bd40bc5310b to your computer and use it in GitHub Desktop.
diff for github.com/cznic/ql, issue99_test, a8fb57c..cb5e47f
diff --git a/issue99_test.go b/issue99_test.go
index a8fb57c..cb5e47f 100644
--- a/issue99_test.go
+++ b/issue99_test.go
@@ -10,6 +10,8 @@ import (
"strconv"
"strings"
"sync"
+ "time"
+ "fmt"
"testing"
)
@@ -153,106 +155,106 @@ func createTablesIssue99(db *sql.DB) error {
Name string,
Address string,
Health bool,
- C0 string,
- C1 string,
- C2 string,
- C3 string,
- C4 string,
- C5 string,
- C6 string,
- C7 string,
- C8 string,
- C9 string,
- C10 string,
- C11 string,
- C12 string,
- C13 string,
- C14 string,
- C15 string,
- C16 string,
- C17 string,
- C18 string,
- C19 string,
- C20 string,
- C21 string,
- C22 string,
- C23 string,
- C24 string,
- C25 string,
- C26 string,
- C27 string,
- C28 string,
- C29 string,
- C30 string,
- C31 string,
- C32 string,
- C33 string,
- C34 string,
- C35 string,
- C36 string,
- C37 string,
- C38 string,
- C39 string,
- C40 string,
- C41 string,
- C42 string,
- C43 string,
- C44 string,
- C45 string,
- C46 string,
- C47 string,
- C48 string,
- C49 string,
- C50 string,
- C51 string,
- C52 string,
- C53 string,
- C54 string,
- C55 string,
- C56 string,
- C57 string,
- C58 string,
- C59 string,
- C60 string,
- C61 string,
- C62 string,
- C63 string,
- C64 string,
- C65 string,
- C66 string,
- C67 string,
- C68 string,
- C69 string,
- C70 string,
- C71 string,
- C72 string,
- C73 string,
- C74 string,
- C75 string,
- C76 string,
- C77 string,
- C78 string,
- C79 string,
- C80 string,
- C81 string,
- C82 string,
- C83 string,
- C84 string,
- C85 string,
- C86 string,
- C87 string,
- C88 string,
- C89 string,
- C90 string,
- C91 string,
- C92 string,
- C93 string,
- C94 string,
- C95 string,
- C96 string,
- C97 string,
- C98 string,
- C99 string,
+ C0 string DEFAULT "",
+ C1 string DEFAULT "",
+ C2 string DEFAULT "",
+ C3 string DEFAULT "",
+ C4 string DEFAULT "",
+ C5 string DEFAULT "",
+ C6 string DEFAULT "",
+ C7 string DEFAULT "",
+ C8 string DEFAULT "",
+ C9 string DEFAULT "",
+ C10 string DEFAULT "",
+ C11 string DEFAULT "",
+ C12 string DEFAULT "",
+ C13 string DEFAULT "",
+ C14 string DEFAULT "",
+ C15 string DEFAULT "",
+ C16 string DEFAULT "",
+ C17 string DEFAULT "",
+ C18 string DEFAULT "",
+ C19 string DEFAULT "",
+ C20 string DEFAULT "",
+ C21 string DEFAULT "",
+ C22 string DEFAULT "",
+ C23 string DEFAULT "",
+ C24 string DEFAULT "",
+ C25 string DEFAULT "",
+ C26 string DEFAULT "",
+ C27 string DEFAULT "",
+ C28 string DEFAULT "",
+ C29 string DEFAULT "",
+ C30 string DEFAULT "",
+ C31 string DEFAULT "",
+ C32 string DEFAULT "",
+ C33 string DEFAULT "",
+ C34 string DEFAULT "",
+ C35 string DEFAULT "",
+ C36 string DEFAULT "",
+ C37 string DEFAULT "",
+ C38 string DEFAULT "",
+ C39 string DEFAULT "",
+ C40 string DEFAULT "",
+ C41 string DEFAULT "",
+ C42 string DEFAULT "",
+ C43 string DEFAULT "",
+ C44 string DEFAULT "",
+ C45 string DEFAULT "",
+ C46 string DEFAULT "",
+ C47 string DEFAULT "",
+ C48 string DEFAULT "",
+ C49 string DEFAULT "",
+ C50 string DEFAULT "",
+ C51 string DEFAULT "",
+ C52 string DEFAULT "",
+ C53 string DEFAULT "",
+ C54 string DEFAULT "",
+ C55 string DEFAULT "",
+ C56 string DEFAULT "",
+ C57 string DEFAULT "",
+ C58 string DEFAULT "",
+ C59 string DEFAULT "",
+ C60 string DEFAULT "",
+ C61 string DEFAULT "",
+ C62 string DEFAULT "",
+ C63 string DEFAULT "",
+ C64 string DEFAULT "",
+ C65 string DEFAULT "",
+ C66 string DEFAULT "",
+ C67 string DEFAULT "",
+ C68 string DEFAULT "",
+ C69 string DEFAULT "",
+ C70 string DEFAULT "",
+ C71 string DEFAULT "",
+ C72 string DEFAULT "",
+ C73 string DEFAULT "",
+ C74 string DEFAULT "",
+ C75 string DEFAULT "",
+ C76 string DEFAULT "",
+ C77 string DEFAULT "",
+ C78 string DEFAULT "",
+ C79 string DEFAULT "",
+ C80 string DEFAULT "",
+ C81 string DEFAULT "",
+ C82 string DEFAULT "",
+ C83 string DEFAULT "",
+ C84 string DEFAULT "",
+ C85 string DEFAULT "",
+ C86 string DEFAULT "",
+ C87 string DEFAULT "",
+ C88 string DEFAULT "",
+ C89 string DEFAULT "",
+ C90 string DEFAULT "",
+ C91 string DEFAULT "",
+ C92 string DEFAULT "",
+ C93 string DEFAULT "",
+ C94 string DEFAULT "",
+ C95 string DEFAULT "",
+ C96 string DEFAULT "",
+ C97 string DEFAULT "",
+ C98 string DEFAULT "",
+ C99 string DEFAULT "",
);`); err != nil {
return err
}
@@ -314,6 +316,8 @@ func issue99FillB(db *sql.DB) (int, error) {
func testIssue99(tb testing.TB, db *sql.DB) int {
sum := 0
for i := 0; i < issue99Cycles; i++ {
+ start := time.Now()
+
if err := createTablesIssue99(db); err != nil {
tb.Fatal(err)
}
@@ -324,6 +328,8 @@ func testIssue99(tb testing.TB, db *sql.DB) int {
}
sum += n2
+
+ fmt.Printf("Inserted for %d ms\n", time.Now().Sub(start) / time.Millisecond)
}
return sum
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment