Clan Themes, We Make Clans Look Good!

CT on Facebook

Latest Product

Battlefield 3 Stats Module

User Box

Anonymous

38.107.179.217

PND Downloads Feed

How to Delete or Reset yo...

Lost your admin password ?Â Cant login to your admin account ?This sh...

Back Online & Stuff

Look at us with our nifty website back up and running… Seriousl...

How to edit the admins in...

Here is a way to make someone admin in your forums on your Evo site. I...

Demo Splash Screen

Ped @ Clan Themes has released a simple splash screen entrance hack.Â ...

Free Phpnuke Business The...

This is the 6th Business theme for Phpnuke that Clan Themes has releas...

Tricked Out Slider

We have seen some great new things come out of Tricked Out News and th...

Phpnuke Downloads

Custom Work

www.clanthemes.com :: View topic - Speed up your nuke evolution.- works on all versions!!

Speed up your nuke evolution.- works on all versions!!

2 Replies / 886 Views


www.clanthemes.com Forum Index » Nuke-Evolution	View previous topic :: View next topic

PocketRocket
Reputation: 21.9
Local time: 5:54 AM

Rocket Noob

0.03 posts per day
Medals: 0

Joined: May 12, 2009
Last Visit: 10 Feb 2012
Posts: 26
Points: 928

Speed up your nuke evolution.- works on all versions!! Posted: Tue Sep 08, 2009 11:49 pm

These changes should only be made if you are willing to take a risk and try it. The pay off is it will speed up your site. The downside is these changes take up more SQL memory which can take down your DB. It did here when I over did the changes.

But what I am giving you has been on the site for the last few days and no issues have been reported. However these should be treated with EXTREME caution.

Run the following in PHPMyAdmin:

Code:

ALTER TABLE `nuke_modules` ADD INDEX ( `active` );
ALTER TABLE `nuke_blocks` ADD INDEX `active_weight` ( `active` , `weight` ) ;
ALTER TABLE `nuke_blocks` ADD INDEX `time_bid` ( `time` , `bid` );
ALTER TABLE `nuke_stories` ADD INDEX `topic_ihome_time` ( `topic` , `ihome` , `time` );
ALTER TABLE `nuke_stories` ADD INDEX `topic_sid` ( `topic` , `sid` );
ALTER TABLE `nuke_banner` ADD INDEX `position_active` ( `position` , `active` );
ALTER TABLE `nuke_session` ADD INDEX ( `uname` );
ALTER TABLE `nuke_evolution` ADD INDEX ( `evo_field` );
ALTER TABLE `nuke_bbadvanced_username_color` ADD INDEX `groupid_groupweight` ( `group_id` , `group_weight` );
ALTER TABLE `nuke_bbranks` ADD INDEX `rankspecial_rankmin` ( `rank_special` , `rank_min` );
ALTER TABLE `nuke_bbcategories` ADD INDEX ( `cat_title` );
ALTER TABLE `nuke_themes` ADD INDEX ( `theme_name` );
ALTER TABLE `nuke_nsnst_admins` ADD INDEX ( `password_md5` );
ALTER TABLE `nuke_session` ADD INDEX `guest_uname` ( `guest` , `uname` );
ALTER TABLE `nuke_session` ADD INDEX ( `host_addr` );
ALTER TABLE `nuke_bbadvanced_username_color` ADD INDEX ( `group_name` );

ALTER TABLE `nuke_stories_cat` ADD INDEX ( `title` );
ALTER TABLE `nuke_donators` ADD INDEX ( `dondate` );
ALTER TABLE `nuke_downloads_downloads` ADD INDEX ( `hits` );
ALTER TABLE `nuke_downloads_downloads` ADD INDEX ( `active` );
ALTER TABLE `nuke_evo_userinfo` ADD INDEX ( `active` );
ALTER TABLE `nuke_modules` ADD INDEX `active_inmenu_catid` ( `active` , `inmenu` , `cat_id` );
ALTER TABLE `nuke_modules_cat` ADD INDEX ( `pos` );
ALTER TABLE `nuke_modules` ADD INDEX ( `inmenu` );
ALTER TABLE `nuke_users` ADD INDEX ( `user_level` );

ALTER TABLE `nuke_poll_data` ADD INDEX ( `pollID` );
ALTER TABLE `nuke_poll_data` ADD INDEX `pollid_voteit` ( `pollID` , `voteID` );
ALTER TABLE `nuke_donators` ADD INDEX ( `donto` );
ALTER TABLE `nuke_donators` ADD INDEX ( `donshow` );

And to undo if any errors

Code:

