PyraX

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

Hey Guys, Ok so here is my issue. Server 1 has the mysql database and is constantly collecting data currently 148.9 MiB (win2008 server with Appserv installed) Server 2 has all my php files and domain eg. http://www.example.com (Linux/cpanel) Server 2 connects to server 1 for data on every page which causes a massive delay in page load time Resolving domain to server 1 is not an option What I want to do is great a new mysql database on Server 2 that syncs daily from Server 1 automatically How do I do this?

yay just got that too thanks

fixed it by doing preg_match_all('/onclick="return false;">.*?<\/a>/',$data,$matches); NEXT QUESTION How do I make it so that it doesnt include onclick="return false;"> and </a> in the results?

its giving me the error message: Warning: preg_match_all() [function.preg-match-all]: Unknown modifier 'a' in C:\AppServ\www\index.php on line 53

im trying to find everything between <a href="javascript:void(0);" onclick="return false;"> and </a> Here is what I have tried but it didnt work preg_match_all('/<a href="javascript:void(0);" onclick="return false;">.*?</a>/',$data,$matches);

Yes thats right, cheapest cost first then shortest time

Thanks adam, the only thing that matters is the price and the time, distance is irrelevant

Hey everyone, Im writing some code that has to work out a route based on linking airports and output all the flights it takes to get there, tried searching just dont really know what to search for The data table looks like this ID, Origin, Destination, DatetimeDeparting, DatetimeArriving, Price 1, BKK, CNX, 2010-10-14 12:00:00, 2010-10-14 14:00:00, 125 2, STN, BKK, 2010-10-13 18:00:00, 2010-10-13 22:00:00, 300 etc. What is the easiest way of working out the path from STN to CNX via BKK? UPDATE: Just to make it more interesting there will be instances where there is more than 1 path eg. STN -> KUL -> BKK -> CNX