Bug Slow query.

[kick]

SELECT xf_dbtech_donate_drive., xf_dbtech_donate_currency_PrimaryCurrency_1., xf_dbtech_donate_donation_LastDonation_2.*
FROM xf_dbtech_donate_drive
LEFT JOIN xf_dbtech_donate_currency AS xf_dbtech_donate_currency_PrimaryCurrency_1 ON (xf_dbtech_donate_currency_PrimaryCurrency_1.primary_currency = 1)
LEFT JOIN xf_dbtech_donate_donation AS xf_dbtech_donate_donation_LastDonation_2 ON (xf_dbtech_donate_donation_LastDonation_2.donation_id = xf_dbtech_donate_drive.last_donation_id)
Run Time: 0.000241

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_dbtech_donate_drive	ALL					1
SIMPLE	xf_dbtech_donate_currency_PrimaryCurrency_1	ALL					6	Using where; Using join buffer (Block Nested Loop)
SIMPLE	xf_dbtech_donate_donation_LastDonation_2	eq_ref	PRIMARY	PRIMARY	4	xf_dbtech_donate_drive.last_donation_id	1

ELECT xf_dbtech_donate_drive., xf_dbtech_donate_currency_PrimaryCurrency_1., xf_dbtech_donate_donation_LastDonation_2.*
FROM xf_dbtech_donate_drive
LEFT JOIN xf_dbtech_donate_currency AS xf_dbtech_donate_currency_PrimaryCurrency_1 ON (xf_dbtech_donate_currency_PrimaryCurrency_1.primary_currency = 1)
LEFT JOIN xf_dbtech_donate_donation AS xf_dbtech_donate_donation_LastDonation_2 ON (xf_dbtech_donate_donation_LastDonation_2.donation_id = xf_dbtech_donate_drive.last_donation_id)
Run Time: 0.000209

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_dbtech_donate_drive	ALL					1
SIMPLE	xf_dbtech_donate_currency_PrimaryCurrency_1	ALL					6	Using where; Using join buffer (Block Nested Loop)
SIMPLE	xf_dbtech_donate_donation_LastDonation_2	eq_ref	PRIMARY	PRIMARY	4	xf_dbtech_donate_drive.last_donation_id	1

SELECT xf_dbtech_donate_drive., xf_dbtech_donate_currency_PrimaryCurrency_1., xf_dbtech_donate_donation_LastDonation_2., xf_permission_cache_content_Permissions_3.
FROM xf_dbtech_donate_drive
LEFT JOIN xf_dbtech_donate_currency AS xf_dbtech_donate_currency_PrimaryCurrency_1 ON (xf_dbtech_donate_currency_PrimaryCurrency_1.primary_currency = 1)
LEFT JOIN xf_dbtech_donate_donation AS xf_dbtech_donate_donation_LastDonation_2 ON (xf_dbtech_donate_donation_LastDonation_2.donation_id = xf_dbtech_donate_drive.last_donation_id)
LEFT JOIN xf_permission_cache_content AS xf_permission_cache_content_Permissions_3 ON (xf_permission_cache_content_Permissions_3.content_type = 'dbtech_donate_drive' AND xf_permission_cache_content_Permissions_3.content_id = xf_dbtech_donate_drive.drive_id AND xf_permission_cache_content_Permissions_3.permission_combination_id = '367')
Run Time: 0.000362

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_dbtech_donate_drive	ALL					1
SIMPLE	xf_dbtech_donate_currency_PrimaryCurrency_1	ALL					6	Using where; Using join buffer (Block Nested Loop)
SIMPLE	xf_dbtech_donate_donation_LastDonation_2	eq_ref	PRIMARY	PRIMARY	4	xf_dbtech_donate_drive.last_donation_id	1
SIMPLE	xf_permission_cache_content_Permissions_3	eq_ref	PRIMARY	PRIMARY	35	const,const,xf_dbtech_donate_drive.drive_id	1	Using where

In addition to the fact that the widget creates 3 requests with 2 widgets, so they cause just such a problem.

 

[Fillip H.]

Could you please explain why you consider queries that take 0.0002 and 0.0003 seconds to be slow?

That is literally the opposite of a slow query.

 

[DragonByte Technologies]

Hello @kick,

We hope your ticket regarding DragonByte Donate has been addressed to your satisfaction. This ticket has now been scheduled to be closed.

If your ticket has not been resolved, you can reply to this thread at any point in the next 7 days in order to reopen the ticket, afterwards this thread will be closed.

Please do not reply to this thread if your ticket has been resolved.

Thank you.


- DragonByte Technologies, Ltd.

 

[DragonByte Technologies]

Hello @kick,

As we have not heard back from you, your ticket regarding DragonByte Donate has now been closed.

If your ticket has not been resolved, please feel free to start a new support ticket and link back to this ticket.

If you have time, please leave a review on XenForo.com's Resource Manager.

Thank you.


- DragonByte Technologies, Ltd.