Gallery VERY slow: Problem? Lots of users/images?

[cisiodon]

U can use PHPMyadmin and go to DataBase and select the tables and fields you can index:

Example

4-_images_users -> user_id -> name

Then : name of index: name_id

Thatīs all !!

Mike

[rohanrohanrohan]

ok on my phpwebadmin i have list of all the fields in the tables. there is an option in each field, to index.

i clicked on one and it simpy said "field indexed"

is this the only thing i do?

[cisiodon]

YOu select another fields that is not indexed......of course, important field that you think is good and can improve the performance.

Mike

[cisiodon]

Make sure !!

In database you have:

Database -> Tables -> Fields....

Example:

   
PHP: MySql Table Manager
 
Create new Table    

 
Total number of records 29, displayed on 2 pages.
This Page | >> 2 |   cat_id cat_name cat_description cat_parent_id cat_hits cat_order auth_viewcat auth_viewimage auth_download auth_upload auth_directupload auth_vote auth_sendpostcard auth_readcomment auth_postcomment


This is an example of 4images_categories..


You can n index : auth_vote....

Mike

Mike

[rohanrohanrohan]

guys any other suggestions to improve gallery speed? plz wanna make the this ultimate thread on improving gallery speed so everyone can use as a reference

[V@no]

just one more thing I just found out, if u have "big" templates it will slow down script to...I just tryed use default template on my site and it was about 3-4 times faster then with my template...

[relu]

Is adodb.inc.php  usefull? I don't see any diference...i have much server load.. Really need some changes to improve server load... The new released version have some improvements?