Re: Slow connection, urgent!
Some table info.
# Table "tbl_members" DDL
CREATE TABLE `tbl_members` (
`ID` int(10) NOT NULL auto_increment,
`COMPANY_ID` int(10) default NULL,
`MEMBER_ID` varchar(15) default NULL,
`FIRSTNAME` varchar(255) default NULL,
`LASTNAME` varchar(255) default NULL,
`BIRTHDAY` varchar(15) default NULL,
`POST_STREET` varchar(255) default NULL,
`POST_BOX` varchar(255) default NULL,
`POST_CITY` varchar(255) default NULL,
`CONTACT_PHONE` varchar(50) default NULL,
`CONTACT_EMAIL` longtext,
`DATE_JOIN` datetime default NULL,
`DATE_END` datetime default NULL,
`INFO` longtext,
`STATUS` smallint(5) default NULL,
`GENDER` varchar(50) default NULL,
`CONTACT_ALLOW` int(10) default NULL,
`CONTACT_NEWSLETTER` int(10) default NULL,
`CONTACT_HTMLMAIL` int(10) default NULL,
`CONTACT_INACTIVITY` int(10) default NULL,
`CONTACT_BOOKING` int(10) default NULL,
`CONTACT_HOLIDAYS` int(10) default NULL,
`CONTACT_SENDTROUGH` varchar(50) default NULL,
`PRINTED_DATE` varchar(50) default NULL,
`PERSONAL_ID_NO` int(10) default NULL,
`GUEST_DATE` varchar(50) default NULL,
`INTERNET_ACTIVATION_DATE` varchar(10) default NULL,
`CORPUS_ID` int(10) default NULL,
`CONTACT_OFFICE` varchar(50) default NULL,
`CONTACT_MOBILE` varchar(50) default NULL,
`ALARMSETTING` varchar(50) default NULL,
`ALARMTIME` varchar(50) default NULL,
`ALARMTITLE` longtext,
`ALARMTEXT` longtext,
`PASSWORD` longtext,
`ONL_ACTIVATED` varchar(50) default NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `MEMBERID` (`MEMBER_ID`),
KEY `CORPUS_ID` (`CORPUS_ID`),
KEY `ID_COMPANY` (`COMPANY_ID`),
KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
-----
# Table "tbl_art_members" DDL
CREATE TABLE `tbl_art_members` (
`ID` int(10) NOT NULL auto_increment,
`MEMBERPRODUCT_ID` int(10) default NULL,
`MEMBER_ID` varchar(50) default NULL,
`PRODUCT_ID` smallint(5) default NULL,
`ART_TIMES_VALID` smallint(5) default NULL,
`ART_START_DATE` varchar(15) default NULL,
`ART_END_DATE` varchar(15) default NULL,
`PAYMENT_ID` int(10) default NULL,
`PAYMENT_MONEY` varchar(50) default NULL,
`REMOVED` int(10) default NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `MEMBER_PRODUCT_ID` (`MEMBERPRODUCT_ID`),
KEY `ART_ID` (`PRODUCT_ID`),
KEY `ART_TIMES_VALID` (`ART_TIMES_VALID`),
KEY `MEMBER_ID` (`MEMBER_ID`),
KEY `PAYMENT_ID` (`PAYMENT_ID`),
KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
----
# Table "tbl_art" DDL
CREATE TABLE `tbl_art` (
`ID` int(10) NOT NULL auto_increment,
`PRODUCT_ID` int(10) default NULL,
`ART_TITLE` varchar(100) default NULL,
`ART_DESCRIPTION` longtext,
`TRAINING` varchar(50) default NULL,
`ART_PRIZE` varchar(50) default NULL,
`ART_PRIZE_MOMS` varchar(50) default NULL,
`SETTING` int(10) default NULL,
`ART_PRIZE_DISCOUNT` smallint(5) default NULL,
`ART_MONTHS_VALID` smallint(5) default NULL,
`ART_TIMES_VALID` smallint(5) default NULL,
`ART_COMMENTS` longtext,
`ART_TIME` varchar(50) default NULL,
`INACTIVE` int(10) default NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `ART_KEY` (`PRODUCT_ID`),
KEY `ART_MONTHS_VALID` (`ART_MONTHS_VALID`),
KEY `ART_TIMES_VALID` (`ART_TIMES_VALID`),
KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
...
Thanks again.