Hello. I have big table (50 000 records, 100 Mb), and want to get 1 random record from it.
CREATE TABLE news ( id int(10) unsigned NOT NULL auto_increment, description varchar(255) NOT NULL default '', PRIMARY KEY (id) ) TYPE=MyISAM PACK_KEYS=1 CHECKSUM=1 DELAY_KEY_WRITE=1; $max_id='SELECT MAX(id) FROM news'; $id = int(rand()*$max_id+1); 'SELECT description WHERE ID='.$id; it's vary slow way. May be somebody have better idia? I use MySQL 3.23 Thanks. P.S. Thanks Rudy Lippan for help with memoru leak! С уважением, Монашёв Михаил, SoftSearch.ru ICQ# 166233339 http://softsearch.ru/ Без бэкапа по жизни.
