Размышления на тему Bitrix+VDS

kpv, спасибо, я умею считать :)

Полагаю, что цЫфиря 0.0158 взялась из некой формулы, входными параметрами в которую были все те цЫферки, что распологаются ниже по списку.

Но основной момент, который меня смущает (как я уже говорил), это отсутствие реальной нагрузки на железо во время тестирования и слабая зависимоть результатов теста скорости диска от самого диска :)

Да вы правы, я думаю намного интересней былбы тест 1000 вот таких запросов -

SELECT DISTINCT BE.ID as ID,BE.NAME as NAME,BE.IBLOCK_ID as IBLOCK_ID,BE.IBLOCK_SECTION_ID as IBLOCK_SECTION_ID, FPEN0.VALUE as PROPERTY_TYPE_LAMP_VALUE, FPEN0.ID as PROPERTY_TY

PE_LAMP_ENUM_ID, FPV0.ID as PROPERTY_TYPE_LAMP_VALUE_ID, FPEN1.VALUE as PROPERTY_STYLE_VALUE, FPEN1.ID as PROPERTY_STYLE_ENUM_ID, FPV1.ID as PROPERTY_STYLE_VALUE_ID,BE.PREVIEW_PICTURE as PREVIEW_PICTURE, FPEN2.VALUE as PROPERTY_SERIES_VALUE, FPEN2.ID as PROPERTY_SERIES_ENUM_ID, FPV2.ID as PROPERTY_SERIES_VALUE_ID, FPEN3.VALUE as PROPERTY_COLOR_ARMAT_VALUE, FPEN3.ID as PROPERTY_COLOR_ARMAT_ENUM_ID, FPV3.ID as PROPERTY_COLOR_ARMAT_VALUE_ID, FPEN4.VALUE as PROPERTY_COLOR_PLAFON_VALUE, FPEN4.ID as PROPERTY_COLOR_PLAFON_ENUM_ID, FPV4.ID as PROPERTY_COLOR_PLAFON_VALUE_ID, FPEN5.VALUE as PROPERTY_NEW_VALUE, FPEN5.ID as PROPERTY_NEW_ENUM_ID, FPV5.ID as PROPERTY_NEW_VALUE_ID, FPEN6.VALUE as PROPERTY_SALE_VALUE, FPEN6.ID as PROPERTY_SALE_ENUM_ID, FPV6.ID as PROPERTY_SALE_VALUE_ID , CAT_P1.ID as CATALOG_PRICE_ID_1,  CAT_P1.CATALOG_GROUP_ID as CATALOG_GROUP_ID_1,  CAT_P1.PRICE as CATALOG_PRICE_1,  CAT_P1.CURRENCY as CATALOG_CURRENCY_1,  CAT_P1.QUANTITY_FROM as CATALOG_QUANTITY_FROM_1,  CAT_P1.QUANTITY_TO as CATALOG_QUANTITY_TO_1,  '<C1><E0><E7><EE><E2><E0>

<FF> <F6><E5><ED><E0>' as CATALOG_GROUP_NAME_1,  'Y' as CATALOG_CAN_ACCESS_1,  'Y' as CATALOG_CAN_BUY_1,  CAT_P1.EXTRA_ID as CATALOG_EXTRA_ID_1, CAT_PR.QUANTITY as CATALOG_QUANTITY,  CAT_PR.QUANTITY_TRACE as CATALOG_QUANTITY_TRACE,  CAT_PR.WEIGHT as CATALOG_WEIGHT,  CAT_VAT.RATE as CATALOG_VAT,  CAT_PR.VAT_INCLUDED as CATALOG_VAT_INCLUDED,  CAT_PR.PRICE_TYPE as CATALOG_PRICE_TYPE,  CAT_PR.RECUR_SCHEME_TYPE as CATALOG_RECUR_SCHEME_TYPE,  CAT_PR.RECUR_SCHEME_LENGTH as CATALOG_RECUR_SCHEME_LENGTH,  CAT_PR.TRIAL_PRICE_ID as CATALOG_TRIAL_PRICE_ID,  CAT_PR.WITHOUT_ORDER as CATALOG_WITHOUT_ORDER,  CAT_PR.SELECT_BEST_PRICE as CATALOG_SELECT_BEST_PRICE

FROM b_iblock B

