So low to load...

[MadKroll]

Hi!

When a click on the link for show an album where there is much pics, it's so long to load...
But, if there is no pics in the album that load fastly
I work i local... (EasyPHP.org)

Bye all =)

[MadKroll]

Help-me plz !!!
There is a patch ?

thx all +

[Chris]

Check includes/constants.php

Code: [Select]


// If you have a lot of images in your database,
// the random image function could make your programm slow.
// Try first to set "SHOW_RANDOM_CAT_IMAGE" to 0.
define('SHOW_RANDOM_IMAGE', 1);
define('SHOW_RANDOM_CAT_IMAGE', 1);

[MadKroll]

:/
I have tryed:

define('SHOW_RANDOM_IMAGE', 1);
define('SHOW_RANDOM_CAT_IMAGE', 0);

and

define('SHOW_RANDOM_IMAGE', 0);
define('SHOW_RANDOM_CAT_IMAGE', 0);

and

and define('SHOW_RANDOM_IMAGE', 0;
define('SHOW_RANDOM_CAT_IMAGE', 1);

but, there is no changes :/ Alwayys lonng and after, it shows a blank page (because too long)

[cisiodon]

Go to your database and make Indexes.


MIke

[MadKroll]

how to do Indexes ?!

thx mike

[cisiodon]

Use PHPMyAdmin and make indexes.........

This is an example that indexes tables in PostNuke...

alter table nuke_comments add index idx_pid (pn_pid);
    alter table nuke_comments add index idx_sid (pn_sid);
    alter table nuke_group_membership add index idx_ug (pn_uid,pn_gid);
    alter table nuke_message add index idx_exp (pn_active,pn_expire);
    alter table nuke_modules add index idx_name (pn_name);
    alter table nuke_poll_data add index idx_pollid (pn_pollid);
    alter table nuke_pollcomments add index idx_pollid (pn_pollid);
    alter table nuke_referer add index idx_url (pn_url);
    alter table nuke_stats_date add index idx_date (pn_date);
    alter table nuke_session_info add index idx_last (pn_lastused);
    alter table nuke_stories add index idx_catid (pn_catid);
    alter table nuke_stories add index idx_topic (pn_topic);
    alter table nuke_user_data add index idx_uid (pn_uda_uid);
    alter table nuke_userblocks add index idx_ub (pn_uid,pn_bid);
    alter table nuke_users add index idx_uname (pn_uname);

Hope help you !!

Mike

[MadKroll]

?
i must change what ? (table names, and how choose names of index ?)
Have u the code for 4images tables ?

Thx

bye all

[MadKroll]

i have do it:

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 site_users add index idx_users (id,pseudo);

Its always loww
Plz i need help !!!

[MadKroll]

HELPPPPPPPPPPPPPPPPP-ME !!!!!!!!!!!
Its so lonnnnnnnnnnnnnnnnnnnnnng to loaddd

[cisiodon]

What is your OS and http server ?
Are you Local Hosting ?

MIke

[MadKroll]

Yes, i am in Local Hosting (using EasyPHP.org) and my OS is Windows XP...

Thats all

[V@no]

have u checked phperror.log and apache error.log files?

[MadKroll]

yes, nothing...
But, my website is fast, vbulletin is fast, just the album of 4images where there is many pictures (23) is looooooooow and looooooooong !

Plz need assistance =)

[cisiodon]

Normally when enabled GD bibliotec in php.ini on Windows then 4images too slow.
You Must specify also the TEMP dir in php.ini and memory to run PHP scripts.

MIke