[cedivad]

Originally Posted by cedivad

vBulletin by default have the index for "dateline" already setted.

Ok, maybe i was wrong

mysql> ALTER TABLE `thread` ADD INDEX (`dateline`);
Query OK, 5236687 rows affected (4 min 41.92 sec)
Records: 5236687  Duplicates: 0  Warnings: 0

It now takes 0.5 sec else if it's not cached (i suppose). A great improvement

--------------- Added [DATE]1264021277[/DATE] at [TIME]1264021277[/TIME] ---------------

Originally Posted by SirAdrian

Have that all run as a cron... surely you wouldn't need all that as live data.

In fact i tought to do a static file cache... something like 16000 files of 0.4 mega each with the cache of every page of every category except the last one, that must be loaded "live". I think it's the best way