Ðåêëàìà
Çäðàâñòâóéòå! Íà ñàéòå www.rfs-shop.com âîçíèêëà ïðîáëåìà ñ ÁÄ òåõíè÷åñêîé ïîääåðæêå ñêàçàëè, ÷òî:Íà áàçó ó âàñ êîíå÷íî î÷åíü ñåðüåçíàÿ íàãðóçêà, êàæäûé çàïðîñ çàãðóæàåò ÿäðî íà 100%. ß áû ðàññìîòðåë âîçìîæíîñòü îïòèìèçàöèè çàïðîñîâ, ò.ê. ñî ñòîðîíû ñåðâåðà òóò ìàëî ÷òî ìîæíî ñäåëàòü.Òàêæå íàáëþäàåòñÿ íàãðóçêà íà ÁÄ : | 888024 | u2398379_default | localhost:37443 | u2398379_rfs | Query | 3 | Sending data | SELECT DISTINCT BE.ID as ID,BE.NAME as NAME,BE.CODE as CODE,DATE_FORMAT(BE.DATE_CREATE, '%d.%m.%Y %H || 888026 | u2398379_default | localhost:37448 | u2398379_rfs | Query | 2 | Sending data | SELECT COUNT(DISTINCT BE.ID) as C FROM b_iblock BINNER JOIN b_lang L ON B.LID=L.LIDINNER || 888027 | u2398379_default | localhost:37449 | u2398379_rfs | Query | 2 | Sending data | SELECT COUNT(DISTINCT BE.ID) as C FROM b_iblock BINNER JOIN b_lang L ON B.LID=L.LIDINNER || 888028 | u2398379_default | localhost:37451 | u2398379_rfs | Query | 1 | Sending data | SELECT BE.ID as ID,BE.IBLOCK_ID as IBLOCK_...
Äðóãèå îòêðûòûå çàäàíèÿ:
Áþäæåò: 35 000 ð. Îïèñàíèå:  èíòåðíåò-ìàãàçèí òîâàðîâ äëÿ àêòèâíîãî îáðàçà æèçíè òðåáóåòñÿ ÷àò-ìåíåäæåð äëÿ îáùåíèÿ ñ êëèåíòàìè è ïîääåðæêè çàêàçîâ. Ðàáîòà ïîëíîñòüþ îíëàéí, áåç…
Áþäæåò: 13 500 ð. Â êîìàíäó òðåáóåòñÿ ñïåöèàëèñò äëÿ ðàññûëêè ñîîáùåíèé â ìåññåíäæåðàõ. Êîìïàíèÿ ïðåäîñòàâëÿåò òåêñòû, ñïèñêè è ïðàâèëà îôîðìëåíèÿ. ×òî íóæíî äåëàòü: — Îòïðàâëÿòü…
Áþäæåò: 2 000 ð. Òðåáóåòñÿ íàñòðîèòü ïðîñòîé Telegram-áîò äëÿ Telegram-êàíàëà. Áîò äîëæåí ïîçâîëÿòü ïîëüçîâàòåëÿì îòïðàâëÿòü ñîáûòèÿ è âîçìîæíîñòè äëÿ ðàññìîòðåíèÿ ðåäàêöèåé: ÷åð…
ïîèñê çàäàíèé
Îïòèìèçàöèÿ çàïðîñîâ (âûáîðêè) ê áàçå äàííûõ.
Ðåêëàìà
Îïòèìèçàöèÿ çàïðîñîâ (âûáîðêè) ê áàçå äàííûõ.
Çäðàâñòâóéòå!
Íà ñàéòå www.rfs-shop.com âîçíèêëà ïðîáëåìà ñ ÁÄ
 òåõíè÷åñêîé ïîääåðæêå ñêàçàëè, ÷òî:
Íà áàçó ó âàñ êîíå÷íî î÷åíü ñåðüåçíàÿ íàãðóçêà, êàæäûé çàïðîñ çàãðóæàåò ÿäðî íà 100%. ß áû ðàññìîòðåë âîçìîæíîñòü îïòèìèçàöèè çàïðîñîâ, ò.ê. ñî ñòîðîíû ñåðâåðà òóò ìàëî ÷òî ìîæíî ñäåëàòü.
Òàêæå íàáëþäàåòñÿ íàãðóçêà íà ÁÄ :
| 888024 | u2398379_default | localhost:37443 | u2398379_rfs | Query | 3 | Sending data | SELECT DISTINCT BE.ID as ID,BE.NAME as NAME,BE.CODE as CODE,DATE_FORMAT(BE.DATE_CREATE, '%d.%m.%Y %H |
| 888026 | u2398379_default | localhost:37448 | u2398379_rfs | Query | 2 | Sending data | SELECT COUNT(DISTINCT BE.ID) as C
FROM b_iblock B
INNER JOIN b_lang L ON B.LID=L.LID
INNER |
| 888027 | u2398379_default | localhost:37449 | u2398379_rfs | Query | 2 | Sending data | SELECT COUNT(DISTINCT BE.ID) as C
FROM b_iblock B
INNER JOIN b_lang L ON B.LID=L.LID
INNER |
| 888028 | u2398379_default | localhost:37451 | u2398379_rfs | Query | 1 | Sending data | SELECT BE.ID as ID,BE.IBLOCK_ID as IBLOCK_...