icon Get the most out of Surmunity, read our tips here! Need an interesting blog to read? You've got to read the Surpass Blog! | Welcome! Please register to access all of our features.
Old December 12th, 2003, 11:36 PM   #1 (permalink)
Registered User
Fresh Surpasser
 
Joined in Dec 2003
17 posts
Gave thanks: 0
Thanked 0 times
Hi,

I was having this problem, and I was starting to get worried about this but thank God I found out whats wrong. I went on 4image's forum and saw this:

Quote:
If you have a lot of images in your database, the random category image and random image are very expensive database queries because of "RAND()" in the ORDER BY clause.

Open includes/constants.php and try changing
Code:
define('SHOW_RANDOM_CAT_IMAGE', 1);

to
Code:
define('SHOW_RANDOM_CAT_IMAGE', 0);

This disables the category related random image.


If this does not help, change
Code:
define('SHOW_RANDOM_IMAGE', 1);

to
Code:
define('SHOW_RANDOM_IMAGE', 0);

This will disable the random image completely.
I disabled it completely and it made this ALOT, and I mean ALOT faster!!! I suggest everyone do it, but the final decision is up to you. go ahead and try it, you can always change it back.

Thanks
- :kid: a muslima

PS- I just want to make sure you get my point when I say "ALOT faster." I could easily say my site (thank God) is now about 10 times faster (if not more) than it was!
__________________
Pass Server
pasdar1 is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Closed Thread


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On