[Frenck]

Like some people have noticed,

If you have a big forum (like euhm.. about.. lets say 100.000 posts, like mine)
Than the welcome panel hack really slows down the page!!!

My page generation time with this hack is 2.5 seconds!!!
That's all because of these 2:

Query: SELECT COUNT(*) AS threads FROM thread WHERE lastpost > '1018738585'
Time before: 0.2525429725647
Time after: 0.34668505191803

Query: SELECT count(*) AS posts FROM post WHERE dateline > '1018738585'
Time before: 0.3487149477005
Time after: 1.9500440120697

You can speed this up by adding 2 indexes to your tables.

Just run these 2 query's once on your database:

ALTER TABLE `thread` ADD INDEX(`'lastpost`);
ALTER TABLE `post` ADD INDEX(`dateline`);


After running these 2 I was verry glad with the result:

Query: SELECT COUNT(*) AS threads FROM thread WHERE lastpost > '1018738585'
Time before: 0.40777695178986
Time after: 0.40917897224426

Query: SELECT count(*) AS posts FROM post WHERE dateline > '1018738585'
Time before: 0.41155600547791
Time after: 0.41288495063782

My page generation time is 0.5 seconds after this simpel modification.

Anyways, THX FOR THIS GREAT HACK!!!