I am also trying to bring up a new ruote implementation using Ruote::Sequel. On my last post John recommended to use edge Ruote rather than official 2.2.0 release. We still haven't done that, but we did find, when we were doing SQL performance tuning for the app, that Ruote::Sequel does a TON of queries on documents using (typ, ide, rev) as keys. These showed up in the MySQL slow query log, too. There is no index for that query! Once we added the index we've had much better performance with ruote. So, you might want to try adding an index on documents table and see if that helps. We use rails, so we did it with a migration: add_index :documents, [:type, :ide, :rev] hth, Steve
-- you received this message because you are subscribed to the "ruote users" group. to post : send email to [email protected] to unsubscribe : send email to [email protected] more options : http://groups.google.com/group/openwferu-users?hl=en
