jrq wrote: > On Oct 6, 2:29�pm, Michael Schuerig <[email protected]> wrote: >> try: > I've been looking at that. I'm not sure how that gets around the > complex queries, unless MySQL supports Materialized Views, which I > don't think it does (and they're are not a great solution). Or are > you assuming that the caching will get around this problem, once it's > built the first time?
No, views probably won't help performance, just query construction, though I don't know enough about how they're implemented to be sure. PostgreSQL handles views much better than MySQL, IIRC, and is generally a better database. Switch if you can. Best, -- Marnen Laibow-Koser http://www.marnen.org [email protected] -- 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.
