1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

[1.1.x] Recent Posts Forum Index (Smf Style) [Paid] [Deleted]

Discussion in 'Add-on Releases' started by borbole, Feb 25, 2012.

  1. borbole

    borbole Well-Known Member

    borbole submitted a new resource:

    Recent Posts Forum Index (Smf Style) (version 1.0) - Recent Posts Forum Index (Smf Style)

    Read more about this resource...
     
    Taner likes this.
  2. BamaStangGuy

    BamaStangGuy Well-Known Member

    Seems some performance issues exists with this:

    PHP:
    # Time: 120730 10:34:19
    # User@Host: xxxx[xxxx] @ localhost []
    # Query_time: 99.313858  Lock_time: 0.000049 Rows_sent: 5  Rows_examined: 807237
    SET timestamp=1343662459;
    SELECT post.*, thread.*, user.*,^M
                            forum
    .title AS node_titleforum.node_id AS node_id^M
                FROM xf_post 
    AS post^M
                LEFT JOIN xf_thread 
    AS thread ON (thread.thread_id post.thread_id)^M
                LEFT JOIN xf_user 
    AS user ON (user.user_id post.user_id)^M
                            LEFT JOIN xf_node 
    AS forum ON (forum.node_id thread.node_id)^M
                            WHERE NOT ISNULL
    (thread.thread_id) ^M
                
    AND post.message_state 'visible'^M
                            
    AND user.is_banned 0^M
                            GROUP BY post
    .post_id^M
                ORDER BY post
    .post_date DESC^M
            LIMIT 5
    ;
     
  3. BamaStangGuy

    BamaStangGuy Well-Known Member

    Every time I enable this product it adds seconds to the page load and shows up in slow query log.....

    PHP:
    # Time: 120801 14:19:19
    # User@Host: xxxx[xxxx] @ localhost []
    # Query_time: 11.521370  Lock_time: 0.000028 Rows_sent: 5  Rows_examined: 807532
    use cruising_xen;
    SET timestamp=1343848759;
    SELECT post.*, thread.*, user.*,^M
                            forum
    .title AS node_titleforum.node_id AS node_id^M
                FROM xf_post 
    AS post^M
                LEFT JOIN xf_thread 
    AS thread ON (thread.thread_id post.thread_id)^M
                LEFT JOIN xf_user 
    AS user ON (user.user_id post.user_id)^M
                            LEFT JOIN xf_node 
    AS forum ON (forum.node_id thread.node_id)^M
                            WHERE NOT ISNULL
    (thread.thread_id) ^M
                
    AND post.message_state 'visible'^M
                            
    AND user.is_banned 0^M
                            GROUP BY post
    .post_id^M
                ORDER BY post
    .post_date DESC^M
            LIMIT 5
    ;
    PHP:
    # Time: 120801 14:20:14
    # User@Host: xxxxl[xxxx] @ localhost []
    # Query_time: 10.157922  Lock_time: 0.000024 Rows_sent: 5  Rows_examined: 807532
    SET timestamp=1343848814;
    SELECT post.*, thread.*, user.*,^M
                            forum
    .title AS node_titleforum.node_id AS node_id^M
                FROM xf_post 
    AS post^M
                LEFT JOIN xf_thread 
    AS thread ON (thread.thread_id post.thread_id)^M
                LEFT JOIN xf_user 
    AS user ON (user.user_id post.user_id)^M
                            LEFT JOIN xf_node 
    AS forum ON (forum.node_id thread.node_id)^M
                            WHERE NOT ISNULL
    (thread.thread_id) ^M
                
    AND post.message_state 'visible'^M
                            
    AND user.is_banned 0^M
                            GROUP BY post
    .post_id^M
                ORDER BY post
    .post_date DESC^M
            LIMIT 5
    ;
     
  4. BamaStangGuy

    BamaStangGuy Well-Known Member

    Running this query manually in Navicat takes 9 seconds...

    Screen Shot 2012-08-01 at 4.01.33 PM.png Screen Shot 2012-08-01 at 4.01.12 PM.png
     
  5. CritiKiL

    CritiKiL Active Member

    I have a simple request. The addon is working perfectly for me. However I AM having a 'small' width issue and I would like to tweak with it a bit. Some of the members names are fairly long so that is forcing the width of the forum to stretch the boundaries. I would like to try to make the "Recent Posts" or "Post Date" a little smaller? Here's an image:

    IMG_0898[1].PNG
     
  6. leemy

    leemy Member

    Are the performance issues being fixed in an update? Is this compatible with 1.2.x? I'll buy this instead of making it again myself. Does it work with the responsive design?
     
  7. borbole

    borbole Well-Known Member

  8. OperaManiac

    OperaManiac Well-Known Member

    Is this plugin still being actively supported? Can I get the recent posts box at the top of the forum listing? Thanks.
     
  9. borbole

    borbole Well-Known Member

    This is an outdated version. The new version of this mod can be found here:

    http://xenforo.com/community/resources/1-2x-recent-posts-forum-index-smf-style.2170/

    It is fully supported and yes, you can get the most recent posts displayed on top. I can modify it and email you the modified package.
     
    OperaManiac likes this.
  10. OperaManiac

    OperaManiac Well-Known Member

    Nice. Can you confirm that the above reports about performance issues are resolved? Thanks!
     
  11. borbole

    borbole Well-Known Member

    I couldn''t reproduce the above reported issues myself. However the query has been improved in the new version regarding the performance.
     
  12. OperaManiac

    OperaManiac Well-Known Member

    Sorry. One last question. This is static or aut0-updating. Thanks!
     
  13. borbole

    borbole Well-Known Member

    It updates any time a new post has been made but the changes are shown on page refresh. i.e. not instant auto update.
     
    OperaManiac likes this.
  14. OperaManiac

    OperaManiac Well-Known Member

    Thanks. I noticed you are looking for a buyer for all your mods. This sort of worries me. You no longer plan to develop for XenForo? I mean I do not expect lifetime of updates and support but a few months would be nice!
     
  15. borbole

    borbole Well-Known Member

    This resource has been removed and is no longer available for download.
     

Share This Page