INNER JOIN b_lang L ON B.LID=L.LID

INNER JOIN b_iblock_element BE ON BE.IBLOCK_ID = B.ID

LEFT JOIN b_iblock_property FP0 ON FP0.IBLOCK_ID = B.ID AND  FP0.CODE='TYPE_LAMP'

INNER JOIN b_iblock_property FP1 ON FP1.IBLOCK_ID = B.ID AND  FP1.CODE='STYLE'

INNER JOIN b_iblock_property FP2 ON FP2.IBLOCK_ID = B.ID AND  FP2.CODE='SERIES'

LEFT JOIN b_iblock_property FP3 ON FP3.IBLOCK_ID = B.ID AND  FP3.CODE='COLOR_ARMAT'

LEFT JOIN b_iblock_property FP4 ON FP4.IBLOCK_ID = B.ID AND  FP4.CODE='COLOR_PLAFON'

LEFT JOIN b_iblock_property FP5 ON FP5.IBLOCK_ID = B.ID AND  FP5.CODE='NEW'

LEFT JOIN b_iblock_property FP6 ON FP6.IBLOCK_ID = B.ID AND  FP6.CODE='SALE'

/*... тут еще 14 джоинов ...*/

INNER JOIN (

	SELECT DISTINCT BSE.IBLOCK_ELEMENT_ID

	FROM b_iblock_section_element BSE



	INNER JOIN b_iblock_section BS ON BSE.IBLOCK_SECTION_ID = BS.ID



	WHERE (((BS.ID = 25)))

	) BES ON BES.IBLOCK_ELEMENT_ID = BE.ID

LEFT JOIN b_catalog_price CAT_P1 ON (CAT_P1.PRODUCT_ID = BE.ID AND CAT_P1.CATALOG_GROUP_ID = 1)

LEFT JOIN b_catalog_product CAT_PR ON (CAT_PR.ID = BE.ID)

LEFT JOIN b_catalog_iblock CAT_IB ON ((CAT_PR.VAT_ID IS NULL OR CAT_PR.VAT_ID = 0) AND CAT_IB.IBLOCK_ID = BE.IBLOCK_ID)

LEFT JOIN b_catalog_vat CAT_VAT ON (CAT_VAT.ID = IF((CAT_PR.VAT_ID IS NULL OR CAT_PR.VAT_ID = 0), CAT_IB.VAT_ID, CAT_PR.VAT_ID))

WHERE 1=1

AND ( 13:19 

((((BE.IBLOCK_ID = '3'))))

	AND ((((BE.ACTIVE='Y'))))

	AND (

		(

		((((CAT_P1.PRICE >= '386'))))

		)

		AND (

		((((CAT_P1.PRICE <= '4166'))))

		)

	)

	AND ((((CAT_PR.QUANTITY > '0'))))

	AND ((((FPEN1.VALUE LIKE '<CA><EB><E0><F1><F1><E8><F7><E5><F1><EA><E8><E9>'))))

	AND ((((FPEN2.VALUE LIKE 'Davoli'))))

)

AND (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL)));

или таких -

SELECT DISTINCT BE.ID as ID,BE.NAME as NAME,BE.CODE as CODE,BE.IBLOCK_ID as

IBLOCK_ID,BE.IBLOCK_SECTION_ID as IBLOCK_SECTION_ID,B.DETAIL_PAGE_URL as

DETAIL_PAGE_URL,BE.DETAIL_TEXT as DETAIL_TEXT,BE.DETAIL_TEXT_TYPE as

DETAIL_TEXT_TYPE,BE.DETAIL_PICTURE as DETAIL_PICTURE,BE.PREVIEW_TEXT as

PREVIEW_TEXT,BE.PREVIEW_TEXT_TYPE as PREVIEW_TEXT_TYPE,BE.PREVIEW_PICTURE as

PREVIEW_PICTURE,L.DIR as LANG_DIR,BE.XML_ID as EXTERNAL_ID,B.IBLOCK_TYPE_ID as

IBLOCK_TYPE_ID,B.CODE as IBLOCK_CODE,B.XML_ID as IBLOCK_EXTERNAL_ID FROM

b_iblock B INNER JOIN b_lang L ON B.LID=L.LID INNER JOIN b_iblock_element BE

ON BE.IBLOCK_ID = B.ID INNER JOIN b_iblock_section_element BSE ON

