This is also a good possibility. Thank you.I guess my case is rather specific in that I'm working on a small site and I really needed all of the blurbs from the database, and then needed to display them in a non-sequential order. The index_by method that John pointed me to is proving to be a fine solution, but had I only needed a sub-set of the blurbs, this solution would have worked great.
Javan On Apr 12, 2007, at 8:44 AM, Matt Bosworth wrote:
Javan,If you know the names of the blurbs before making the query, you can do something like :names = [ 'foo', 'bar', 'baz'] blurb.find (:all, :conditions = > [ "name IN (?)", names] )That will get you an array of just the blurbs you want, and all the searching is done in the database for performance. Unless I'm misunderstanding the question. . .?HTH, Matt On Apr 11, 2007, at 10:36 PM, Leon Yeh wrote:For your case, it sounds like it is faster to do this using hash.index_by. I am just saying for larger hash size, it could be better to have the database doing the work. I could be wrong on this.Is memory access in hash.index_by is faster than SQL query ? I might need to run some benchmark to see at what hash size, the database query started to yield a better performance.Performance aside, I prefer to use with_scope for easier to maintain code. It is just my preference.Leon Yeh New Avenue Systems Inc. Office: (626)254-1757 x880 [EMAIL PROTECTED] Imagination Delivered. www.newavenue.net Javan Makhmali wrote:The page I'm working on has 10 different blurbs of text that I need to retrieve. Are you saying it's faster to make 10 queries than to make 1 query and convert it to a hash using index_by?On Apr 11, 2007, at 10:07 PM, Leon Yeh wrote:Hi Javan, this probably not going to do what you want but I found using with_scope create a more readable code, not to mention I think it would be resulted a better performance than going thru hash one by one, especially when the resulting hash is a large one. Database is designed to handle search better than going thru the hash in linear fashion.http://media.railscasts.com/videos/005_using_with_scope.mov Watch this screencast, and let me know what do you think? Leon Yeh New Avenue Systems Inc. Office: (626)254-1757 x880 [EMAIL PROTECTED] Imagination Delivered. www.newavenue.net Javan Makhmali wrote:Even better! On Apr 11, 2007, at 9:51 PM, John Parker wrote:On 4/11/07, Javan Makhmali <[EMAIL PROTECTED]> wrote:I'd love to do @blurbs = Blurb.find(:all) @about_blurb = @blurbs.give_me_the_one_where_name_is('about')ActiveSupport adds #index_by to Enumerable which seems like it mightbe useful here: <URL:http://api.rubyonrails.org/classes/Enumerable.html#M001100> @blurbs = Blurb.find(:all).index_by(&:name)@blurbs would be a Hash keyed on the blurb names, allowing you to grab@blurbs['about'], @blurbs['contact'], etc. -John --John Parker [EMAIL PROTECTED] _______________________________________________ Sdruby mailing list [EMAIL PROTECTED] http://lists.sdruby.com/mailman/listinfo/sdruby------------------------------------------------------------------ ------_______________________________________________ Sdruby mailing list [EMAIL PROTECTED] http://lists.sdruby.com/mailman/listinfo/sdruby_______________________________________________ Sdruby mailing list [EMAIL PROTECTED] http://lists.sdruby.com/mailman/listinfo/sdruby-------------------------------------------------------------------- ----_______________________________________________ Sdruby mailing list [EMAIL PROTECTED] http://lists.sdruby.com/mailman/listinfo/sdruby_______________________________________________ Sdruby mailing list [EMAIL PROTECTED] http://lists.sdruby.com/mailman/listinfo/sdruby_______________________________________________ Sdruby mailing list [EMAIL PROTECTED] http://lists.sdruby.com/mailman/listinfo/sdruby
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ Sdruby mailing list [EMAIL PROTECTED] http://lists.sdruby.com/mailman/listinfo/sdruby
