| Show Own Topics and Files [message #34602] |
Thu, 09 November 2006 08:12  |
|
|
|
There is a button "Show Own Posts" in Control Panel, but is it possible to add also "Show Own Topics" and "Show Own Attached Files"?.
|
|
|
|
|
|
|
|
| Re: Show Own Topics and Files [message #34631 is a reply to message #34618] |
Fri, 10 November 2006 16:09  |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
A slow query is a slow query and when you consider MySQL myISAM tables where a read lock is set on entire table, even a single slow query can make the entire forum slow down.
FUDforum Core Developer
|
|
|
|
|
|
| Re: Show Own Topics and Files [message #34664 is a reply to message #34663] |
Mon, 13 November 2006 14:46 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Well, you already have a way of displaying your own posts in FUDforum. The reason it is slow simply stems from that fact that some people have posted thousands of messages and no index will let you avoid the overhead of fetching that many entries. The real slowdown however, comes when you join this multi-thousand result set with another table multiplying the numbers of the affected rows.
FUDforum Core Developer
|
|
|
|
| Re: Show Own Topics and Files [message #34666 is a reply to message #34664] |
Mon, 13 November 2006 15:01 |
|
|
Oh, sorry, in my previous message I mean not:
| Quote: |
Is there any other way to make a displaying of own posts and topics faster?
|
but:
| Quote: |
Is there any other way to make a displaying of own files and topics faster?
|
Just a little mistake 
So, my users saying, that they do not use "Show Own Posts" often. Instead they requesting a "Show Own Topics and Files" feature. That should`t be to slow, don`t it?
|
|
|
|
| Re: Show Own Topics and Files [message #34679 is a reply to message #34666] |
Tue, 14 November 2006 14:53 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Showing own files would actually be extremely slow, since the file table does not reference the user id, meaning that to get of list of attachments belong to a user you'd need to select all messages and then do a join of all these messages on the attachment table. As you can imagine this is by no means a "fast" query to execute.
As far as list of own topics, pretty much the same process except we replace the attachment table with the threads table.
FUDforum Core Developer
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]