BSE.IBLOCK_ELEMENT_ID = BE.ID INNER JOIN b_iblock_section BSubS ON

BSE.IBLOCK_SECTION_ID = BSubS.ID INNER JOIN b_iblock_section BS ON

(BSubS.IBLOCK_ID=BS.IBLOCK_ID AND BSubS.LEFT_MARGIN>=BS.LEFT_MARGIN AND

BSubS.RIGHT_MARGIN<=BS.RIGHT_MARGIN) INNER JOIN b_iblock_property FP1 ON

FP1.IBLOCK_ID=B.ID AND FP1.CODE='code2' INNER JOIN b_iblock_element_property

FPV1 ON FP1.ID=FPV1.IBLOCK_PROPERTY_ID AND FPV1.IBLOCK_ELEMENT_ID=BE.ID INNER

JOIN b_iblock_property FP2 ON FP2.IBLOCK_ID=B.ID AND FP2.CODE='code3' INNER

JOIN b_iblock_element_property FPV2 ON FP2.ID=FPV2.IBLOCK_PROPERTY_ID AND

FPV2.IBLOCK_ELEMENT_ID=BE.ID INNER JOIN b_iblock_property FP3 ON

FP3.IBLOCK_ID=B.ID AND FP3.CODE='code4' INNER JOIN b_iblock_element_property

FPV3 ON FP3.ID=FPV3.IBLOCK_PROPERTY_ID AND FPV3.IBLOCK_ELEMENT_ID=BE.ID INNER

JOIN b_iblock_property FP4 ON FP4.IBLOCK_ID=B.ID AND FP4.CODE='code5' INNER

JOIN b_iblock_element_property FPV4 ON FP4.ID=FPV4.IBLOCK_PROPERTY_ID AND

FPV4.IBLOCK_ELEMENT_ID=BE.ID INNER JOIN b_iblock_property FP5 ON

FP5.IBLOCK_ID=B.ID AND FP5.CODE='code7' INNER JOIN b_iblock_element_property

FPV5 ON FP5.ID=FPV5.IBLOCK_PROPERTY_ID AND FPV5.IBLOCK_ELEMENT_ID=BE.ID INNER

JOIN b_iblock_property FP6 ON FP6.IBLOCK_ID=B.ID AND FP6.CODE='code9' INNER

JOIN b_iblock_element_property FPV6 ON FP6.ID=FPV6.IBLOCK_PROPERTY_ID AND

FPV6.IBLOCK_ELEMENT_ID=BE.ID INNER JOIN b_iblock_property FP7 ON

FP7.IBLOCK_ID=B.ID AND FP7.CODE='code12' INNER JOIN b_iblock_element_property

FPV7 ON FP7.ID=FPV7.IBLOCK_PROPERTY_ID AND FPV7.IBLOCK_ELEMENT_ID=BE.ID INNER

JOIN b_iblock_property FP8 ON FP8.IBLOCK_ID=B.ID AND FP8.CODE='code15' INNER

JOIN b_iblock_element_property FPV8 ON FP8.ID=FPV8.IBLOCK_PROPERTY_ID AND

FPV8.IBLOCK_ELEMENT_ID=BE.ID INNER JOIN b_iblock_property FP9 ON

FP9.IBLOCK_ID=B.ID AND FP9.CODE='code16' INNER JOIN b_iblock_element_property

FPV9 ON FP9.ID=FPV9.IBLOCK_PROPERTY_ID AND FPV9.IBLOCK_ELEMENT_ID=BE.ID INNER

JOIN b_iblock_property FP10 ON FP10.IBLOCK_ID=B.ID AND FP10.CODE='code18'

INNER JOIN b_iblock_element_property FPV10 ON FP10.ID=FPV10.IBLOCK_PROPERTY_ID

AND FPV10.IBLOCK_ELEMENT_ID=BE.ID INNER JOIN b_iblock_property FP11 ON

FP11.IBLOCK_ID=B.ID AND FP11.CODE='code23' INNER JOIN

b_iblock_element_property FPV11 ON FP11.ID=FPV11.IBLOCK_PROPERTY_ID AND

FPV11.IBLOCK_ELEMENT_ID=BE.ID INNER JOIN b_iblock_property FP12 ON

