4images Forum & Community

4images Issues / Ausgaben => Installation, Update & Configuration => Topic started by: MasterRye on June 04, 2005, 03:37:17 PM

Title: My Albums are slow, will changing any of these help?
Post by: MasterRye on June 04, 2005, 03:37:17 PM
Will Changing any of these Tables increase my speed, MyISAM is used in most. I have already searched and found out how to disable the Random pictures. you can see the very slow speed here. http://www.godsofgamingclan.com/albums It has been this way since I can remember. I am expecting more traffic now and this wories me. Thank You.

Quote
Table Records Type Size Comments 4images_categories 52 MyISAM 7.5 KB
 
4images_comments 4      MyISAM 5.3 KB
4images_groupaccess 23  MyISAM 3.4 KB
4images_groupmatch 24  MyISAM 3.4 KB
4images_groups 24         MyISAM 2.6 KB 
4images_images 166        MyISAM 30.0 KB
4images_images_temp 0  MyISAM 1.0 KB
4images_lightboxes 21     MyISAM 4.1 KB
4images_postcards 3       MyISAM 2.8 KB
4images_sessions 1         HEAP 1.1 MB
4images_sessionvars 0     MyISAM 1.0 KB
4images_settings 60       MyISAM 4.8 KB
4images_users 28           MyISAM 9.4 KB
4images_wordlist 265      MyISAM 14.5 KB
4images_wordmatch 471 MyISAM 15.8 KB
 15 table(s) 1,142 -- 1.2 MB



Operating system Linux
 
Kernel version 
Machine Type i686
Apache version 1.3.33 (Unix)
PERL version 5.8.6
Path to PERL   
Path to sendmail 
Installed Perl Modules Click to View
PHP version 4.3.10
MySQL version 4.x.xx- 
cPanel Build xx.x.x-STABLE 
Theme cPanel X vx.x.x

Title: Re: My Albums are slow, will changing any of these help?
Post by: V@no on June 04, 2005, 03:56:46 PM
I belive u ment: http://www.godsofgamingclan.com/albums (http://www.godsofgamingclan.com/albums/)

;)

As of speed, I found it extreamly fast...
maybe your connection with the server is slow?
for debuging purposes uncomment from includes/constants.php:
Code: [Select]
// define("PRINT_STATS", 1);
// define("PRINT_QUERIES", 1);
// define('PRINT_CACHE_MESSAGES', 1);
(remove "//")
Title: Re: My Albums are slow, will changing any of these help?
Post by: Chris on June 04, 2005, 09:12:37 PM
No problems for me either.  Your home page logo is 368K, ouch.  You can definitely help by making these pictures more web friendly.  That logo shouldn't have to be any larger than something like 50k

It could also be that when you experienced a slow down, someone else was conducting a heavy download or upload for a different site on the same server.  I've seen that before too
Title: Re: My Albums are slow, will changing any of these help?
Post by: V@no on June 04, 2005, 09:23:00 PM
and the top animated logo is 190kb...for such type of animation I think u'd better off with a flash-based animation, the file size would probably not more then 20kb either...
Title: Re: My Albums are slow, will changing any of these help?
Post by: MasterRye on June 05, 2005, 01:23:52 AM
Man I feel silly than. I just have asked more members opinion. But what about the tweaking of the tables? YAY or NAY? Unfortunantly I do not know flash or I would gladly use it, and in our forums banner too. That one is about 4.4MB LOL, All I know is Photoshop. Thanks for your responses. :)
Title: Re: My Albums are slow, will changing any of these help?
Post by: V@no on June 05, 2005, 03:10:13 AM
since two reponses u've got confirmed that the site working fast, what is the point do anything to the database? ;)
perhaps u should try your site with default template and see if it still loads slow for u.