Hi Wizanda
Changed the banner MySql which now reads
CREATE TABLE `xoopscube_banner` (
`bid` smallint(5) unsigned NOT NULL auto_increment,
`cid` tinyint(3) unsigned NOT NULL default '0',
`imptotal` mediumint(8) unsigned NOT NULL default '0',
`impmade` mediumint(8) unsigned NOT NULL default '0',
`clicks` mediumint(8) unsigned NOT NULL default '0',
`imageurl` varchar(255) collate utf8_general_ci NOT NULL default '',
`clickurl` varchar(255) collate utf8_general_ci NOT NULL default '',
`date` int(10) NOT NULL default '0',
`htmlbanner` tinyint(1) NOT NULL default '0',
`htmlcode` text collate utf8_general_ci NOT NULL,
PRIMARY KEY (`bid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=2 ;
Yes i know its a
XOOPS Cube table but it is only a testing site
Php admin wouldn't let me make two primary keys tho
I hope im not imagining things but yes it does appear to load faster
Any more words of wisdom will be greatly appreciated
Maybe you can get a list together of what works
