Robert Klemme
8/26/2008 4:36:00 PM
On 26.08.2008 14:58, Glenn Potter wrote:
> Thanks Robert, i looked at the irb code but couldn't see any problem. I
> started hacking away at the code and replaced a <model>.find(:all,
> :conditions => [where_clause, @station_ae_title, @start_time,
> @end_time], :order => "pps_start")
> statement with an equivalent .find_by_sql call and the error went away.
Sounds as if you replaced an in memory search by a DB search. Maybe
your dataset is so huge that the in memory search failed to allocate
more memory and bombed. Searching through large sets of data is usually
more efficient when done inside the DBMS.
Kind regards
robert