FP12.IBLOCK_ID=B.ID AND FP12.CODE='code26' INNER JOIN

b_iblock_element_property FPV12 ON FP12.ID=FPV12.IBLOCK_PROPERTY_ID AND

FPV12.IBLOCK_ELEMENT_ID=BE.ID INNER JOIN b_iblock_property FP13 ON

FP13.IBLOCK_ID=B.ID AND FP13.CODE='code27' INNER JOIN

b_iblock_element_property FPV13 ON FP13.ID=FPV13.IBLOCK_PROPERTY_ID AND

FPV13.IBLOCK_ELEMENT_ID=BE.ID INNER JOIN b_iblock_property FP14 ON

FP14.IBLOCK_ID=B.ID AND FP14.CODE='code32' INNER JOIN

b_iblock_element_property FPV14 ON FP14.ID=FPV14.IBLOCK_PROPERTY_ID AND

FPV14.IBLOCK_ELEMENT_ID=BE.ID INNER JOIN b_iblock_property FP15 ON

FP15.IBLOCK_ID=B.ID AND FP15.CODE='code34' INNER JOIN

b_iblock_element_property FPV15 ON FP15.ID=FPV15.IBLOCK_PROPERTY_ID AND

FPV15.IBLOCK_ELEMENT_ID=BE.ID WHERE 1=1 AND B.ID IN (0,42) AND (

(BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL) ) AND ((((

(upper(BE.NAME) like upper('%acer7730G%') and BE.NAME is not null) )))) AND

(((( (upper(FPV1.VALUE) like upper('%Intel%') and FPV1.VALUE is not null) AND

(upper(FPV1.VALUE) like upper('%Core2Duo%') and FPV1.VALUE is not null) AND

(upper(FPV1.VALUE) like upper('%T5850%') and FPV1.VALUE is not null) AND

(upper(FPV1.VALUE) like upper('%2.16GHz%') and FPV1.VALUE is not null) ))))

AND (((( (upper(FPV2.VALUE) like upper('%4096Mb%') and FPV2.VALUE is not null)

AND ( (upper(FPV2.VALUE) like upper('%4Gb%') and FPV2.VALUE is not null) ) AND

(upper(FPV2.VALUE) like upper('%DDRII%') and FPV2.VALUE is not null) )))) AND

(((( (upper(FPV3.VALUE) like upper('%2x320Gb%') and FPV3.VALUE is not null)

AND (upper(FPV3.VALUE) like upper('%5400rpm%') and FPV3.VALUE is not null) AND

(upper(FPV3.VALUE) like upper('%SATA%') and FPV3.VALUE is not null) )))) AND

(((( (upper(FPV4.VALUE) like upper('%17%') and FPV4.VALUE is not null) ))))

AND (((( (upper(FPV5.VALUE) like upper('%??%') and FPV5.VALUE is not null)

)))) AND (((( (upper(FPV6.VALUE) like upper('%64Mb%') and FPV6.VALUE is not

null) AND ( (upper(FPV6.VALUE) like upper('%??%') and FPV6.VALUE is not null)

AND (upper(FPV6.VALUE) like upper('%958Mb%') and FPV6.VALUE is not null) )))))

AND (((( (upper(FPV7.VALUE) like upper('%??%') and FPV7.VALUE is not null)

)))) AND (((( (upper(FPV8.VALUE) like upper('%Bluetooth%') and FPV8.VALUE is

not null) AND (upper(FPV8.VALUE) like upper('%V2.0%') and FPV8.VALUE is not

null) AND (upper(FPV8.VALUE) like upper('%EDR%') and FPV8.VALUE is not null)

)))) AND (((( (upper(FPV9.VALUE) like upper('%4%') and FPV9.VALUE is not null)

)))) AND (((( (upper(FPV10.VALUE) like upper('%??%') and FPV10.VALUE is not

null) )))) AND (((( (upper(FPV11.VALUE) like upper('%??%') and FPV11.VALUE is

not null) )))) AND (((( (upper(FPV12.VALUE) like upper('%??%') and FPV12.VALUE

is not null) )))) AND (((( (upper(FPV13.VALUE) like upper('%WebCam%') and

FPV13.VALUE is not null) AND (upper(FPV13.VALUE) like upper('%1,3Mpx%') and

FPV13.VALUE is not null) )))) AND (((( (upper(FPV14.VALUE) like

upper('%?????%') and FPV14.VALUE is not null) )))) AND ((((

(upper(FPV15.VALUE) like upper('%12%') and FPV15.VALUE is not null) AND

(upper(FPV15.VALUE) like upper('%???????%') and FPV15.VALUE is not null) ))))

