مقایسه سرعت utf8_percian_ci و utf8mb4_unicode_ci

[Y.P.Y]

مقایسه پایه ای سرعت بین utf8_persian_ci و utf8mb4_unicode_ci در MySQL:
(به ترتیب محدود ترین و گسترده ترین)

سریعتر با utf8_persian_ci
/* Affected rows: 0 Found rows: 0 Warnings: 0 Duration for 1 query: 0.031 sec. */
/* Affected rows: 0 Found rows: 0 Warnings: 0 Duration for 1 query: 0.031 sec. */
/* Affected rows: 0 Found rows: 0 Warnings: 0 Duration for 1 query: 0.031 sec. */
/* Affected rows: 0 Found rows: 0 Warnings: 0 Duration for 1 query: 0.015 sec. */
/* Affected rows: 0 Found rows: 0 Warnings: 0 Duration for 1 query: 0.015 sec. */
/* Affected rows: 0 Found rows: 0 Warnings: 0 Duration for 1 query: 0.031 sec. */

کندتر با utf8mb4_unicode_ci
/* Affected rows: 0 Found rows: 0 Warnings: 0 Duration for 1 query: 0.266 sec. */
/* Affected rows: 0 Found rows: 0 Warnings: 0 Duration for 1 query: 0.093 sec. */
/* Affected rows: 0 Found rows: 0 Warnings: 0 Duration for 1 query: 0.109 sec. */
/* Affected rows: 0 Found rows: 0 Warnings: 0 Duration for 1 query: 0.110 sec. */
/* Affected rows: 0 Found rows: 0 Warnings: 0 Duration for 1 query: 0.109 sec. */
/* Affected rows: 0 Found rows: 0 Warnings: 0 Duration for 1 query: 0.109 sec. */

بستر MySQL 5.6.26 سیستم عامل 64bit سخت افزار x64 بدون ایندکس موتور InnoDb و کوئری

کد:

SELECT * FROM test WHERE Description = 'test' COLLATE XYZ;

و

کد:

SET character_set_client = XYZ;
SET character_set_results = XYZ;
SET character_set_connection = XYZ;