Is Your 4image Gallery Slow?

pasdar1 · December 12th, 2003, 11:36 PM

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!

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

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