AND ((((BE.IBLOCK_ID = '42')))) AND (((BE.ACTIVE_TO >= now() OR BE.ACTIVE_TO

IS NULL) AND (BE.ACTIVE_FROM <= now() OR BE.ACTIVE_FROM IS NULL))) AND

((((BE.ACTIVE='Y')))) AND ((BS.ID = 224)) ORDER BY BE.SORT asc , BE.ID desc

LIMIT 0, 30

В реальности битрикс жесток и беспощаден, куда там 1000 инсертам 🤪

P.S. Битрикс (http://dev.1c-bitrix.ru/community/forums/forum6/topic14898/)

Во, новый рекорд :) Производительность конфигурации на 29.04.2013 17:52:48 составляет 67.52

ftp://vds4you.ru/bitrix2.png

Причем сейчас этот физический сервак нагружен и на нем куча народа...

В топку тесты битрикса!

SELECT DISTINCT BE.ID as ID,BE.NAME as NAME,BE.CODE as CODE,BE.IBLOCK_ID as

IBLOCK_ID,BE.IBLOCK_SECTION_ID as IBLOCK_SECTION_ID,B.DETAIL_PAGE_URL as

DETAIL_PAGE_URL,BE.DETAIL_TEXT as DETAIL_TEXT,BE.DETAIL_TEXT_TYPE as

DETAIL_TEXT_TYPE,BE.DETAIL_PICTURE as DETAIL_PICTURE,BE.PREVIEW_TEXT as

PREVIEW_TEXT,BE.PREVIEW_TEXT_TYPE as PREVIEW_TEXT_TYPE,BE.PREVIEW_PICTURE as

PREVIEW_PICTURE,L.DIR as LANG_DIR,BE.XML_ID as EXTERNAL_ID,B.IBLOCK_TYPE_ID as

IBLOCK_TYPE_ID,B.CODE as IBLOCK_CODE,B.XML_ID as IBLOCK_EXTERNAL_ID FROM

b_iblock B INNER JOIN b_lang L ON B.LID=L.LID INNER JOIN b_iblock_element BE

ON BE.IBLOCK_ID = B.ID INNER JOIN b_iblock_section_element BSE ON

BSE.IBLOCK_ELEMENT_ID = BE.ID INNER JOIN b_iblock_section BSubS ON

BSE.IBLOCK_SECTION_ID = BSubS.ID INNER JOIN b_iblock_section BS ON

(BSubS.IBLOCK_ID=BS.IBLOCK_ID AND BSubS.LEFT_MARGIN>=BS.LEFT_MARGIN AND

BSubS.RIGHT_MARGIN<=BS.RIGHT_MARGIN) INNER JOIN b_iblock_property FP1 ON

FP1.IBLOCK_ID=B.ID AND FP1.CODE='code2' INNER JOIN b_iblock_element_property

FPV1 ON FP1.ID=FPV1.IBLOCK_PROPERTY_ID AND FPV1.IBLOCK_ELEMENT_ID=BE.ID INNER

JOIN b_iblock_property FP2 ON FP2.IBLOCK_ID=B.ID AND FP2.CODE='code3' INNER

JOIN b_iblock_element_property FPV2 ON FP2.ID=FPV2.IBLOCK_PROPERTY_ID AND

FPV2.IBLOCK_ELEMENT_ID=BE.ID INNER JOIN b_iblock_property FP3 ON

FP3.IBLOCK_ID=B.ID AND FP3.CODE='code4' INNER JOIN b_iblock_element_property

FPV3 ON FP3.ID=FPV3.IBLOCK_PROPERTY_ID AND FPV3.IBLOCK_ELEMENT_ID=BE.ID INNER

JOIN b_iblock_property FP4 ON FP4.IBLOCK_ID=B.ID AND FP4.CODE='code5' INNER

JOIN b_iblock_element_property FPV4 ON FP4.ID=FPV4.IBLOCK_PROPERTY_ID AND

FPV4.IBLOCK_ELEMENT_ID=BE.ID INNER JOIN b_iblock_property FP5 ON

