From: Alpha Blue Date: 2009-07-29T03:52:27+09:00 Subject: Re: I need some help with Ruby query building and query time Just as a follow-up: I checked out the stored procedures and found that they were a bit too heavy on server memory, which in my case is very important. Further, with some of the routines I would need to create, it would be very difficult to rely on them fully. I definitely see a lot of pros with stored procedures but I see a lot of cons as well. I ended up disecting my model.find routine into 5 separate routines with 5 variable returns. This changed my time from: 8000 MS or 8 seconds TO: 122 Milliseconds = 0.122 Seconds In my case, I just needed to reduce the query size into smaller chunks. Many people say to go with larger queries but in this case the query was too large. Thanks. -- Posted via http://www.ruby-forum.com/.