Hey, I installed this hack a while ago and it worked perfectly.I recently upgraded to 2.2.4, had a few problems but got it working in the end.Now I have another problem with it, it used to say something like 'There have been XX of new posts since your last visit' but now that part does not show up.I have checked the index.php file and the templates and they are all fine, can anybody help?

:disappointed:

Never mind, fixed it.

Think I am going mental, need more sleep. :confused:

@Frenck

One of the queries you said to run isnt valid - you had a ' where there shouldnt be one...

here they are correct

[QUOTE]Originally posted by Airwaves
@Frenck

One of the queries you said to run isnt valid - you had a ' where there shouldnt be one...

here they are correct

PHP Code:

---

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


---

Which kind of index table size increment should generate adding those two or three index upon dates ?
And how a search on could be measured faster ?

Thnx

My "post" table size before creating the index:

Data 30,022 KB
Index 3,482 KB +
=============
Total 33,504 KB


After creating the index on dateline:

Data 30,022 KB
Index 4,276 KB +
=============
Total 34,298 KB


In my case the table has grown about 2.3698663% :)

Thank you very much for these numbers. What about speed increase performances ? Are they appreciable ?
(for example on lastpost searches or today's posts)
:)

If you took time to take a look @ a post of me... a little higer...

Ow well lets cut & paste...

before:

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

as you can see, the query needs about 1.6 seconds to complete.
(about 100.000 posts in the forum)

after:

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

Wel.. I really like the result... Just 0.001328 seconds for the query to complete.

I think this result is really worth the 2.3698663% growing :classic:

Very cool!
I added index on dateline fields in post, thread and user (join & lastvisit) ...
Now, with a small space occupied more, I have the fastest forumhome ever... :) :) :)

What is the URL to your forum? I want to have a looksy!