FP5.IBLOCK_ID=B.ID AND FP5.CODE='code7' INNER JOIN b_iblock_element_property

FPV5 ON FP5.ID=FPV5.IBLOCK_PROPERTY_ID AND FPV5.IBLOCK_ELEMENT_ID=BE.ID INNER

JOIN b_iblock_property FP6 ON FP6.IBLOCK_ID=B.ID AND FP6.CODE='code9' INNER

JOIN b_iblock_element_property FPV6 ON FP6.ID=FPV6.IBLOCK_PROPERTY_ID AND

FPV6.IBLOCK_ELEMENT_ID=BE.ID INNER JOIN b_iblock_property FP7 ON

FP7.IBLOCK_ID=B.ID AND FP7.CODE='code12' INNER JOIN b_iblock_element_property

FPV7 ON FP7.ID=FPV7.IBLOCK_PROPERTY_ID AND FPV7.IBLOCK_ELEMENT_ID=BE.ID INNER

JOIN b_iblock_property FP8 ON FP8.IBLOCK_ID=B.ID AND FP8.CODE='code15' INNER

JOIN b_iblock_element_property FPV8 ON FP8.ID=FPV8.IBLOCK_PROPERTY_ID AND

FPV8.IBLOCK_ELEMENT_ID=BE.ID INNER JOIN b_iblock_property FP9 ON

FP9.IBLOCK_ID=B.ID AND FP9.CODE='code16' INNER JOIN b_iblock_element_property

FPV9 ON FP9.ID=FPV9.IBLOCK_PROPERTY_ID AND FPV9.IBLOCK_ELEMENT_ID=BE.ID INNER

JOIN b_iblock_property FP10 ON FP10.IBLOCK_ID=B.ID AND FP10.CODE='code18'

INNER JOIN b_iblock_element_property FPV10 ON FP10.ID=FPV10.IBLOCK_PROPERTY_ID

AND FPV10.IBLOCK_ELEMENT_ID=BE.ID INNER JOIN b_iblock_property FP11 ON

FP11.IBLOCK_ID=B.ID AND FP11.CODE='code23' INNER JOIN

b_iblock_element_property FPV11 ON FP11.ID=FPV11.IBLOCK_PROPERTY_ID AND

FPV11.IBLOCK_ELEMENT_ID=BE.ID INNER JOIN b_iblock_property FP12 ON

FP12.IBLOCK_ID=B.ID AND FP12.CODE='code26' INNER JOIN

b_iblock_element_property FPV12 ON FP12.ID=FPV12.IBLOCK_PROPERTY_ID AND

FPV12.IBLOCK_ELEMENT_ID=BE.ID INNER JOIN b_iblock_property FP13 ON

FP13.IBLOCK_ID=B.ID AND FP13.CODE='code27' INNER JOIN

b_iblock_element_property FPV13 ON FP13.ID=FPV13.IBLOCK_PROPERTY_ID AND

FPV13.IBLOCK_ELEMENT_ID=BE.ID INNER JOIN b_iblock_property FP14 ON

FP14.IBLOCK_ID=B.ID AND FP14.CODE='code32' INNER JOIN

b_iblock_element_property FPV14 ON FP14.ID=FPV14.IBLOCK_PROPERTY_ID AND

FPV14.IBLOCK_ELEMENT_ID=BE.ID INNER JOIN b_iblock_property FP15 ON

FP15.IBLOCK_ID=B.ID AND FP15.CODE='code34' INNER JOIN

b_iblock_element_property FPV15 ON FP15.ID=FPV15.IBLOCK_PROPERTY_ID AND

FPV15.IBLOCK_ELEMENT_ID=BE.ID WHERE 1=1 AND B.ID IN (0,42) AND (

(BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL) ) AND ((((

(upper(BE.NAME) like upper('%acer7730G%') and BE.NAME is not null) )))) AND

(((( (upper(FPV1.VALUE) like upper('%Intel%') and FPV1.VALUE is not null) AND

(upper(FPV1.VALUE) like upper('%Core2Duo%') and FPV1.VALUE is not null) AND

(upper(FPV1.VALUE) like upper('%T5850%') and FPV1.VALUE is not null) AND

(upper(FPV1.VALUE) like upper('%2.16GHz%') and FPV1.VALUE is not null) ))))

