From: "Naina A." <naina.sydney@...>
Date: 2011-04-16T01:26:57+09:00
Subject: improve query

Hi, I am trying to improve the quality of the query inside Ruby. This
below query is giving very long output. Can anyone please let me know if
there a way to use cache instead of retrieving them every time from the
database?

@queries.each_pair do |field_name, value_array|
      if ( check_for_symbols )
        force_to_symbol = []
        keep_as_requested = []
        value_array.each do | value |
          the_symbols = get_symbol(nil, value.strip.upcase.gsub(/\"/,
''), true)
          if ( !the_symbols.nil?)
            the_symbols.each { | the_symbol | force_to_symbol <<
the_symbol[:symbol]}
          else
            keep_as_requested << value
          end
        end
        if ( keep_as_requested.length > 0 )
          query_string << (joiner + field_name.to_s + ':(' +
keep_as_requested.join(' OR ') + ') ')
          joiner = 'OR '
        end
        if ( force_to_symbol.length > 0 )
          query_string << (joiner + :symbol.to_s + ':(' +
force_to_symbol.join(' OR ') + ') ')
        end
      else
        query_string << (joiner + field_name.to_s + ':(' +
value_array.join(' OR ') + ') ')
      end
      joiner = 'OR '
    end

-- 
Posted via http://www.ruby-forum.com/.