| Index: third_party/sqlite/sqlite-src-3080704/tool/vdbe_profile.tcl
|
| diff --git a/third_party/sqlite/sqlite-src-3080704/tool/vdbe_profile.tcl b/third_party/sqlite/sqlite-src-3080704/tool/vdbe_profile.tcl
|
| deleted file mode 100644
|
| index fb1f955391ae2782147796fe9848a3c156bb184d..0000000000000000000000000000000000000000
|
| --- a/third_party/sqlite/sqlite-src-3080704/tool/vdbe_profile.tcl
|
| +++ /dev/null
|
| @@ -1,82 +0,0 @@
|
| -#!/bin/tclsh
|
| -#
|
| -# Run this script in the same directory as the "vdbe_profile.out" file.
|
| -# This script summarizes the results contained in that file.
|
| -#
|
| -if {![file readable vdbe_profile.out]} {
|
| - error "run this script in the same directory as the vdbe_profile.out file"
|
| -}
|
| -set in [open vdbe_profile.out r]
|
| -set stmt {}
|
| -set allstmt {}
|
| -while {![eof $in]} {
|
| - set line [gets $in]
|
| - if {$line==""} continue
|
| - if {[regexp {^---- } $line]} {
|
| - set stmt [lindex $line 1]
|
| - if {[info exists cnt($stmt)]} {
|
| - incr cnt($stmt)
|
| - set firsttime 0
|
| - } else {
|
| - set cnt($stmt) 1
|
| - set sql($stmt) {}
|
| - set firsttime 1
|
| - lappend allstmt $stmt
|
| - }
|
| - continue;
|
| - }
|
| - if {[regexp {^-- } $line]} {
|
| - if {$firsttime} {
|
| - append sql($stmt) [string range $line 3 end]\n
|
| - }
|
| - continue
|
| - }
|
| - if {![regexp {^ *\d+ *\d+ *\d+ *\d+ ([A-Z].*)} $line all detail]} continue
|
| - set c [lindex $line 0]
|
| - set t [lindex $line 1]
|
| - set addr [lindex $line 3]
|
| - set op [lindex $line 4]
|
| - if {[info exists opcnt($op)]} {
|
| - incr opcnt($op) $c
|
| - incr opcycle($op) $t
|
| - } else {
|
| - set opcnt($op) $c
|
| - set opcycle($op) $t
|
| - }
|
| - if {[info exists stat($stmt,$addr)]} {
|
| - foreach {cx tx detail} $stat($stmt,$addr) break
|
| - incr cx $c
|
| - incr tx $t
|
| - set stat($stmt,$addr) [list $cx $tx $detail]
|
| - } else {
|
| - set stat($stmt,$addr) [list $c $t $detail]
|
| - }
|
| -}
|
| -close $in
|
| -
|
| -foreach stmt $allstmt {
|
| - puts "********************************************************************"
|
| - puts [string trim $sql($stmt)]
|
| - puts "Execution count: $cnt($stmt)"
|
| - for {set i 0} {[info exists stat($stmt,$i)]} {incr i} {
|
| - foreach {cx tx detail} $stat($stmt,$i) break
|
| - if {$cx==0} {
|
| - set ax 0
|
| - } else {
|
| - set ax [expr {$tx/$cx}]
|
| - }
|
| - puts [format {%8d %12d %12d %4d %s} $cx $tx $ax $i $detail]
|
| - }
|
| -}
|
| -puts "********************************************************************"
|
| -puts "OPCODES:"
|
| -foreach op [lsort [array names opcnt]] {
|
| - set cx $opcnt($op)
|
| - set tx $opcycle($op)
|
| - if {$cx==0} {
|
| - set ax 0
|
| - } else {
|
| - set ax [expr {$tx/$cx}]
|
| - }
|
| - puts [format {%8d %12d %12d %s} $cx $tx $ax $op]
|
| -}
|
|
|