MySQL Forums
Forum List  »  Performance

Re: Slow connection, urgent!
Posted by: Nicklas Forsberg
Date: October 08, 2005 06:22AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
2480
September 30, 2005 12:37PM
1439
September 30, 2005 02:20PM
1723
September 30, 2005 04:35PM
1414
September 30, 2005 07:55PM
1636
October 08, 2005 05:01AM
1491
October 08, 2005 05:47AM
Re: Slow connection, urgent!
1649
October 08, 2005 06:22AM
1425
October 11, 2005 09:45AM
1437
October 13, 2005 09:35AM
1399
October 16, 2005 10:58AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.