Help NEEDED !!!!

[Yatahonga]

Hi,

I would like to know, how to optimize my web site : http://www.yatahonga.com/

With only 11 active users I have :
Page generated in 18.344828 seconds with 10 queries

Witch query are very long ?

Thank's
(of course I have 6270 images in 40 categories !!!!)

[Yatahonga]

I had : Index :
alter table 4images_categories add index idx_catname (cat_name,cat_id);
alter table 4images_comments add index idx_cmtid (comment_id);
alter table 4images_comments add index idx_cmtuname (user_name);
alter table 4images_groupaccess add index idx_grpaccess (group_id,cat_id);
alter table 4images_groupmatch add index idx_grpmatch (group_id,user_id);
alter table 4images_groups add index idx_grp (group_id,group_name);
alter table 4images_images add index idx_images (image_id,image_name);
alter table 4images_images_temp add index idx_imgtmp (image_id,image_name);
alter table 4images_lightboxes add index idx_lightbox (lightbox_id);
alter table 4images_postcards add index idx_postcards (postcard_id,image_id);
alter table 4images_sessions add index idx_sessions (session_lastaction);
alter table 4images_sessionvars add index idx_sessvars (session_id,sessionvars_name);
alter table 4images_wordmatch add index idx_wordmatch (image_id,word_id);
alter table 4images_users add index idx_users (user_id ,user_name );

It their another think to do ?

Thank's

Cyrille

[Yatahonga]

Does anyone have an answer ?

With 22 people :
Page generated in 10.235452 seconds with 10 queries, spending 5.849000 seconds doing MySQL queries and 4.386452 doing PHP things.

Thanks

Cyrille

[V@no]

try to disable random_image (random_cat_image) in /includes/constants.php

[Yatahonga]

Hi V@no,

I change to :
define('SHOW_RANDOM_IMAGE', 0);
define('SHOW_RANDOM_CAT_IMAGE', 0);

And I have :
Page generated in 8.718731 seconds with 7 queries, spending 5.845000 seconds doing MySQL queries and 2.873731 doing PHP things

with 22 users

Cyrille