I am working to revive and migrate some Radiant 0.9.1 sites from FreeBSD to CentOS, and thus far am able to get the site up, but the slowness of loading a page is unbearable. If I tail the production.log , I see that it does a "SELECT * from pages WHERE...* on every page. It does that multiple times before loading a single page. There are 1000s of pages in the database, so it's taking around 20 seconds to load a single page which is just basic text, styles, a small menu and one image.
I've inherited these systems, so I'm not very familiar with Radiant. Let me know what information would be helpful to troubleshoot. This is CentOS 6.0 x86_64, running ruby-0.8.7 and rubygems-1.3.7 (all via RVM). The backend is using postgres. Gems: # gem list *** LOCAL GEMS *** actionmailer (2.3.5) actionpack (2.3.5) activerecord (2.3.5) activeresource (2.3.5) activesupport (2.3.5) bitset (0.1.0) chronic (0.6.4) daemon_controller (0.2.6) fabulator (0.0.16) fabulator-exhibit (0.0.7) fabulator-grammar (0.0.6) fabulator-xml (0.0.5) fastthread (1.0.7) ferret (0.11.6) json (1.6.1) libxml-ruby (2.2.2) libxslt-ruby (0.9.7) macaddr (1.4.0) mediacloth (0.0.3) multi_json (1.0.3) passenger (3.0.9) postgres (0.7.9.2008.01.28) rack (1.1.2, 1.0.1) radiant (0.9.1) radiant-fabulator-extension (0.0.10) radiant-fabulator_exhibit-extension (0.0.6) radiant-sns-extension (0.9.0) radius (0.7.1) rails (2.3.5) rake (0.9.2.2) RedCloth (4.2.8) ri_cal (0.8.8) ruby-xslt (0.9.6) systemu (2.2.0) uuid (2.3.4) uuidtools (2.1.2) will_paginate (2.3.16) Thanks - Trey
