FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » FUDforum Suggestions » Show Own Topics and Files
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
Show Own Topics and Files [message #34602] Thu, 09 November 2006 03:12 Go to next message
_wj_ is currently offline  _wj_   Ukraine
Messages: 57
Registered: September 2005
Location: Kiev, Ukraine
Karma: 0
Member
add to buddy list
ignore all messages by this user

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 #34606 is a reply to message #34602] Thu, 09 November 2006 12:08 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
It would be fairly slow as it would require in-direct referencing of data.

FUDforum Core Developer
Re: Show Own Topics and Files [message #34618 is a reply to message #34606] Fri, 10 November 2006 03:47 Go to previous messageGo to next message
_wj_ is currently offline  _wj_   Ukraine
Messages: 57
Registered: September 2005
Location: Kiev, Ukraine
Karma: 0
Member
add to buddy list
ignore all messages by this user

It can be displayed not automatically (when I visit my "Show Own..." page), but only after a button is pressed. That schould solve the problem with speed.
Re: Show Own Topics and Files [message #34631 is a reply to message #34618] Fri, 10 November 2006 11:09 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
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 #34663 is a reply to message #34631] Mon, 13 November 2006 06:46 Go to previous messageGo to next message
_wj_ is currently offline  _wj_   Ukraine
Messages: 57
Registered: September 2005
Location: Kiev, Ukraine
Karma: 0
Member
add to buddy list
ignore all messages by this user

Is there any other way to make a displaying of own posts and topics faster?
Many forums (Invision Power Board for example) have this options and are not slow.

[Updated on: Mon, 13 November 2006 07:16]

Report message to a moderator

Re: Show Own Topics and Files [message #34664 is a reply to message #34663] Mon, 13 November 2006 09:46 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
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 10:01 Go to previous messageGo to next message
_wj_ is currently offline  _wj_   Ukraine
Messages: 57
Registered: September 2005
Location: Kiev, Ukraine
Karma: 0
Member
add to buddy list
ignore all messages by this user

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 Smile

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 09:53 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
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
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: UNREAD where art thou?
Next Topic: Patch to show/hide reply and quote buttons
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 18 06:05:29 EST 2017

Total time taken to generate the page: 0.00772 seconds