| |
| Visitors |
Current visitors : 6
Members : 0
More...
|
|
|
| Forum slowdown |
Posted on 22 October 2002 at 16:27:00 by Gat. EN - Global news
Well, some people warn me that some sections of the forum was slow (like Functionnalities).
It must be better, I've change some of the code that make it faster.
I'll give you the code ASAP.
In fact, I've added a new column in the Posts table, PostLastDate (varchar 17).
And I fill it when people do a new post or answer to another one with the current date.
Then, I've just to do a TOP PostParent ORDER BY PostLastDate DESC when I want to display last posts sorted by date of last post.
The old query became too heavy when there are too much posts in the database.
|
Read : 468 | Back
|
|
|
|
|
|
