Is this a test or a real requirement? If it is a real requirement then count the words in memory first and then update the db so each record is only written once.
Colin 2009/5/9 Jian Lin <[email protected]> > > 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 <[email protected]> > > > 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 [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---

