Test Go Code

gistfile1.go

package main

import (
	"database/sql"
	_ "github.com/go-sql-driver/mysql"
)

import "fmt"

func main() {
	con, err := sql.Open("mysql", "root:@/test")
	defer con.Close()
	if err != nil {
		fmt.Println(err)
		return
	}

	stmt, err := con.Prepare("select id,b,c,d,e from test where z = ? order by id desc limit 10000")
	if err != nil {
		fmt.Println(err)
	}
	defer stmt.Close()

	var total int = 0
	for i := 0; i < 10000; i++ {
		rows, err := stmt.Query(1234)
		defer rows.Close()

		if err != nil {
			fmt.Println(err)
			return 
		}
  
		type Result [4]int

		for rows.Next() {
			var id int
			var result Result
			if err := rows.Scan(&id, &result[0], &result[1], &result[2], &result[3]); err != nil {
				fmt.Println(err)
				return
			}
			total += (id + result[0] + result[1] + result[2] + result[3]) 
		}
	} 
	fmt.Println(total)
}