very slow speed :(

[axyd]

Hello!

I tried adva-cms, it looks nice but speed is very slow (1-2 sec per
request). Tried on both sqlite3 and mysql, results are the same.
Maybe i missed something? Some indexes or anything else?

Installation instruction:
- rails adva -m http://github.com/svenfuchs/adva_cms/raw/master/templates/adva-cms.0.2.1.rb
- rake adva:install:all
- script/server

Log:
-------------------------------------------------------------------------------------
Processing Admin::SitesController#show (for 127.0.0.1 at 2009-07-01
18:23:29) [GET]
Parameters: {"id"=>"1"}
Site Load (0.6ms) SELECT * FROM `sites` WHERE (`sites`.`id` = 1)
User Columns (1.6ms) SHOW FIELDS FROM `users`
User Load (0.1ms) SELECT * FROM `users` WHERE (`users`.`id` = 1)
LIMIT 1
Rbac::Role::Admin Columns (0.8ms) SHOW FIELDS FROM `roles`
Rbac::Role::Base Load (0.5ms) SELECT * FROM `roles` WHERE
(`roles`.user_id = 1)
Rbac::Role::Base Columns (0.7ms) SHOW FIELDS FROM `roles`
Membership Columns (1.0ms) SHOW FIELDS FROM `memberships`
User Load Including Associations (0.7ms) SELECT `users`.`id` AS
t0_r0, `users`.`first_name` AS t0_r1, `users`.`last_name` AS t0_r2,
`users`.`email` AS t0_r3, `users`.`homepage` AS t0_r4, `users`.`about`
AS t0_r5, `users`.`signature` AS t0_r6, `users`.`password_hash` AS
t0_r7, `users`.`password_salt` AS t0_r8, `users`.`ip` AS t0_r9,
`users`.`agent` AS t0_r10, `users`.`referer` AS t0_r11,
`users`.`remember_me` AS t0_r12, `users`.`token_key` AS t0_r13,
`users`.`token_expiration` AS t0_r14, `users`.`anonymous` AS t0_r15,
`users`.`created_at` AS t0_r16, `users`.`updated_at` AS t0_r17,
`users`.`verified_at` AS t0_r18, `users`.`deleted_at` AS t0_r19,
`roles`.`id` AS t1_r0, `roles`.`user_id` AS t1_r1,
`roles`.`context_id` AS t1_r2, `roles`.`context_type` AS t1_r3,
`roles`.`type` AS t1_r4, `memberships`.`id` AS t2_r0,
`memberships`.`site_id` AS t2_r1, `memberships`.`user_id` AS t2_r2,
`memberships`.`created_at` AS t2_r3, `memberships`.`updated_at` AS
t2_r4 FROM `users` LEFT OUTER JOIN `roles` ON roles.user_id = users.id
LEFT OUTER JOIN `memberships` ON memberships.user_id = users.id WHERE
(memberships.site_id = 1 OR (memberships.site_id IS NULL AND
roles.type = 'Role::Superuser'))
Comment Load (0.4ms) SELECT * FROM `comments` WHERE
(`comments`.site_id = 1 AND (comments.approved = 0)) ORDER BY
comments.created_at, comments.id
Activity Load (0.3ms) SELECT * FROM `activities` WHERE
(`activities`.site_id = 1) ORDER BY activities.created_at DESC LIMIT
50
Rendering template within layouts/admin
Rendering admin/sites/show
Rendered admin/activities/_activities (16.1ms)
Rendered admin/sites/_recent_users (1.5ms)
Rendered admin/sites/_unapproved_comments (1.5ms)
CACHE (0.0ms) SELECT * FROM `sections` WHERE (`sections`.site_id =
1) ORDER BY lft, lft
CACHE (0.0ms) SELECT * FROM `sites` WHERE (`sites`.`id` = 1)
Rendered admin/shared/_header (238.4ms)
Rendered shared/_flash (0.3ms)
Completed in 1009ms (View: 906, DB: 12) | 200 OK [http://localhost/
admin/sites/1]

[axyd]

Hello!

I tried adva-cms, it looks nice but speed is very slow (1-2 sec per
request). Tried on both sqlite3 and mysql, results are the same.
Maybe i missed something? Some indexes or anything else?

Installation instruction:
- rails adva -m http://github.com/svenfuchs/adva_cms/raw/master/templates/adva-cms.0.2.1.rb
- rake adva:install:all
- script/server

Log:
------------------------------------------------------

[Rob Sterner]

Heya,

That's not terrible for development mode. Have you tried production mode?

script/server -e production

You may need to create/migrate/populate a yourapp_production database.

Rob