Bug Cannot Reproduce Perfomance problem in Article Layout

[phpclub]

Have perfomance problem in Article Layout

Page Time: 13.7403s
Memory: 7.4804 MB (Peak: 8.5736 MB)
Queries (14, time: 0.0028s, 0.0%)

In List Layout - all OK

Page Time: 0.0880s
Memory: 6.1429 MB (Peak: 6.6682 MB)
Queries (12, time: 0.0035s, 4.0%)

Maybe problem in parse BB code ?

IMHO: Need add index
ALTER TABLE `xf_user` ADD INDEX `document_count` ( `xfa_document_count` )

Spoiler: sql

SELECT user.*, user_profile.*
FROM xf_user AS user
LEFT JOIN xf_user_profile AS user_profile ON
(user.user_id = user_profile.user_id)
WHERE user.xfa_document_count > 0
ORDER BY user.xfa_document_count DESC
LIMIT 5
Run Time: 0.000152
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE user ALL 21369 Using where; Using filesort
SIMPLE user_profile eq_ref PRIMARY PRIMARY 4 user.user_id 1

 

[phpclub]

Maybe problem in huge data in SELECT section.*

SELECT section.*,document.*,section.warning_id AS warning_id,section.warning_message AS warning_message,
            deletion_log.delete_date, deletion_log.delete_reason,
                        deletion_log.delete_user_id, deletion_log.delete_username
                            
                FROM xfa_document_section AS section
                LEFT JOIN xfa_document AS document ON (document.document_id = section.document_id)
                LEFT JOIN xf_deletion_log AS deletion_log ON
                            (deletion_log.content_type = 'document_section' AND deletion_log.content_id = section.document_section_id)
                
    WHERE (section.document_id IN (12, 9, 8, 7, 6, 5, 4, 3, 2, 1)) AND (section.section_state = 'visible')
    ORDER BY section.lft

 

[phpclub]

Maybe problem in huge data in SELECT section.*

SELECT section.*,document.*,section.warning_id AS warning_id,section.warning_message AS warning_message,
            deletion_log.delete_date, deletion_log.delete_reason,
                        deletion_log.delete_user_id, deletion_log.delete_username
                            
                FROM xfa_document_section AS section
                LEFT JOIN xfa_document AS document ON (document.document_id = section.document_id)
                LEFT JOIN xf_deletion_log AS deletion_log ON
                            (deletion_log.content_type = 'document_section' AND deletion_log.content_id = section.document_section_id)
                
    WHERE (section.document_id IN (12, 9, 8, 7, 6, 5, 4, 3, 2, 1)) AND (section.section_state = 'visible')
    ORDER BY section.lft

 

[Clement]

Hello,

You already reported that issue some time ago here:
http://xen-factory.com/index.php?threads/errors-in-log-open-index-documents-too-slow.1352/

Which I marked as Not a bug by mistake.

As of now I recommend you don't use the article layout if your server can't handle it, will check if there is something I can do in the next update.

Clément