From 140a5f8f7b7deea713b5c7cbccbc8b57fecb2c7d Mon Sep 17 00:00:00 2001 From: Marcel Molina Date: Thu, 13 Oct 2005 03:01:33 +0000 Subject: Optimize postgresql selects. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@2548 5ecf4fe2-1ee6-0310-87b1-e25e094e27de --- .../connection_adapters/postgresql_adapter.rb | 36 +++++++++++----------- 1 file changed, 18 insertions(+), 18 deletions(-) (limited to 'activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb') diff --git a/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb b/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb index e7bedaee9e..b26d4d35c9 100644 --- a/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb +++ b/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb @@ -250,24 +250,24 @@ module ActiveRecord def select(sql, name = nil) res = execute(sql, name) results = res.result - rows = [] - if results.length > 0 - fields = res.fields - results.each do |row| - hashed_row = {} - row.each_index do |cel_index| - column = row[cel_index] - if res.type(cel_index) == BYTEA_COLUMN_TYPE_OID - column = unescape_bytea(column) - end - hashed_row[fields[cel_index]] = column - end - rows << hashed_row - end - end - return rows - end - + rows = [] + if results.length > 0 + fields = res.fields + hash_prototype = fields.inject({}){ |proto, field| proto[field] = nil; proto } + results.each do |row| + hashed_row = hash_prototype.clone + row.each_index do |col_num| + if res.type(col_num) == BYTEA_COLUMN_TYPE_OID + hashed_row[fields[col_num]] = unescape_bytea(row[col_num]) + else + hashed_row[fields[col_num]] = row[col_num] + end + end + rows << hashed_row + end + end + rows + end def escape_bytea(s) if PGconn.respond_to? :escape_bytea self.class.send(:define_method, :escape_bytea) do |s| -- cgit v1.2.3