<?php $sql = mysql_query("SELECT id,tag,name,namepl,url,time,datepub,thumb,view FROM baza WHERE status='2' AND datepub<'".time()."' ORDER BY datepub DESC LIMIT $start,".NA_STRONIE); ?>
struktura bazy
CREATE TABLE `baza` ( `id` int(11) NOT NULL AUTO_INCREMENT, `tag` varchar(255) character SET utf8 collate utf8_unicode_ci NOT NULL DEFAULT '', `name` varchar(255) character SET utf8 collate utf8_unicode_ci NOT NULL DEFAULT '', `namepl` varchar(255) character SET utf8 collate utf8_unicode_ci NOT NULL DEFAULT '', `url` varchar(255) character SET utf8 collate utf8_unicode_ci NOT NULL DEFAULT '', `time` varchar(8) character SET utf8 collate utf8_unicode_ci NOT NULL DEFAULT '', `date` int(11) NOT NULL DEFAULT '0', `datepub` int(11) NOT NULL DEFAULT '0', `status` int(2) NOT NULL DEFAULT '0', `host` int(2) NOT NULL DEFAULT '0', `video_id_host` varchar(255) character SET utf8 collate utf8_unicode_ci NOT NULL DEFAULT '', `info` varchar(255) character SET utf8 collate utf8_unicode_ci NOT NULL DEFAULT '', `flv` text character SET utf8 collate utf8_unicode_ci NOT NULL, `embed` text character SET utf8 collate utf8_unicode_ci NOT NULL, `thumb` varchar(255) character SET utf8 collate utf8_unicode_ci NOT NULL DEFAULT '', `view` int(11) NOT NULL DEFAULT '0', `comment` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `thumb` (`thumb`), UNIQUE KEY `url` (`url`), KEY `datepub` (`datepub`), KEY `status` (`status`), KEY `url_2` (`url`), KEY `id` (`id`), KEY `tag` (`tag`), KEY `view` (`view`) ) ENGINE=MyISAM DEFAULT CHARSET=latin2
w tabeli jest ponad 177 tys wpisów i przez to ładowanie strony twa ponad 10 sekund po zmniejszeniu tabeli do 50 tys wpisów strona chodzi ponownie szybko co zrobić aby zoptymalizować zapytanie lub bazę aby dobrze działała strona przy 177 tys wpisach?