Colin Law wrote: > Would not the index make the lookup faster but the write slower? Is it > that > the cacheing would mean that the lookup would be pretty quick anyway, > even > without an index? > > Colin > > 2009/5/9 Gary Doades <g...@gpdnet.co.uk>
yeah, seems like the search will be a lot faster with the index... i was also thinking of using production mode to run it, since the development mode will write all the SQL log and slow down the operation... -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk@googlegroups.com To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---