مقایسه پایه ای سرعت بین 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 و کوئری
و
(به ترتیب محدود ترین و گسترده ترین)
سریعتر با 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. */

کد:
SELECT * FROM test WHERE Description = 'test' COLLATE XYZ;
کد:
SET character_set_client = XYZ;
SET character_set_results = XYZ;
SET character_set_connection = XYZ;