Ðåêëàìà
Çäðàâñòâóéòå! Íà ñàéòå 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_...
Äðóãèå îòêðûòûå çàäàíèÿ:
Áþäæåò: 120 000 ð. Èçäàòåëüñòâî ïðèãëàøàåò àâòîðîâ äëÿ íàïèñàíèÿ êíèã ïî òåìàòèêàì: Ðàäèîýëåêòðîíèêà, Ýëåêòðèêà, Ñâàðêà: - Ñâàðêà (âñå âèäû, ïðàêòè÷åñêèå ðóêîâîäñòâà); - Èìïóëüñí…
Áþäæåò: 14 000 ð. Èùåì àäìèíèñòðàòîðà ñîîáùåñòâà ÂÊ äëÿ ðåãóëÿðíîãî âåäåíèÿ ãðóïïû. Ðàáîòà ñïîêîéíàÿ, çàäà÷è ïîâòîðÿþùèåñÿ è ïîíÿòíûå. ×òî íóæíî äåëàòü: — Ðàçìåùàòü íîâîñòè/ïîñòû…
Áþäæåò: 12 300 ð. Òðåáóåòñÿ ìåíåäæåð ÷àòà äëÿ ðàáîòû ñ êëèåíòñêèìè îáðàùåíèÿìè. Âñå ïðîöåññû âûñòðîåíû, âàæíî ñëåäîâàòü èíñòðóêöèè. ×òî íóæíî äåëàòü: - Îòâå÷àòü íà âõîäÿùèå çàïðî…
ïîèñê çàäàíèé
Îïòèìèçàöèÿ çàïðîñîâ (âûáîðêè) ê áàçå äàííûõ.
Ðåêëàìà
Îïòèìèçàöèÿ çàïðîñîâ (âûáîðêè) ê áàçå äàííûõ.
Çäðàâñòâóéòå!
Íà ñàéòå 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_...