Re: Server Stopped Responding When Having Around 1000 Request

[hemant yadav]

Hi Rick,

Thanks for your valuable reply, I already have created index for legal_practiceName,
Here following is the reason i have ordered by record with the page display to user should have order by Name in asecnding that is why i would have to do it.

CREATE TABLE `mytable` (
`Doctor_ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
`Email_ID` varchar(130) NOT NULL,
`Password` varchar(100) NOT NULL,
`Title` varchar(50) DEFAULT NULL,
`First_Name` varchar(100) DEFAULT NULL,
`Middle_Name` varchar(100) DEFAULT NULL,
`Last_Name` varchar(100) DEFAULT NULL,
`Street_Address` varchar(200) DEFAULT NULL,
`State` varchar(50) DEFAULT NULL,
`City` varchar(150) DEFAULT NULL,
`County` varchar(150) DEFAULT NULL,
`Status` int(10) unsigned DEFAULT NULL,
`ZipCode` varchar(40) DEFAULT NULL,
`Country` varchar(150) DEFAULT NULL,
`Day_Phone` varchar(100) DEFAULT NULL,
`Extension` varchar(6) DEFAULT NULL,
`Category` varchar(200) DEFAULT NULL,
`Specilization` varchar(200) DEFAULT NULL,
`Website` varchar(200) DEFAULT NULL,
`Video` varchar(100) DEFAULT NULL,
`Photo` varchar(100) DEFAULT NULL,
`Code` varchar(15) DEFAULT NULL,
`Register_IP` varchar(75) DEFAULT NULL,
`Date` datetime DEFAULT NULL,
`Latitude` varchar(50) DEFAULT NULL,
`Longitude` varchar(50) DEFAULT NULL,
`Email_Verified` int(10) unsigned DEFAULT NULL,
`BStreet_Address` varchar(200) DEFAULT NULL,
`BState` varchar(50) DEFAULT NULL,
`BCity` varchar(100) DEFAULT NULL,
`BCounty` varchar(100) DEFAULT NULL,
`BZipCode` varchar(40) DEFAULT NULL,
`BDayPhone` varchar(50) DEFAULT NULL,
`BStreet_Address1` varchar(200) DEFAULT NULL,
`BState1` varchar(50) DEFAULT NULL,
`BCity1` varchar(100) DEFAULT NULL,
`BCounty1` varchar(100) DEFAULT NULL,
`BZipCode2` varchar(40) DEFAULT NULL,
`BDayPhone1` varchar(40) DEFAULT NULL,
`Visit_Reason` varchar(200) DEFAULT NULL,
`Lic_State` varchar(50) DEFAULT NULL,
`State_licence` varchar(50) DEFAULT NULL,
`DEA_Licence` varchar(50) DEFAULT NULL,
`NPI_ProviderID` varchar(50) DEFAULT NULL,
`Legal_PracticeName` varchar(200) NOT NULL,
`IsCompleted` varchar(6) DEFAULT NULL,
`CCMEP` varchar(5) DEFAULT NULL,
`Business_Type` varchar(150) DEFAULT NULL,
`Medical_profession` varchar(150) DEFAULT NULL,
`profileurl` varchar(400) DEFAULT NULL,
`gender` varchar(45) DEFAULT NULL,
`ZipCodefull` varchar(45) DEFAULT NULL,
`Zipcode4` varchar(30) DEFAULT NULL,
`Fax` varchar(45) DEFAULT NULL,
`SIC_Code` int(10) DEFAULT NULL,
`Contact_Name` varchar(200) DEFAULT NULL,
`Company_Name` varchar(200) DEFAULT NULL,
PRIMARY KEY (`Doctor_ID`),
KEY `Category` (`Category`),
KEY `Doctors_City` (`City`),
KEY `Doctors_Zipcode` (`ZipCode`),
KEY `Doctors_ProfileURL` (`profileurl`),
KEY `Doctor_State` (`State`),
KEY `Doctors_StreetAddress` (`Street_Address`),
KEY `Doctors_LegalPracticeName` (`Legal_PracticeName`),
KEY `Doctors_ContactName` (`Contact_Name`)
) ENGINE=InnoDB AUTO_INCREMENT=1297179 DEFAULT CHARSET=latin1



Thanks for your thought on security i will check it