I'm running the following query directly in Sequel:
db["select oracle_time from #{packet} where (rowid,0) in (select
rowid, mod(rownum,#{num/1000}) from #{packet})"]
where packet contains the name of my table and num/1000 works out to
50. Basically I'm subsampling my data since I have too much to return.
When I run this query in the Oracle SQL Developer it takes 1.25s. When
I run it in Sequel and profile using the Ruby profiler it takes 11s.
It looks like most of the time is being spent in Array#include? and
String#==. Is there anything I can do to improve the speed? Here is
the trace:
Using the standard Ruby profiler.
% cumulative self self total
time seconds seconds calls ms/call ms/call name
47.26 5.16 5.16 1515 3.41 4.94 Array#include?
21.30 7.49 2.33 249474 0.01 0.01 String#==
4.16 7.94 0.45 204 2.23 54.00 Array#each
3.31 8.30 0.36 17 21.24 75.41 Kernel.require
2.44 8.57 0.27 1476 0.18 0.61
OCI8::Metadata::Base#__type_string
2.42 8.83 0.26 1476 0.18 0.34 Proc#call
2.02 9.05 0.22 12974 0.02 0.02 Symbol#to_s
1.85 9.26 0.20 63 3.21 7.16 Array#map
1.57 9.43 0.17 3533 0.05 0.05
OCI8::Metadata::Column#precision
1.56 9.60 0.17 1476 0.12 0.15
Module#module_eval
1.28 9.74 0.14 2214 0.06 0.06
OCI8::Metadata::Base#__boolean
0.84 9.83 0.09 6519 0.01 0.01 Hash#default
0.58 9.89 0.06 739 0.09 0.09
OCI8::Metadata::Base#__text
0.58 9.96 0.06 760 0.08 0.08
OCI8::Metadata::Column#data_size
0.56 10.02 0.06 760 0.08 0.08
OCI8::Metadata::Column#charset_form
0.44 10.07 0.05 1476 0.03 0.65
OCI8::Metadata::Column#type_string
0.43 10.11 0.05 1 47.00 812.00 Sequel.k_require
0.43 10.16 0.05 738 0.06 0.08
OCI8::Metadata::Column#fsprecision
0.42 10.21 0.05 1527 0.03 0.03
Module#method_added
0.42 10.25 0.05 2301 0.02 0.03
OCI8::Metadata::Column#scale
0.29 10.28 0.03 2214 0.01 0.08
OCI8::Metadata::Column#nullable?
0.28 10.31 0.03 2301 0.01 0.01
OCI8::Metadata::Base#__sb1
0.28 10.35 0.03 84 0.37 0.37
Class#inherited_with_inheritable_attributes
0.28 10.38 0.03 2955 0.01 0.01
OCI8::Metadata::Base#__ub2
0.28 10.41 0.03 1587 0.02 0.02 Fixnum#to_s
0.28 10.44 0.03 6 5.17 5.17 Array#collect
0.28 10.47 0.03 1586 0.02 0.02
Kernel.respond_to?
0.28 10.50 0.03 747 0.04 0.04 NilClass#nil?
0.28 10.53 0.03 739 0.04 0.13
OCI8::Metadata::Column#name
0.28 10.56 0.03 515 0.06 0.06
Object#method_added
0.28 10.59 0.03 760 0.04 0.04
OCI8::Metadata::Base#__ub4
0.28 10.63 0.03 2293 0.01 0.01 Kernel.is_a?
0.28 10.66 0.03 7982 0.00 0.00
OCI8::Metadata::Base#__ub1
0.15 10.67 0.02 2 8.00 8.00 Integer#upto
0.15 10.69 0.02 5 3.20 9.60 Hash#each
0.15 10.70 0.02 1 16.00 16.00
Syck::Parser#load
0.15 10.72 0.02 38 0.42 0.42
ActiveSupport::Dependencies.constant_watch_stack
0.15 10.74 0.02 8 2.00 3.87
Sequel::Dataset#quote_identifier
0.15 10.75 0.02 3 5.33 5.33
Range#include_without_range?
0.15 10.77 0.02 3533 0.00 0.00
OCI8::Metadata::Base#__is_implicit?
0.15 10.78 0.02 738 0.02 0.02
OCI8::Metadata::Column#char_size
0.15 10.80 0.02 743 0.02 0.02 String#to_sym
0.15 10.82 0.02 738 0.02 0.06
Sequel::Database#column_schema_to_ruby_default
0.15 10.83 0.02 1569 0.01 0.01 Hash#[]=
0.14 10.85 0.02 20 0.75 0.75 String#blank?
0.14 10.86 0.02 818 0.02 0.02 String#split
0.14 10.88 0.02 21 0.71 0.71 Module#private
0.14 10.89 0.02 1476 0.01 0.01
Sequel::Model::ClassMethods.overridable_methods_module
0.14 10.91 0.01 40 0.37 0.37
ActiveSupport::Inflector.constantize
0.14 10.92 0.01 8 1.87 1.87
Sequel::Dataset#quoted_identifier
0.00 10.92 0.00 2 0.00 0.00 String#replace
0.00 10.92 0.00 2 0.00 0.00 Set#include?
0.00 10.92 0.00 9 0.00 0.00 File#expand_path
0.00 10.92 0.00 2 0.00 0.00 Set#add
0.00 10.92 0.00 19 0.00 0.00
ActiveSupport::Dependencies.mechanism
0.00 10.92 0.00 194 0.00 0.00 Symbol#==
0.00 10.92 0.00 19 0.00 0.00
ActiveSupport::Dependencies.load?
0.00 10.92 0.00 21 0.00 0.00
ActiveSupport::Dependencies.log
0.00 10.92 0.00 3 0.00 0.00
ActiveSupport::Dependencies.loaded
0.00 10.92 0.00 1 0.00 0.00
ActiveSupport::Dependencies.warnings_on_first_load
0.00 10.92 0.00 6 0.00 0.00 Regexp#=~
0.00 10.92 0.00 5 0.00 0.00 String#[]
0.00 10.92 0.00 12 0.00 0.00 String#gsub
0.00 10.92 0.00 14 0.00 0.00 String#upcase
0.00 10.92 0.00 1 0.00 0.00
ActiveSupport::Inflector.camelize
0.00 10.92 0.00 1 0.00 0.00 String#camelize
0.00 10.92 0.00 2 0.00 0.00 Array#uniq!
0.00 10.92 0.00 1 0.00 15.00
ActiveSupport::Dependencies.loadable_constants_for_path
0.00 10.92 0.00 1 0.00 0.00
ActiveSupport::Dependencies.search_for_file
0.00 10.92 0.00 4 0.00 0.00 File#file?
0.00 10.92 0.00 4 0.00 0.00 File#join
0.00 10.92 0.00 39 0.00 0.00 Module#constants
0.00 10.92 0.00 38 0.00 0.00
Module#local_constants
0.00 10.92 0.00 2 0.00 0.00
ActiveSupport::Dependencies.autoload_paths
0.00 10.92 0.00 38 0.00 6.97
Module#local_constant_names
0.00 10.92 0.00 76 0.00 0.00 Hash#[]
0.00 10.92 0.00 19 0.00 8.95
ActiveSupport::Dependencies::WatchStack#watch_namespaces
0.00 10.92 0.00 26 0.00 0.00 IO#set_encoding
0.00 10.92 0.00 6 0.00 0.00
Exception#set_backtrace
0.00 10.92 0.00 33 0.00 0.45 Class#new
0.00 10.92 0.00 39 0.00 0.00 Array#last
0.00 10.92 0.00 42 0.00 0.00 Array#-
0.00 10.92 0.00 73 0.00 0.00 Array#concat
0.00 10.92 0.00 42 0.00 0.00 Array#pop
0.00 10.92 0.00 19 0.00 0.00
ActiveSupport::Dependencies::WatchStack#pop_modules
0.00 10.92 0.00 19 0.00 5.79
ActiveSupport::Dependencies::WatchStack#new_constants
0.00 10.92 0.00 20 0.00 0.00 Array#*
0.00 10.92 0.00 19 0.00 133.26
ActiveSupport::Dependencies.new_constants_in
0.00 10.92 0.00 18 0.00 0.00 Array#blank?
0.00 10.92 0.00 18 0.00 88.56
ActiveSupport::Dependencies::Loadable.load_dependency
0.00 10.92 0.00 17 0.00 91.00
ActiveSupport::Dependencies::Loadable.require
0.00 10.92 0.00 3 0.00 0.00
NameError#initialize
0.00 10.92 0.00 1 0.00 0.00 Hash#merge!
0.00 10.92 0.00 21 0.00 0.00
Hash#initialize_copy
0.00 10.92 0.00 17 0.00 0.00 Hash#merge
0.00 10.92 0.00 12 0.00 0.00 Thread#current
0.00 10.92 0.00 14 0.00 0.00 Mutex#lock
0.00 10.92 0.00 1 0.00 0.00 Regexp#===
0.00 10.92 0.00 97 0.00 0.00
Kernel.respond_to_missing?
0.00 10.92 0.00 6 0.00 0.00
Exception#initialize
0.00 10.92 0.00 84 0.00 0.00
Class#inheritable_attributes
0.00 10.92 0.00 109 0.00 0.00
Kernel.instance_variable_set
0.00 10.92 0.00 1 0.00 0.00 Array#reject
0.00 10.92 0.00 515 0.00 0.00
Object#blank_slate_method_added
0.00 10.92 0.00 21 0.00 0.00 Regexp#escape
0.00 10.92 0.00 82 0.00 0.00
BasicObject#singleton_method_added
0.00 10.92 0.00 5 0.00 0.00 Kernel.caller
0.00 10.92 0.00 2 0.00 0.00
Module#instance_methods
0.00 10.92 0.00 2 0.00 0.00
String#underscore
0.00 10.92 0.00 1 0.00 0.00 BlankSlate#hide
0.00 10.92 0.00 30 0.00 0.00 Array#join
0.00 10.92 0.00 1 0.00 0.00 ENV.[]
0.00 10.92 0.00 1 0.00 0.00
OCI8::Win32Util.dll_path
0.00 10.92 0.00 1 0.00 0.00
OCI8::Win32Util.enum_homes
0.00 10.92 0.00 3 0.00 0.00 File#dirname
0.00 10.92 0.00 1 0.00 0.00 File#initialize
0.00 10.92 0.00 1 0.00 0.00
Syck::Parser#initialize
0.00 10.92 0.00 1 0.00 0.00 Syck.resolver
0.00 10.92 0.00 1 0.00 0.00
Syck::Parser#set_resolver
0.00 10.92 0.00 1 0.00 0.00 Syck.parser
0.00 10.92 0.00 1 0.00 0.00 IO#binmode
0.00 10.92 0.00 8 0.00 0.00 IO#read
0.00 10.92 0.00 301 0.00 0.00 #<Syck::Resolver:
0x11b6e90>.node_import
0.00 10.92 0.00 2 0.00 0.00
ActiveSupport::Inflector.underscore
0.00 10.92 0.00 1 0.00 16.00 Syck.load
0.00 10.92 0.00 1 0.00 0.00 IO#close
0.00 10.92 0.00 1 0.00 16.00 IO#open
0.00 10.92 0.00 1 0.00 16.00 Syck.load_file
0.00 10.92 0.00 2238 0.00 0.00 Kernel.nil?
0.00 10.92 0.00 1 0.00 0.00 OCI8#encoding=
0.00 10.92 0.00 2 0.00 477.00 Kernel.load
0.00 10.92 0.00 1 0.00 47.00
ActiveSupport::Dependencies::Loadable.load
0.00 10.92 0.00 8 0.00 0.00
Module#blankslate_original_append_features
0.00 10.92 0.00 8 0.00 0.00
Module#append_features
0.00 10.92 0.00 8 0.00 0.00 Module#included
0.00 10.92 0.00 8 0.00 0.00 Module#include
0.00 10.92 0.00 28 0.00 1.11
Module#attr_reader
0.00 10.92 0.00 8 0.00 0.00
OCI8::OracleVersion#initialize
0.00 10.92 0.00 1 0.00 0.00
OCI8#oracle_client_vernum
0.00 10.92 0.00 5 0.00 0.00 Fixnum#&
0.00 10.92 0.00 4 0.00 0.00 Fixnum#>>
0.00 10.92 0.00 1 0.00 0.00
Date::Format::Bag#initialize
0.00 10.92 0.00 11 0.00 0.00 String#chomp!
0.00 10.92 0.00 22 0.00 0.00 String#intern
0.00 10.92 0.00 11 0.00 0.00
Date::Format::Bag#method_missing
0.00 10.92 0.00 7 0.00 0.00 String#sub!
0.00 10.92 0.00 8 0.00 0.00 String#to_i
0.00 10.92 0.00 2 0.00 0.00 Fixnum#**
0.00 10.92 0.00 6 0.00 0.00 Integer#integer?
0.00 10.92 0.00 45 0.00 0.00 Fixnum#div
0.00 10.92 0.00 3 0.00 0.00 Rational#convert
0.00 10.92 0.00 3 0.00 0.00 Kernel.Rational
0.00 10.92 0.00 1 0.00 0.00 Date#_parse_time
0.00 10.92 0.00 16 0.00 0.00 Hash#keys
0.00 10.92 0.00 1 0.00 0.00 Date#_parse_day
0.00 10.92 0.00 1 0.00 0.00 Date#_parse_eu
0.00 10.92 0.00 1 0.00 0.00 Date#_parse_us
0.00 10.92 0.00 2 0.00 0.00 String#downcase!
0.00 10.92 0.00 1 0.00 0.00 Date#s3e
0.00 10.92 0.00 1 0.00 0.00 Date#_parse_iso
0.00 10.92 0.00 1 0.00 0.00 Hash#reject
0.00 10.92 0.00 1 0.00 0.00
Date::Format::Bag#to_hash
0.00 10.92 0.00 1 0.00 0.00 Date#_parse
0.00 10.92 0.00 1 0.00 0.00
Date#rewrite_frags
0.00 10.92 0.00 15 0.00 0.00 Hash#values_at
0.00 10.92 0.00 14 0.00 0.00 Array#compact
0.00 10.92 0.00 1 0.00 0.00 Array#select
0.00 10.92 0.00 61 0.00 0.00 Fixnum#<=>
0.00 10.92 0.00 21 0.00 0.00 Array#<=>
0.00 10.92 0.00 1 0.00 0.00
Enumerable.sort_by
0.00 10.92 0.00 1 0.00 0.00 Enumerable.min
0.00 10.92 0.00 1 0.00 0.00
Date#complete_frags
0.00 10.92 0.00 5 0.00 0.00 Enumerable.all?
0.00 10.92 0.00 5 0.00 0.00 Fixnum#/
0.00 10.92 0.00 8 0.00 0.00 Float#floor
0.00 10.92 0.00 4 0.00 0.00 Float#*
0.00 10.92 0.00 1 0.00 0.00 #<Module:
0xbb8918>.civil_to_jd
0.00 10.92 0.00 1 0.00 0.00 Fixnum#-
0.00 10.92 0.00 1 0.00 0.00 #<Module:
0xbb8918>.jd_to_civil
0.00 10.92 0.00 1 0.00 0.00 Array#==
0.00 10.92 0.00 1 0.00 0.00 #<Module:
0xbb8918>._valid_civil?
0.00 10.92 0.00 1 0.00 0.00 Kernel.throw
0.00 10.92 0.00 1 0.00 0.00 Kernel.catch
0.00 10.92 0.00 1 0.00 0.00
Date#valid_date_frags?
0.00 10.92 0.00 2 0.00 0.00 String#tr!
0.00 10.92 0.00 3 0.00 5.33
Range#include_with_range?
0.00 10.92 0.00 3 0.00 5.33 Range#===
0.00 10.92 0.00 1 0.00 0.00 #<Module:
0xbb8918>.time_to_day_fraction
0.00 10.92 0.00 1 0.00 16.00 #<Module:
0xbb8918>._valid_time?
0.00 10.92 0.00 1 0.00 16.00
Date#valid_time_frags?
0.00 10.92 0.00 12 0.00 0.00 Bignum#<=>
0.00 10.92 0.00 9 0.00 0.00 Rational#/
0.00 10.92 0.00 20 0.00 0.00 Bignum#<
0.00 10.92 0.00 20 0.00 0.00 Bignum#%
0.00 10.92 0.00 30 0.00 0.00 Bignum#div
0.00 10.92 0.00 4 0.00 0.00 Rational#+
0.00 10.92 0.00 1 0.00 0.00 Rational#coerce
0.00 10.92 0.00 6 0.00 0.00 Fixnum#*
0.00 10.92 0.00 2 0.00 0.00 Bignum#+
0.00 10.92 0.00 18 0.00 0.00 Fixnum#%
0.00 10.92 0.00 1 0.00 0.00 Fixnum#+
0.00 10.92 0.00 4 0.00 0.00 Rational#-
0.00 10.92 0.00 2 0.00 0.00 Bignum#-
0.00 10.92 0.00 1 0.00 0.00 #<Module:
0xbb8918>.jd_to_ajd
0.00 10.92 0.00 1 0.00 0.00 Date#initialize
0.00 10.92 0.00 1 0.00 0.00 Date#new!
0.00 10.92 0.00 1 0.00 16.00
DateTime#new_by_frags
0.00 10.92 0.00 1 0.00 16.00 DateTime#parse
0.00 10.92 0.00 8 0.00 0.00 Fixnum#==
0.00 10.92 0.00 4 0.00 0.00 Rational#floor
0.00 10.92 0.00 2 0.00 0.00 Numeric#div
0.00 10.92 0.00 2 0.00 0.00 Numeric#divmod
0.00 10.92 0.00 1 0.00 0.00 #<Module:
0xbb8918>.ajd_to_jd
0.00 10.92 0.00 2 0.00 0.00
Date#day_fraction
0.00 10.92 0.00 2 0.00 0.00 Rational#==
0.00 10.92 0.00 2 0.00 0.00 Rational#*
0.00 10.92 0.00 8 0.00 0.00 Fixnum#divmod
0.00 10.92 0.00 1 0.00 0.00 #<Module:
0xbb8918>.day_fraction_to_time
0.00 10.92 0.00 2 0.00 0.00 Date#time
0.00 10.92 0.00 1 0.00 0.00
Date#sec_fraction
0.00 10.92 0.00 1 0.00 0.00 Rational#to_i
0.00 10.92 0.00 2 0.00 0.00 Time#initialize
0.00 10.92 0.00 38 0.00 0.00 String#gsub!
0.00 10.92 0.00 10 0.00 0.00
OCI8#oracle_client_version
0.00 10.92 0.00 10 0.00 0.00
OCI8::OracleVersion#<=>
0.00 10.92 0.00 9 0.00 0.00 Comparable.>=
0.00 10.92 0.00 2 0.00 0.00 Integer#to_r
0.00 10.92 0.00 1 0.00 0.00 Time#now
0.00 10.92 0.00 1 0.00 0.00 Time#utc_offset
0.00 10.92 0.00 53 0.00 0.00 Kernel.hash
0.00 10.92 0.00 15 0.00 0.00
BasicObject#initialize
0.00 10.92 0.00 14 0.00 0.00 Proc#new
0.00 10.92 0.00 19 0.00 0.00
OCI8::Metadata::Base#register_ptype
0.00 10.92 0.00 1 0.00 0.00 Comparable.<
0.00 10.92 0.00 216 0.00 0.00 String#index
0.00 10.92 0.00 20 0.00 0.00 Symbol#intern
0.00 10.92 0.00 5 0.00 0.00
Module#extend_object
0.00 10.92 0.00 3 0.00 0.00 Module#extended
0.00 10.92 0.00 5 0.00 0.00 Kernel.extend
0.00 10.92 0.00 6 0.00 0.00 Kernel.Array
0.00 10.92 0.00 9 0.00 0.00 NilClass#to_s
0.00 10.92 0.00 3 0.00 0.00 Kernel.freeze
0.00 10.92 0.00 1 0.00 0.00
Sequel::Dataset#clause_methods
0.00 10.92 0.00 2 0.00 15.00 Sequel.require
0.00 10.92 0.00 5 0.00 0.00 Symbol#to_sym
0.00 10.92 0.00 1 0.00 0.00
Sequel::Database#set_adapter_scheme
0.00 10.92 0.00 1 0.00 0.00
Module#alias_method
0.00 10.92 0.00 9 0.00 0.00 Kernel.dup
0.00 10.92 0.00 14 0.00 0.00 Mutex#unlock
0.00 10.92 0.00 14 0.00 59.07
Mutex#synchronize
0.00 10.92 0.00 2 0.00 413.50
Sequel.check_requiring_thread
0.00 10.92 0.00 1 0.00 812.00
Sequel.tsk_require
0.00 10.92 0.00 1 0.00 812.00
Sequel::Database#adapter_class
0.00 10.92 0.00 27 0.00 0.00
Kernel.initialize_dup
0.00 10.92 0.00 1 0.00 0.00
Sequel::Database#connection_pool_default_options
0.00 10.92 0.00 2 0.00 0.00
NoMethodError#initialize
0.00 10.92 0.00 6 0.00 0.00
Exception#exception
0.00 10.92 0.00 7 0.00 0.00
Exception#backtrace
0.00 10.92 0.00 4 0.00 0.00 Kernel.raise
0.00 10.92 0.00 2 0.00 0.00
NilClass#raise_nil_warning_for
0.00 10.92 0.00 2 0.00 0.00
NilClass#method_missing
0.00 10.92 0.00 2 0.00 0.00 NilClass#to_a
0.00 10.92 0.00 4 0.00 0.00 Kernel.proc
0.00 10.92 0.00 2 0.00 0.00 Kernel.class
0.00 10.92 0.00 5 0.00 0.00 Hash#fetch
0.00 10.92 0.00 13 0.00 0.00 Kernel.===
0.00 10.92 0.00 1 0.00 0.00
Sequel::Database#typecast_value_boolean
0.00 10.92 0.00 1 0.00 0.00
Sequel::Database#default_schema_default
0.00 10.92 0.00 3 0.00 0.00 Array#hash
0.00 10.92 0.00 6 0.00 0.00 Kernel.eql?
0.00 10.92 0.00 3 0.00 0.00 Array#eql?
0.00 10.92 0.00 2 0.00 0.00
Sequel::ConnectionPool::ClassMethods.connection_pool_class
0.00 10.92 0.00 1 0.00 15.00
Sequel.ts_require
0.00 10.92 0.00 1 0.00 0.00
Sequel::ConnectionPool#initialize
0.00 10.92 0.00 2 0.00 0.00 Kernel.Integer
0.00 10.92 0.00 1 0.00 0.00 Mutex#initialize
0.00 10.92 0.00 1 0.00 0.00 Kernel.Float
0.00 10.92 0.00 1 0.00 0.00
Sequel::ThreadedConnectionPool#initialize
0.00 10.92 0.00 1 0.00 15.00
Sequel::ConnectionPool::ClassMethods.get_pool
0.00 10.92 0.00 1 0.00 0.00 Array#push
0.00 10.92 0.00 1 0.00 15.00
Sequel::Database#initialize
0.00 10.92 0.00 7 0.00 0.00
Kernel.block_given?
0.00 10.92 0.00 1 0.00 859.00
Sequel::Database#connect
0.00 10.92 0.00 1 0.00 859.00 Sequel.connect
0.00 10.92 0.00 1 0.00 859.00
Sequel.adapter_method
0.00 10.92 0.00 1 0.00 859.00 Sequel.oracle
0.00 10.92 0.00 1 0.00 0.00
Kernel.instance_variables
0.00 10.92 0.00 17 0.00 0.00
Kernel.instance_variable_get
0.00 10.92 0.00 2 0.00 0.00
Array#initialize_copy
0.00 10.92 0.00 8 0.00 0.00
Sequel::Model::ClassMethods.db
0.00 10.92 0.00 1 0.00 0.00
ActiveSupport::Inflector.demodulize
0.00 10.92 0.00 1 0.00 0.00
String#demodulize
0.00 10.92 0.00 1 0.00 0.00
Sequel::Inflections.demodulize
0.00 10.92 0.00 1 0.00 0.00
Sequel::Inflections.underscore
0.00 10.92 0.00 2 0.00 0.00
ActiveSupport::Inflector::Inflections#instance
0.00 10.92 0.00 2 0.00 0.00
ActiveSupport::Inflector.inflections
0.00 10.92 0.00 740 0.00 0.00 String#downcase
0.00 10.92 0.00 1 0.00 0.00
ActiveSupport::Inflector.pluralize
0.00 10.92 0.00 1 0.00 0.00 String#pluralize
0.00 10.92 0.00 1 0.00 0.00
Sequel::Inflections.pluralize
0.00 10.92 0.00 1 0.00 0.00
Sequel::Model::ClassMethods.implicit_table_name
0.00 10.92 0.00 1 0.00 0.00 Class#superclass
0.00 10.92 0.00 1 0.00 0.00
Sequel::Database#quote_identifiers_default
0.00 10.92 0.00 6 0.00 0.00
Sequel::Database#quote_identifiers?
0.00 10.92 0.00 1 0.00 0.00
Sequel::Database#identifier_input_method_default
0.00 10.92 0.00 6 0.00 0.00
Sequel::Database#identifier_input_method
0.00 10.92 0.00 1 0.00 0.00
Sequel::Database#identifier_output_method_default
0.00 10.92 0.00 6 0.00 0.00
Sequel::Database#identifier_output_method
0.00 10.92 0.00 6 0.00 0.00
Sequel::Dataset#initialize
0.00 10.92 0.00 6 0.00 0.00
Sequel::Oracle::Database#dataset
0.00 10.92 0.00 7 0.00 0.00
Sequel::Database#schema_utility_dataset
0.00 10.92 0.00 771 0.00 0.00 Regexp#match
0.00 10.92 0.00 11 0.00 0.00
Sequel::Dataset#split_symbol
0.00 10.92 0.00 8 0.00 0.00
Sequel::Dataset#input_identifier
0.00 10.92 0.00 8 0.00 0.00
Sequel::Dataset#quote_identifiers?
0.00 10.92 0.00 4 0.00 0.00
String#initialize_copy
0.00 10.92 0.00 1 0.00 0.00
ActiveSupport::Dependencies.qualified_name_for
0.00 10.92 0.00 3 0.00 5.33
Sequel::Dataset#literal_symbol
0.00 10.92 0.00 7 0.00 2.29
Sequel::Dataset#literal
0.00 10.92 0.00 1 0.00 0.00
Sequel::Database#literal
0.00 10.92 0.00 10 0.00 0.00 BasicObject#==
0.00 10.92 0.00 10 0.00 0.00 String#===
0.00 10.92 0.00 13 0.00 0.00
Kernel.initialize_copy
0.00 10.92 0.00 13 0.00 0.00
Kernel.initialize_clone
0.00 10.92 0.00 13 0.00 0.00 Kernel.clone
0.00 10.92 0.00 15 0.00 0.00 Enumerable.any?
0.00 10.92 0.00 13 0.00 0.00
Sequel::Dataset#clone
0.00 10.92 0.00 2 0.00 0.00
Sequel::Dataset#from
0.00 10.92 0.00 2 0.00 0.00
Sequel::Database#from
0.00 10.92 0.00 3 0.00 0.00
Sequel::Database#[]
0.00 10.92 0.00 2 0.00 0.00
Sequel::Dataset#provides_accurate_rows_matched?
0.00 10.92 0.00 5 0.00 0.00
BasicObject#instance_eval
0.00 10.92 0.00 2 0.00 0.00
Sequel::Dataset#def_mutation_method
0.00 10.92 0.00 2 0.00 0.00
Sequel::Model::Associations::DatasetMethods.extended
0.00 10.92 0.00 3 0.00 2682.33
Sequel::Model::ClassMethods.set_columns
0.00 10.92 0.00 7 0.00 0.00
Sequel::Model::ClassMethods.dataset
0.00 10.92 0.00 2 0.00 0.00
Sequel::Dataset#first_source_table
0.00 10.92 0.00 4 0.00 0.00
Sequel::Dataset#schema_and_table
0.00 10.92 0.00 2 0.00 0.00
Sequel::Database#schema_and_table
0.00 10.92 0.00 2 0.00 7.50
Sequel::Dataset#quote_schema_table
0.00 10.92 0.00 2 0.00 7.50
Sequel::Database#quote_schema_table
0.00 10.92 0.00 2 0.00 0.00
Sequel::Database#quote_identifier
0.00 10.92 0.00 12 0.00 0.00
Sequel::ThreadedConnectionPool#sync
0.00 10.92 0.00 4 0.00 0.00
Sequel::ThreadedConnectionPool#owned_connection
0.00 10.92 0.00 1 0.00 0.00
Sequel::ThreadedConnectionPool#size
0.00 10.92 0.00 5 0.00 0.00 Hash#delete
0.00 10.92 0.00 1 0.00 0.00
Sequel::Database#server_opts
0.00 10.92 0.00 1 0.00 0.00 OCI8#initialize
0.00 10.92 0.00 5 0.00 0.00 OCI8#autocommit=
0.00 10.92 0.00 1 0.00 0.00
OCI8#non_blocking=
0.00 10.92 0.00 1 0.00 0.00
Sequel::Oracle::Database#connect
0.00 10.92 0.00 20 0.00 0.00
ActiveSupport::Dependencies.to_constant_name
0.00 10.92 0.00 1 0.00 0.00
Sequel::ConnectionPool#make_new
0.00 10.92 0.00 1 0.00 0.00
Sequel::ThreadedConnectionPool#make_new
0.00 10.92 0.00 4 0.00 0.00
Sequel::ThreadedConnectionPool#available
0.00 10.92 0.00 4 0.00 0.00
Sequel::ThreadedConnectionPool#acquire
0.00 10.92 0.00 2 0.00 0.00
Sequel::Database#already_in_transaction?
0.00 10.92 0.00 4 0.00 0.00
Sequel::Database#supports_savepoints?
0.00 10.92 0.00 2 0.00 0.00
Sequel::Database#add_transaction
0.00 10.92 0.00 6 0.00 0.00
Sequel::Database#log_yield
0.00 10.92 0.00 2 0.00 0.00
Sequel::Oracle::Database#begin_transaction
0.00 10.92 0.00 2 0.00 0.00
OCIError#initialize
0.00 10.92 0.00 2 0.00 0.00 OCI8#__describe
0.00 10.92 0.00 2 0.00 0.00
OCI8#describe_table
0.00 10.92 0.00 1 0.00 0.00 OCI8#rollback
0.00 10.92 0.00 1 0.00 0.00
Sequel::Oracle::Database#rollback_transaction
0.00 10.92 0.00 1 0.00 0.00
Sequel::Database#database_error_classes
0.00 10.92 0.00 2 0.00 0.00
Sequel::Database#raise_error
0.00 10.92 0.00 1 0.00 0.00
Sequel::Database#transaction_error
0.00 10.92 0.00 2 0.00 0.00 Array#delete
0.00 10.92 0.00 2 0.00 0.00
Sequel::Database#remove_transaction
0.00 10.92 0.00 2 0.00 0.00
Sequel::Oracle::Database#remove_transaction
0.00 10.92 0.00 2 0.00 0.00
Sequel::Database#_transaction
0.00 10.92 0.00 4 0.00 0.00
Sequel::ThreadedConnectionPool#release
0.00 10.92 0.00 4 0.00 8.00
Sequel::ThreadedConnectionPool#hold
0.00 10.92 0.00 4 0.00 8.00
Sequel::Database#synchronize
0.00 10.92 0.00 2 0.00 0.00
Sequel::Database#transaction
0.00 10.92 0.00 2 0.00 875.00
Sequel::Oracle::Database#schema_parse_table
0.00 10.92 0.00 2 0.00 914.00
Sequel::Database#schema
0.00 10.92 0.00 2 0.00 0.00
Sequel::Dataset#naked
0.00 10.92 0.00 1 0.00 0.00
Sequel::Dataset#unfiltered
0.00 10.92 0.00 2 0.00 0.00
Sequel::Dataset#order
0.00 10.92 0.00 2 0.00 0.00
Sequel::Dataset#unordered
0.00 10.92 0.00 2 0.00 0.00
Sequel::Oracle::DatasetMethods.select_clause_methods
0.00 10.92 0.00 2 0.00 0.00
Sequel::Dataset#select_with_sql
0.00 10.92 0.00 2 0.00 0.00
Sequel::Dataset#select_distinct_sql
0.00 10.92 0.00 2 0.00 0.00
Sequel::Dataset#column_list
0.00 10.92 0.00 2 0.00 0.00
Sequel::Dataset#select_columns_sql
0.00 10.92 0.00 2 0.00 8.00
Sequel::Dataset#table_ref
0.00 10.92 0.00 2 0.00 8.00
Sequel::Dataset#source_list
0.00 10.92 0.00 2 0.00 8.00
Sequel::Oracle::DatasetMethods.select_from_sql
0.00 10.92 0.00 2 0.00 0.00
Sequel::Dataset#select_join_sql
0.00 10.92 0.00 2 0.00 0.00
Sequel::Dataset#select_where_sql
0.00 10.92 0.00 2 0.00 0.00
Sequel::Dataset#select_group_sql
0.00 10.92 0.00 2 0.00 0.00
Sequel::Dataset#select_having_sql
0.00 10.92 0.00 2 0.00 7.50
Sequel::Dataset#select_compounds_sql
0.00 10.92 0.00 2 0.00 0.00
Sequel::Dataset#select_order_sql
0.00 10.92 0.00 20 0.00 0.00 Kernel.!~
0.00 10.92 0.00 7 0.00 0.00 Hash#include?
0.00 10.92 0.00 2 0.00 0.00
Sequel::Oracle::DatasetMethods.select_limit_sql
0.00 10.92 0.00 2 0.00 15.50
Sequel::Dataset#clause_sql
0.00 10.92 0.00 2 0.00 15.50
Sequel::Dataset#select_sql
0.00 10.92 0.00 2 0.00 0.00
OCI8::Cursor#initialize
0.00 10.92 0.00 2 0.00 0.00 OCI8#parse
0.00 10.92 0.00 3 0.00 0.00
Enumerable.each_with_index
0.00 10.92 0.00 2 0.00 0.00
OCI8::Cursor#bind_params
0.00 10.92 0.00 2 0.00 0.00
OCI8::Cursor#__execute
0.00 10.92 0.00 2 0.00 0.00
OCI8::Cursor#exec
0.00 10.92 0.00 2 0.00 0.00 OCIHandle#free
0.00 10.92 0.00 2 0.00 0.00
OCI8::Cursor#close
0.00 10.92 0.00 2 0.00 0.00 OCI8#exec
0.00 10.92 0.00 1 0.00 0.00 OCIError#code
0.00 10.92 0.00 1 0.00 0.00 Module#to_s
0.00 10.92 0.00 1 0.00 0.00 Exception#to_s
0.00 10.92 0.00 1 0.00 0.00
Exception#message
0.00 10.92 0.00 1 0.00 0.00
Sequel.convert_exception_class
0.00 10.92 0.00 2 0.00 16.00
Sequel::Oracle::Database#execute
0.00 10.92 0.00 2 0.00 16.00
Sequel::Dataset#execute
0.00 10.92 0.00 2 0.00 16.00
Sequel::Oracle::Dataset#fetch_rows
0.00 10.92 0.00 2 0.00 31.50
Sequel::Dataset#each
0.00 10.92 0.00 1 0.00 16.00
Sequel::Dataset#columns
0.00 10.92 0.00 1 0.00 16.00
Sequel::Model::ClassMethods.columns
0.00 10.92 0.00 3 0.00 3318.00
Sequel::Model::ClassMethods.check_non_connection_error
0.00 10.92 0.00 2 0.00 4969.00
Sequel::Model::ClassMethods.get_db_schema
0.00 10.92 0.00 2 0.00 4969.00
Sequel::Model::ClassMethods.set_dataset
0.00 10.92 0.00 1 0.00 32.00
Sequel::Model::ClassMethods.inherited
0.00 10.92 0.00 1 0.00 32.00
Sequel::Model::Associations::ClassMethods.inherited
0.00 10.92 0.00 1 0.00 0.00
ActiveSupport::Dependencies.autoload_once_paths
0.00 10.92 0.00 2 0.00 0.00
String#starts_with?
0.00 10.92 0.00 1 0.00 0.00
ActiveSupport::Dependencies.load_once_path?
0.00 10.92 0.00 2 0.00 0.00
ActiveSupport::Dependencies.autoloaded_constants
0.00 10.92 0.00 1 0.00 938.00
ActiveSupport::Dependencies.load_file
0.00 10.92 0.00 1 0.00 0.00
ActiveSupport::Dependencies.history
0.00 10.92 0.00 1 0.00 953.00
ActiveSupport::Dependencies.require_or_load
0.00 10.92 0.00 1 0.00 953.00
ActiveSupport::Dependencies.load_missing_constant
0.00 10.92 0.00 1 0.00 0.00 OCI8#commit
0.00 10.92 0.00 1 0.00 0.00
Sequel::Oracle::Database#commit_transaction
0.00 10.92 0.00 1 0.00 0.00
OCI8::Metadata::Base#__param
0.00 10.92 0.00 1 0.00 0.00
OCI8::Metadata::Table#list_columns
0.00 10.92 0.00 20 0.00 0.00 String#=~
0.00 10.92 0.00 1 0.00 0.00
OCI8::Metadata::List#ltype
0.00 10.92 0.00 1 0.00 0.00 Fixnum#===
0.00 10.92 0.00 1 0.00 0.00
OCI8::Metadata::Base#num_params
0.00 10.92 0.00 738 0.00 0.00
OCI8::Metadata::Base#__param_at
0.00 10.92 0.00 126 0.00 0.00 Module#===
0.00 10.92 0.00 1 0.00 16.00
OCI8::Metadata::List#to_a
0.00 10.92 0.00 1 0.00 16.00
OCI8::Metadata::Table#columns
0.00 10.92 0.00 85 0.00 0.00
BasicObject#equal?
0.00 10.92 0.00 39 0.00 0.00
ActiveSupport::Dependencies.qualified_const_defined?
0.00 10.92 0.00 739 0.00 0.06
OCI8::Metadata::Base#__data_type
0.00 10.92 0.00 739 0.00 0.06
OCI8::Metadata::Column#data_type
0.00 10.92 0.00 40 0.00 0.80
Enumerable.inject
0.00 10.92 0.00 41 0.00 0.00
ActiveSupport::Dependencies.local_const_defined?
0.00 10.92 0.00 40 0.00 0.00 String#sub
0.00 10.92 0.00 22 0.00 0.00
ActiveSupport::Dependencies.log_call
0.00 10.92 0.00 43 0.00 0.00
ActiveSupport::Dependencies.logger
0.00 10.92 0.00 100 0.00 0.00 Module#const_get
0.00 10.92 0.00 81 0.00 0.00
Module#const_defined?
0.00 10.92 0.00 42 0.00 0.00 String#empty?
0.00 10.92 0.00 47 0.00 0.00 Array#first
0.00 10.92 0.00 760 0.00 0.00
OCI8::Metadata::Base#__charset_form
0.00 10.92 0.00 64 0.00 0.00 Array#empty?
0.00 10.92 0.00 24 0.00 0.00 Module#name
0.00 10.92 0.00 760 0.00 0.04
OCI8::Metadata::Column#char_used?
0.00 10.92 0.00 2 0.00 0.00 String#scan
0.00 10.92 0.00 760 0.00 0.00
OCI8::Metadata::Base#__ub2_nc
0.00 10.92 0.00 1 0.00 0.00 Array#unshift
0.00 10.92 0.00 64 0.00 0.00 String#to_s
0.00 10.92 0.00 738 0.00 0.02
OCI8::Metadata::Column#lfprecision
0.00 10.92 0.00 38 0.00 0.00 Object#presence
0.00 10.92 0.00 1 0.00 0.00
Sequel::Model::ClassMethods.clear_setter_methods_cache
0.00 10.92 0.00 1 0.00 31.00
Enumerable.partition
0.00 10.92 0.00 1 0.00 0.00
Module#initialize
0.00 10.92 0.00 38 0.00 0.00 Object#present?
0.00 10.92 0.00 1 0.00 0.00 NilClass#blank?
0.00 10.92 0.00 1 0.00 8047.00
Sequel::Model::ClassMethods.def_column_accessor
0.00 10.92 0.00 1 0.00 0.00 Hash#has_key?
0.00 10.92 0.00 1 0.00 0.00
Enumerable.collect
0.00 10.92 0.00 1 0.00 0.00 Array#&
0.00 10.92 0.00 1 0.00 0.00
Sequel::Dataset#options_overlap
0.00 10.92 0.00 1 0.00 0.00
Sequel::Dataset#aggregate_dataset
0.00 10.92 0.00 1 0.00 0.00 Proc#arity
0.00 10.92 0.00 1 0.00 0.00 Array#shift
0.00 10.92 0.00 1 0.00 0.00
Sequel::SQL::Function#initialize
0.00 10.92 0.00 2 0.00 0.00
Sequel::SQL::VirtualRow#method_missing
0.00 10.92 0.00 1 0.00 0.00
Sequel::SQL::Identifier#initialize
0.00 10.92 0.00 1 0.00 0.00
Sequel::SQL::AliasedExpression#initialize
0.00 10.92 0.00 1 0.00 0.00
Sequel::SQL::AliasMethods.as
0.00 10.92 0.00 1 0.00 0.00
Sequel.virtual_row
0.00 10.92 0.00 1 0.00 0.00
Sequel::Dataset#select
0.00 10.92 0.00 1 0.00 0.00
Sequel::Dataset#ungraphed
0.00 10.92 0.00 1 0.00 0.00
Sequel::Model::Associations::DatasetMethods.ungraphed
0.00 10.92 0.00 1 0.00 0.00
Sequel.condition_specifier?
0.00 10.92 0.00 2 0.00 0.00
Sequel::Dataset#expression_list
0.00 10.92 0.00 1 0.00 0.00
Sequel::Dataset#array_sql
0.00 10.92 0.00 1 0.00 0.00
Sequel::Dataset#literal_array
0.00 10.92 0.00 1 0.00 0.00
Sequel::Dataset#function_sql
0.00 10.92 0.00 1 0.00 0.00
Sequel::SQL::Function#to_s
0.00 10.92 0.00 2 0.00 0.00
Sequel::Dataset#literal_expression
0.00 10.92 0.00 1 0.00 0.00
Sequel::Oracle::DatasetMethods.as_sql
0.00 10.92 0.00 1 0.00 0.00
Sequel::Dataset#aliased_expression_sql
0.00 10.92 0.00 1 0.00 0.00
Sequel::SQL::AliasedExpression#to_s
0.00 10.92 0.00 2 0.00 0.00
OCI8::Cursor#type
0.00 10.92 0.00 1 0.00 0.00
OCI8::Cursor#__param_count
0.00 10.92 0.00 1 0.00 0.00
OCI8::Cursor#__paramGet
0.00 10.92 0.00 1 0.00 0.00
OCI8::Cursor#__defined?
0.00 10.92 0.00 1 0.00 0.00
OCI8::Metadata::Base#__sb2
0.00 10.92 0.00 1 0.00 0.00
OCI8::BindType::Base#initialize
0.00 10.92 0.00 1 0.00 0.00
OCI8::BindType::Number#create
0.00 10.92 0.00 1 0.00 0.00
OCI8::Cursor#make_bind_object
0.00 10.92 0.00 1 0.00 0.00
OCI8::Cursor#__define
0.00 10.92 0.00 1 0.00 0.00
OCI8::Cursor#define_one_column
0.00 10.92 0.00 1 0.00 0.00 Array#[]=
0.00 10.92 0.00 1 0.00 0.00
OCI8::Cursor#define_columns
0.00 10.92 0.00 1 0.00 0.00
OCI8::Cursor#get_col_names
0.00 10.92 0.00 1 0.00 0.00
Sequel::Dataset#output_identifier
0.00 10.92 0.00 1 0.00 0.00
OCI8::BindType::Base#get
0.00 10.92 0.00 1 0.00 0.00
Kernel.BigDecimal
0.00 10.92 0.00 1 0.00 0.00 OraNumber#to_d
0.00 10.92 0.00 1 0.00 32.00
OCI8::BindType::BigDecimal#get
0.00 10.92 0.00 1 0.00 32.00
OCI8::Cursor#fetch
0.00 10.92 0.00 1 0.00 47.00
Sequel::Dataset#single_record
0.00 10.92 0.00 1 0.00 0.00 Hash#values
0.00 10.92 0.00 1 0.00 47.00
Sequel::Dataset#single_value
0.00 10.92 0.00 1 0.00 47.00
Sequel::Dataset#get
0.00 10.92 0.00 1 0.00 0.00 BigDecimal#to_i
0.00 10.92 0.00 1 0.00 47.00
Sequel::Dataset#count
0.00 10.92 0.00 1 0.00 47.00
Sequel::Model::ClassMethods.count
0.00 10.92 0.00 1 0.00 0.00
Sequel::Dataset#with_sql
0.00 10.92 0.00 1 0.00 0.00
Sequel::Database#fetch
0.00 10.92 0.00 1 0.00 9969.00 Packet#times
0.00 10.92 0.00 1 0.00 10922.00
Object#profile_me
0.00 10.92 0.00 1 0.00 10922.00 #toplevel
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sequel-talk?hl=en.
