Hi,
I have a table mysql table with 23million records that is over 5GB and performing select queries such as WHERE x like '%y%' is taking forever.
Using:
AppServ 2.5.10
Apache 2.2.8
PHP 5.2.6
MySQL 5.0.51b
phpMyAdmin-2.10.3
Software and configuration wise what can I do to run these queries faster?
There is only 1 user that needs to access it
Willing to use cloud server also
table is very simple:
CREATE TABLE IF NOT EXISTS `data` (
`did` int(100) NOT NULL auto_increment,
`dfile` varchar(255) NOT NULL,
`0` varchar(255) NOT NULL,
`1` varchar(255) NOT NULL,
`2` varchar(255) NOT NULL,
`3` varchar(255) NOT NULL,
`4` varchar(255) NOT NULL,
`5` varchar(255) NOT NULL,
`6` varchar(255) NOT NULL,
`7` varchar(255) NOT NULL,
`8` varchar(255) NOT NULL,
`9` varchar(255) NOT NULL,
`10` varchar(255) NOT NULL,
`11` varchar(255) NOT NULL,
`12` varchar(255) NOT NULL,
`13` varchar(255) NOT NULL,
`14` varchar(255) NOT NULL,
`15` varchar(255) NOT NULL,
`16` varchar(255) NOT NULL,
`17` varchar(255) NOT NULL,
`18` varchar(255) NOT NULL,
`19` varchar(255) NOT NULL,
`20` varchar(255) NOT NULL,
`21` varchar(255) NOT NULL,
`22` varchar(255) NOT NULL,
`23` varchar(255) NOT NULL,
PRIMARY KEY (`did`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=23415599 ;
Thanks in advance
PyraX