ALTER TABLE `nuke_modules` DROP INDEX `active` ;
ALTER TABLE `nuke_blocks` DROP INDEX `active_weight` ;
ALTER TABLE `nuke_blocks` DROP INDEX `time_bid` ;
ALTER TABLE `nuke_stories` DROP INDEX `topic_ihome_time` ;
ALTER TABLE `nuke_stories` DROP INDEX `topic_sid` ;
ALTER TABLE `nuke_banner` DROP INDEX `position_active` ;
ALTER TABLE `nuke_session` DROP INDEX `uname` ;
ALTER TABLE `nuke_evolution` DROP INDEX `evo_field` ;
ALTER TABLE `nuke_bbadvanced_username_color` DROP INDEX `groupid_groupweight` ;
ALTER TABLE `nuke_bbranks` DROP INDEX `rankspecial_rankmin` ;
ALTER TABLE `nuke_bbcategories` DROP INDEX `cat_title` ;
ALTER TABLE `nuke_themes` DROP INDEX `theme_name` ;
ALTER TABLE `nuke_nsnst_admins` DROP INDEX `password_md5` ;
ALTER TABLE `nuke_session` DROP INDEX `guest_uname` ;
ALTER TABLE `nuke_session` DROP INDEX `host_addr` ;
ALTER TABLE `nuke_bbadvanced_username_color` DROP INDEX `group_name` ;

ALTER TABLE `nuke_stories_cat` DROP INDEX `title` ;
ALTER TABLE `nuke_donators` DROP INDEX `dondate` ;
ALTER TABLE `nuke_downloads_downloads` DROP INDEX `hits` ;
ALTER TABLE `nuke_downloads_downloads` DROP INDEX `active` ;
ALTER TABLE `nuke_evo_userinfo` DROP INDEX `active` ;
ALTER TABLE `nuke_modules` DROP INDEX `active_inmenu_catid` ;
ALTER TABLE `nuke_modules_cat` DROP INDEX `pos` ;
ALTER TABLE `nuke_modules` DROP INDEX `inmenu` ;
ALTER TABLE `nuke_users` DROP INDEX `user_level` ;

ALTER TABLE `nuke_poll_data` DROP INDEX `pollID` ;
ALTER TABLE `nuke_poll_data` DROP INDEX `pollid_voteit` ;
ALTER TABLE `nuke_donators` DROP INDEX `donto` ;
ALTER TABLE `nuke_donators` DROP INDEX `donshow` ;

DreAdeDcoRpSE
Reputation: 2221.6
votes: 28
Local time: 4:54 AM
Location: Back of your Mind

Forums Moderator

1.53 posts per day
Medals: 3 (View more...)

Site Admin

Joined: Sep 22, 2007
Last Visit: 10 Feb 2012
Posts: 2459
Points: 128885

Speed up your nuke evolution.- works on all versions!! Posted: Wed Sep 09, 2009 12:44 am
Shop Purchases:Enemy Territory Theme (Aviator) for PHP Nuke · Clan Roster 2.0 · · Modern Warfare 3 Xtreme Theme

You may like to give credit to the ones that posted this originally.

Technocrat and SLiCK_303 Over at www.nuke-evolution.com

Original post found here. http://www.nuke-evolution.com/modules.php?name=Forums&file=viewtopic&t=16105

Genuine
Reputation: 66
Local time: 9:54 AM

Welcome to Clan-Themes

0.17 posts per day
Medals: 2 (View more...)

Joined: Jan 30, 2008
Last Visit: 09 Feb 2012
Posts: 249
Points: 36177

Re: Speed up your nuke evolution.- works on all versions!! Posted: Thu Sep 10, 2009 1:20 pm
Shop Purchases:Crysis Theme · CRYSIS X-Theme (Ultimate) for PhpNuke · Lord of The Rings Theme · Clan Roster 2.0 · Diablo 3 Ultimate Theme · Battlefield 2142-X · Modern Warfare 2 Evo · Modern Gamer Evo Multi Theme · Battlefield: Bad Company 2 Evo Theme · Crysis 2 Evo Theme · Battlefield 3 Evo Theme · Modern Warfare 3 Evo Theme · Star Wars Old Republic Evo Theme · Battlefield 3 Stats Module

thanx for this just update my site with it and its alot faster and no errors as of yet

great work

www.clanthemes.com Forum Index » Nuke-Evolution

2 Replies / 886 Views
Page 1 of 1
All times are GMT

Display posts from previous:

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum

Company Information
Home · About Us · Affiliates · Advertising
Link To Us · Newsletter · Contact Us · Site Map
All content © Clan Themes 2006 - 2012
Based on RavenNuke