Gary Doades wrote: > I'm glad you said it was a test because it wouldn't be nice to do that > for real. > > It looks like you've got at least 12000 transactions in there (select + > update). Any indexes would make it worse. > > I'm guessing that this would take around 5 minutes on decent single disk > PC hardware. > > No database engine (even oracle) is going to do that in 2 seconds on a > standard PC with a single sata/ide hard disk. You're asking for 6000 > read/write operations per second. You'll need some mighty big hardware > to do that! > > If you did the whole thing in a single transaction you might get it to > go quite a bit faster.
will record.save automatically make it a transaction? so how do i make it into 1 transaction? I can't make it a hash or an array of records and at the end, do a loop of record.save too? because each will be a transaction... ? what about using memcache? the db seems like was about 45MB when i run 6000 words test on a few pages... so memcache of 64MB... maybe everything will happen in RAM and it can be really fast? -- 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 -~----------~----~----~----~------~----~------~--~---
