Re: how speed up data retrieve from large table (need big help)

[tbhaw tan]

Jay Pipes,
Hi, Jay this my tale structure

CREATE TABLE `resume_personal` (
`resume_id` int(11) NOT NULL auto_increment,
`user_id` varchar(50) NOT NULL default '',
`email` varchar(50) default NULL,
`pwd` text NOT NULL,
`name` varchar(80) NOT NULL default '',
`gender` char(1) NOT NULL default '',
`new_ic` varchar(14) default NULL,
`old_ic` varchar(14) default NULL,
`passport` varchar(20) default NULL,
`dob` date NOT NULL default '0000-00-00',
`address1` varchar(80) default NULL,
`address2` varchar(80) default NULL,
`city` varchar(30) default NULL,
`postcode` varchar(7) default NULL,
`state` varchar(30) default NULL,
`house_tel` varchar(12) default NULL,
`office_tel` varchar(12) default NULL,
`hand_tel` varchar(12) default NULL,
`marital` varchar(15) default NULL,
`race` char(1) NOT NULL default '',
`no_in_family` char(2) NOT NULL default '',
`position_in_family` char(1) NOT NULL default '',
`expected_sal` varchar(7) default NULL,
`earliest_date_commence` date NOT NULL default '0000-00-00',
`license` varchar(30) default NULL,
`spouse_name` varchar(80) default NULL,
`spouse_job` varchar(80) default NULL,
`spouse_company` varchar(80) default NULL,
`spouse_phone` varchar(12) default NULL,
`photo_location` varchar(80) default NULL,
`spoken1` varchar(30) default NULL,
`spoken2` varchar(30) default NULL,
`spoken3` varchar(30) default NULL,
`spoken4` varchar(30) default NULL,
`written1` varchar(30) default NULL,
`written2` varchar(30) default NULL,
`written3` varchar(30) default NULL,
`written4` varchar(30) default NULL,
`status` char(1) NOT NULL default '0',
`datestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`position` varchar(100) default NULL,
`other_written` text,
`other_spoken` text,
`apply_date` datetime NOT NULL default '0000-00-00 00:00:00',
`access_level` int(1) NOT NULL default '0',
`corr_address1` varchar(80) NOT NULL default '',
`corr_address2` varchar(80) NOT NULL default '',
`corr_city` varchar(30) NOT NULL default '',
`corr_postcode` varchar(7) NOT NULL default '',
`corr_state` varchar(30) NOT NULL default '',
`mail_subscription` varchar(10) NOT NULL default 'Y',
`register_date` datetime NOT NULL default '0000-00-00 00:00:00',
`last_apply_date` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`resume_id`),
KEY `name` (`name`),
KEY `apply_date` (`apply_date`),
KEY `new_ic` (`new_ic`),
) TYPE=MyISAM AUTO_INCREMENT=58537 ;

Hope that this is the thing that you wanted .



Jay Pipes wrote:
> tbhaw tan,
>
> Could you show the result of an EXPLAIN on an
> actual SELECT statement you're running?
>
> It would help to diagnose what's going on in the
> query...
>
> Thx
>