my guess is it has nothing to do with sqlite which in my experience is plenty fast. i'd make sure you're running in the production environment, with lots of extensions the development environment can get real slow real fast.
On Thu, Jul 2, 2009 at 8:47 AM, Mohit Sindhwani<[email protected]> wrote: > Hi, I'm just playing around with a Radiant 0.7.1 site with a bunch of > extensions. I find that generating a page the first time takes very very > long - I'm seeing it in the region of 3 seconds - 30 seconds! Of course, if > it's cached, it's fine - it's fast. > > It's deployed on 2 Mongrels; seems sqlite3 is v3.4.2 > > I looked at the log and I'm seeing things like: > Processing SiteController#show_page (for 216.129.119.49 at 2009-07-02 > 08:55:50) [GET] > Parameters: {"action"=>"show_page", "url"=>["en", "spec", "t-kernel", > "1.00", "tkernel_os", "extended_synchronization_and_communication", > "message_buffer", "tk_cre_mbf"], "controller"=>"site"} > Completed in 23.40224 (0 reqs/sec) | DB: 6.10926 (26%) | 200 OK > [http://t-engine.info/en/spec/t-kernel/1.00/tkernel_os/extended_synchronization_and_communication/message_buffer/tk_cre_mbf/] > > > Processing SiteController#show_page (for 216.129.119.49 at 2009-07-02 > 08:58:28) [GET] > Parameters: {"action"=>"show_page", "url"=>["en", "spec", "ut-kernel", > "1.01", "functions", "time_management", "system_time"], > "controller"=>"site"} > Completed in 2.85429 (0 reqs/sec) | DB: 2.28977 (80%) | 200 OK > [http://t-engine.info/en/spec/ut-kernel/1.01/functions/time_management/system_time/] > > > Processing SiteController#show_page (for 216.129.119.49 at 2009-07-02 > 09:01:06) [GET] > Parameters: {"action"=>"show_page", "url"=>["en", "spec", "t-engine", > "1.01", "cpu_board_interface_spec", "usb_host"], "controller"=>"site"} > Completed in 19.33309 (0 reqs/sec) | DB: 13.02903 (67%) | 200 OK > [http://t-engine.info/en/spec/t-engine/1.01/cpu_board_interface_spec/usb_host/] > > > Processing SiteController#show_page (for 218.186.65.65 at 2009-07-02 > 09:27:42) [GET] > Parameters: {"action"=>"show_page", "url"=>["en", "spec"], > "controller"=>"site"} > Completed in 30.12451 (0 reqs/sec) | DB: 27.00055 (89%) | 200 OK > [http://www.t-engine.info/en/spec] > > Any suggestions on what I can do? > > Cheers, > Mohit. > 7/2/2009 | 10:45 PM. > > _______________________________________________ > Radiant mailing list > Post: [email protected] > Search: http://radiantcms.org/mailing-list/search/ > Site: http://lists.radiantcms.org/mailman/listinfo/radiant > _______________________________________________ Radiant mailing list Post: [email protected] Search: http://radiantcms.org/mailing-list/search/ Site: http://lists.radiantcms.org/mailman/listinfo/radiant