AND (((( (upper(FPV2.VALUE) like upper('%4096Mb%') and FPV2.VALUE is not null)

AND ( (upper(FPV2.VALUE) like upper('%4Gb%') and FPV2.VALUE is not null) ) AND

(upper(FPV2.VALUE) like upper('%DDRII%') and FPV2.VALUE is not null) )))) AND

(((( (upper(FPV3.VALUE) like upper('%2x320Gb%') and FPV3.VALUE is not null)

AND (upper(FPV3.VALUE) like upper('%5400rpm%') and FPV3.VALUE is not null) AND

(upper(FPV3.VALUE) like upper('%SATA%') and FPV3.VALUE is not null) )))) AND

(((( (upper(FPV4.VALUE) like upper('%17%') and FPV4.VALUE is not null) ))))

AND (((( (upper(FPV5.VALUE) like upper('%??%') and FPV5.VALUE is not null)

)))) AND (((( (upper(FPV6.VALUE) like upper('%64Mb%') and FPV6.VALUE is not

null) AND ( (upper(FPV6.VALUE) like upper('%??%') and FPV6.VALUE is not null)

AND (upper(FPV6.VALUE) like upper('%958Mb%') and FPV6.VALUE is not null) )))))

AND (((( (upper(FPV7.VALUE) like upper('%??%') and FPV7.VALUE is not null)

)))) AND (((( (upper(FPV8.VALUE) like upper('%Bluetooth%') and FPV8.VALUE is

not null) AND (upper(FPV8.VALUE) like upper('%V2.0%') and FPV8.VALUE is not

null) AND (upper(FPV8.VALUE) like upper('%EDR%') and FPV8.VALUE is not null)

)))) AND (((( (upper(FPV9.VALUE) like upper('%4%') and FPV9.VALUE is not null)

)))) AND (((( (upper(FPV10.VALUE) like upper('%??%') and FPV10.VALUE is not

null) )))) AND (((( (upper(FPV11.VALUE) like upper('%??%') and FPV11.VALUE is

not null) )))) AND (((( (upper(FPV12.VALUE) like upper('%??%') and FPV12.VALUE

is not null) )))) AND (((( (upper(FPV13.VALUE) like upper('%WebCam%') and

FPV13.VALUE is not null) AND (upper(FPV13.VALUE) like upper('%1,3Mpx%') and

FPV13.VALUE is not null) )))) AND (((( (upper(FPV14.VALUE) like

upper('%?????%') and FPV14.VALUE is not null) )))) AND ((((

(upper(FPV15.VALUE) like upper('%12%') and FPV15.VALUE is not null) AND

(upper(FPV15.VALUE) like upper('%???????%') and FPV15.VALUE is not null) ))))

AND ((((BE.IBLOCK_ID = '42')))) AND (((BE.ACTIVE_TO >= now() OR BE.ACTIVE_TO

IS NULL) AND (BE.ACTIVE_FROM <= now() OR BE.ACTIVE_FROM IS NULL))) AND

((((BE.ACTIVE='Y')))) AND ((BS.ID = 224)) ORDER BY BE.SORT asc , BE.ID desc

LIMIT 0, 30

😮😮

Не пора ли им на nosql перебраться с такими запросами.

Не ленитесь посмотреть в исходники битрикса, чтобы не строить неправильных предположений.

kpv лениво :) Да и не моя это сфера, долго вникать придется.

Как тут мне в ЛС объяснили сведующие товарищи, тест производится на базе некого скрипта, который закачивается извне. И всё это не имеет отношения к циферкам в табличке. Короче, это даже круче сферического коня.

балл равен числу запросов к некой дефолтной странице, которые могут выполниться на сервере за 1 секунду. все остальные циферки приведены для справки, чтобы можно было попытаться понять, где узкое место.

SELECT DISTINCT BE.ID as ID,BE.NAME as NAME,BE.IBLOCK_ID as

...

...

	AND ((((CAT_PR.QUANTITY > '0'))))

	AND ((((FPEN1.VALUE LIKE '<CA><EB><E0><F1><F1><E8><F7><E5><F1><EA><E8><E9>'))))

	AND ((((FPEN2.VALUE LIKE 'Davoli'))))

)

AND (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL)));

Угу, заодно процессор потестируют, память и северный мост )))