{"id":36704,"date":"2019-10-31T22:13:15","date_gmt":"2019-10-31T19:13:15","guid":{"rendered":"https:\/\/prohoster.info\/blog\/optimizatsiya-zaprosov-bazy-dannyh-na-primere-b2b-servisa-dlya-stroitelej\/"},"modified":"2019-10-31T22:13:15","modified_gmt":"2019-10-31T19:13:15","slug":"optimizatsiya-zaprosov-bazy-dannyh-na-primere-b2b-servisa-dlya-stroitelej","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/optimizatsiya-zaprosov-bazy-dannyh-na-primere-b2b-servisa-dlya-stroitelej","title":{"rendered":"Optimizimi i k\u00ebrkesave t\u00eb baz\u00ebs s\u00eb t\u00eb dh\u00ebnave n\u00eb shembullin e nj\u00eb sh\u00ebrbimi B2B p\u00ebr nd\u00ebrtuesit","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>\u041a\u0430\u043a \u0432\u044b\u0440\u0430\u0441\u0442\u0438 \u0432 10 \u0440\u0430\u0437 \u043f\u043e\u0434 \u043a\u043e\u043b\u0438\u0447\u0435\u0441\u0442\u0432\u0443 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 \u043a \u0411\u0414 \u043d\u0435 \u043f\u0435\u0440\u0435\u0435\u0437\u0436\u0430\u044f \u043d\u0430 \u0431\u043e\u043b\u0435\u0435 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0439 \u0441\u0435\u0440\u0432\u0435\u0440 \u0438 \u0441\u043e\u0445\u0440\u0430\u043d\u0438\u0442\u044c \u0440\u0430\u0431\u043e\u0442\u043e\u0441\u043f\u043e\u0441\u043e\u0431\u043d\u043e\u0441\u0442\u044c \u0441\u0438\u0441\u0442\u0435\u043c\u044b? \u042f \u0440\u0430\u0441\u0441\u043a\u0430\u0436\u0443, \u043a\u0430\u043a \u043c\u044b \u0431\u043e\u0440\u043e\u043b\u0438\u0441\u044c \u0441 \u043f\u0430\u0434\u0435\u043d\u0438\u0435\u043c \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u0438 \u043d\u0430\u0448\u0435\u0439 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445, \u043a\u0430\u043a \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0438\u0440\u043e\u0432\u0430\u043b\u0438 SQL \u0437\u0430\u043f\u0440\u043e\u0441\u044b, \u0447\u0442\u043e\u0431\u044b \u043e\u0431\u0441\u043b\u0443\u0436\u0438\u0432\u0430\u0442\u044c \u043a\u0430\u043a \u043c\u043e\u0436\u043d\u043e \u0431\u043e\u043b\u044c\u0448\u0435 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u0439 \u0438 \u043d\u0435 \u043f\u043e\u0432\u044b\u0448\u0430\u0442\u044c \u0440\u0430\u0441\u0445\u043e\u0434\u044b \u043d\u0430 \u0432\u044b\u0447\u0438\u0441\u043b\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0435 \u0440\u0435\u0441\u0443\u0440\u0441\u044b.<br \/>\n<noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><br \/>\n\u042f \u0434\u0435\u043b\u0430\u044e \u0441\u0435\u0440\u0432\u0438\u0441 \u0434\u043b\u044f \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u0431\u0438\u0437\u043d\u0435\u0441 \u043f\u0440\u043e\u0446\u0435\u0441\u0441\u0430\u043c\u0438 \u0432 \u0441\u0442\u0440\u043e\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0445 \u043a\u043e\u043c\u043f\u0430\u043d\u0438\u044f\u0445. \u0421 \u043d\u0430\u043c\u0438 \u0440\u0430\u0431\u043e\u0442\u0430\u0435\u0442 \u043e\u043a\u043e\u043b\u043e 3 \u0442\u044b\u0441\u044f\u0447 \u043a\u043e\u043c\u043f\u0430\u043d\u0438\u0439. \u0411\u043e\u043b\u0435\u0435 10 \u0442\u044b\u0441\u044f\u0447 \u0447\u0435\u043b\u043e\u0432\u0435\u043a \u043a\u0430\u0436\u0434\u044b\u0439 \u0434\u0435\u043d\u044c \u0440\u0430\u0431\u043e\u0442\u0430\u044e\u0442 \u0441 \u043d\u0430\u0448\u0435\u0439 \u0441\u0438\u0441\u0442\u0435\u043c\u043e\u0439 \u043f\u043e 4-10 \u0447\u0430\u0441\u043e\u0432. \u041e\u043d\u0430 \u0440\u0435\u0448\u0430\u0435\u0442 \u0440\u0430\u0437\u043d\u044b\u0435 \u0437\u0430\u0434\u0430\u0447\u0438 \u043f\u043b\u0430\u043d\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f, \u043e\u043f\u043e\u0432\u0435\u0449\u0435\u043d\u0438\u044f, \u043f\u0440\u0435\u0434\u0443\u043f\u0440\u0435\u0436\u0434\u0435\u043d\u0438\u044f, \u0432\u0430\u043b\u0438\u0434\u0430\u0446\u0438\u0438\u2026 \u041c\u044b \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u043c PostgreSQL 9.6. \u0412 \u0431\u0430\u0437\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 \u0443 \u043d\u0430\u0441 \u043e\u043a\u043e\u043b\u043e 300 \u0442\u0430\u0431\u043b\u0438\u0446 \u0438 \u043a\u0430\u0436\u0434\u044b\u0435 \u0441\u0443\u0442\u043a\u0438 \u0432 \u043d\u0435\u0435 \u043f\u043e\u0441\u0442\u0443\u043f\u0430\u0435\u0442 \u0434\u043e 200 \u043c\u043b\u043d \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 (10 \u0442\u044b\u0441\u044f\u0447 \u0440\u0430\u0437\u043b\u0438\u0447\u043d\u044b\u0445). \u0412 \u0441\u0440\u0435\u0434\u043d\u0435\u043c \u0443 \u043d\u0430\u0441 3-4 \u0442\u044b\u0441\u044f\u0447 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 \u0432 \u0441\u0435\u043a\u0443\u043d\u0434\u0443, \u0432 \u0441\u0430\u043c\u044b\u0435 \u0430\u043a\u0442\u0438\u0432\u043d\u044b\u0435 \u043c\u043e\u043c\u0435\u043d\u0442\u044b \u0431\u043e\u043b\u0435\u0435 10 \u0442\u044b\u0441\u044f\u0447 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 \u0432 \u0441\u0435\u043a\u0443\u043d\u0434\u0443. \u0411\u043e\u043b\u044c\u0448\u0430\u044f \u0447\u0430\u0441\u0442\u044c \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 \u2014 OLAP. \u0414\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0438\u0439, \u043c\u043e\u0434\u0438\u0444\u0438\u043a\u0430\u0446\u0438\u0439 \u0438 \u0443\u0434\u0430\u043b\u0435\u043d\u0438\u0439 \u043d\u0430\u043c\u043d\u043e\u0433\u043e \u043c\u0435\u043d\u044c\u0448\u0435, \u0442\u043e \u0435\u0441\u0442\u044c OLTP \u043d\u0430\u0433\u0440\u0443\u0437\u043a\u0430 \u043e\u0442\u043d\u043e\u0441\u0438\u0442\u0435\u043b\u044c\u043d\u043e \u043d\u0435\u0431\u043e\u043b\u044c\u0448\u0430\u044f. \u0412\u0441\u0435 \u044d\u0442\u0438 \u0446\u0438\u0444\u0440\u044b \u044f \u043f\u0440\u0438\u0432\u0435\u043b, \u0447\u0442\u043e\u0431\u044b \u0432\u044b \u043c\u043e\u0433\u043b\u0438 \u043e\u0446\u0435\u043d\u0438\u0442\u044c \u043c\u0430\u0441\u0448\u0442\u0430\u0431 \u043d\u0430\u0448\u0435\u0433\u043e \u043f\u0440\u043e\u0435\u043a\u0442\u0430 \u0438 \u043f\u043e\u043d\u044f\u0442\u044c \u043d\u0430\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u043d\u0430\u0448 \u043e\u043f\u044b\u0442 \u043c\u043e\u0436\u0435\u0442 \u0431\u044b\u0442\u044c \u043f\u043e\u043b\u0435\u0437\u0435\u043d \u0434\u043b\u044f \u0432\u0430\u0441.<\/p>\n<h3>\u041a\u0430\u0440\u0442\u0438\u043d\u0430 \u043f\u0435\u0440\u0432\u0430\u044f. \u041b\u0438\u0440\u0438\u0447\u0435\u0441\u043a\u0430\u044f<\/h3>\n<p>\n\u041a\u043e\u0433\u0434\u0430 \u043c\u044b \u043d\u0430\u0447\u0438\u043d\u0430\u043b\u0438 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0443, \u0442\u043e \u043e\u0441\u043e\u0431\u043e \u043d\u0435 \u0437\u0430\u0434\u0443\u043c\u044b\u0432\u0430\u043b\u0438\u0441\u044c \u043e \u0442\u043e\u043c, \u043a\u0430\u043a\u0430\u044f \u043d\u0430\u0433\u0440\u0443\u0437\u043a\u0430 \u043b\u044f\u0436\u0435\u0442 \u043d\u0430 \u0411\u0414 \u0438 \u0447\u0442\u043e \u043c\u044b \u0431\u0443\u0434\u0435\u043c \u0434\u0435\u043b\u0430\u0442\u044c \u0435\u0441\u043b\u0438 \u0441\u0435\u0440\u0432\u0435\u0440 \u043f\u0435\u0440\u0435\u0441\u0442\u0430\u043d\u0435\u0442 \u0432\u044b\u0442\u044f\u0433\u0438\u0432\u0430\u0442\u044c. \u041f\u0440\u0438 \u043f\u0440\u043e\u0435\u043a\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0438 \u0411\u0414 \u043c\u044b \u0441\u043b\u0435\u0434\u043e\u0432\u0430\u043b\u0438 \u043e\u0431\u0449\u0438\u043c \u0440\u0435\u043a\u043e\u043c\u0435\u043d\u0434\u0430\u0446\u0438\u044f\u043c \u0438 \u0441\u0442\u0430\u0440\u0430\u043b\u0438\u0441\u044c \u043d\u0435 \u0441\u0442\u0440\u0435\u043b\u044f\u0442\u044c \u0441\u0435\u0431\u0435 \u0432 \u043d\u043e\u0433\u0443, \u043d\u043e \u0434\u0430\u043b\u044c\u0448\u0435 \u043e\u0431\u0449\u0438\u0445 \u0441\u043e\u0432\u0435\u0442\u043e\u0432 \u0432\u0440\u043e\u0434\u0435 \u201c\u043d\u0435 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0439\u0442\u0435 \u043f\u0430\u0442\u0442\u0435\u0440\u043d <noindex><a rel=\"nofollow\" href=\"https:\/\/en.wikipedia.org\/wiki\/Entity%E2%80%93attribute%E2%80%93value_model\">Entity Attribute Values<\/a><\/noindex> \u043c\u044b \u043d\u0435 \u0437\u0430\u0445\u043e\u0434\u0438\u043b\u0438. \u041f\u0440\u043e\u0435\u043a\u0442\u0438\u0440\u043e\u0432\u0430\u043b\u0438 \u0438\u0441\u0445\u043e\u0434\u044f \u0438\u0437 \u043f\u0440\u0438\u043d\u0446\u0438\u043f\u043e\u0432 \u043d\u043e\u0440\u043c\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u0438 \u0438\u0437\u0431\u0435\u0433\u0430\u044f \u0438\u0437\u0431\u044b\u0442\u043e\u0447\u043d\u043e\u0441\u0442\u0438 \u0434\u0430\u043d\u043d\u044b\u0445 \u0438 \u043d\u0435 \u0437\u0430\u0431\u043e\u0442\u0438\u043b\u0438\u0441\u044c \u043e\u0431 \u0443\u0441\u043a\u043e\u0440\u0435\u043d\u0438\u044f \u0442\u0435\u0445 \u0438\u043b\u0438 \u0438\u043d\u044b\u0445 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432. \u041a\u0430\u043a \u0442\u043e\u043b\u044c\u043a\u043e \u043f\u0440\u0438\u0448\u043b\u0438 \u043f\u0435\u0440\u0432\u044b\u0435 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0438 \u043c\u044b \u0441\u0442\u043e\u043b\u043a\u043d\u0443\u043b\u0438\u0441\u044c \u0441 \u043f\u0440\u043e\u0431\u043b\u0435\u043c\u043e\u0439 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u0438. \u041a\u0430\u043a \u043e\u0431\u044b\u0447\u043d\u043e \u043c\u044b \u043e\u043a\u0430\u0437\u0430\u043b\u0438\u0441\u044c \u0430\u0431\u0441\u043e\u043b\u044e\u0442\u043d\u043e \u043d\u0435 \u0433\u043e\u0442\u043e\u0432\u044b \u043a \u044d\u0442\u043e\u043c\u0443. \u041f\u0435\u0440\u0432\u044b\u0435 \u043f\u0440\u043e\u0431\u043b\u0435\u043c\u044b \u043e\u043a\u0430\u0437\u0430\u043b\u0438\u0441\u044c \u043f\u0440\u043e\u0441\u0442\u044b\u043c\u0438. \u041a\u0430\u043a \u043f\u0440\u0430\u0432\u0438\u043b\u043e \u0432\u0441\u0435 \u0440\u0435\u0448\u0430\u043b\u043e\u0441\u044c \u0434\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0438\u0435\u043c \u043d\u043e\u0432\u043e\u0433\u043e \u0438\u043d\u0434\u0435\u043a\u0441\u0430. \u041d\u043e \u043d\u0430\u0441\u0442\u0443\u043f\u0438\u043b \u043c\u043e\u043c\u0435\u043d\u0442 \u043a\u043e\u0433\u0434\u0430 \u043f\u0440\u043e\u0441\u0442\u044b\u0435 \u0437\u0430\u043f\u043b\u0430\u0442\u043a\u0438 \u043f\u0435\u0440\u0435\u0441\u0442\u0430\u043b\u0438 \u0440\u0430\u0431\u043e\u0442\u0430\u0442\u044c. \u041e\u0441\u043e\u0437\u043d\u0430\u0432, \u0447\u0442\u043e \u043e\u043f\u044b\u0442\u0430 \u043d\u0435 \u0445\u0432\u0430\u0442\u0430\u0435\u0442 \u0438 \u043d\u0430\u043c \u0432\u0441\u0435 \u0441\u043b\u043e\u0436\u043d\u0435\u0435 \u043f\u043e\u043d\u044f\u0442\u044c \u0432 \u0447\u0435\u043c \u043f\u0440\u0438\u0447\u0438\u043d\u0430 \u043f\u0440\u043e\u0431\u043b\u0435\u043c, \u043c\u044b \u043d\u0430\u043d\u044f\u043b\u0438 \u0441\u043f\u0435\u0446\u0438\u0430\u043b\u0438\u0441\u0442\u043e\u0432, \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u043f\u043e\u043c\u043e\u0433\u043b\u0438 \u043d\u0430\u043c \u043f\u0440\u0430\u0432\u0438\u043b\u044c\u043d\u043e \u043d\u0430\u0441\u0442\u0440\u043e\u0438\u0442\u044c \u0441\u0435\u0440\u0432\u0435\u0440, \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0438\u0442\u044c \u043c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u043d\u0433, \u043f\u043e\u043a\u0430\u0437\u0430\u043b\u0438 \u043a\u0443\u0434\u0430 \u0441\u043c\u043e\u0442\u0440\u0435\u0442\u044c, \u0447\u0442\u043e\u0431\u044b \u043f\u043e\u043b\u0443\u0447\u0438\u0442\u044c <noindex><a rel=\"nofollow\" href=\"https:\/\/www.postgresql.org\/docs\/9.6\/pgstatstatements.html\">statistika<\/a><\/noindex>.<\/p>\n<h3>\u041a\u0430\u0440\u0442\u0438\u043d\u0430 \u0432\u0442\u043e\u0440\u0430\u044f. \u0421\u0442\u0430\u0442\u0438\u0441\u0442\u0438\u0447\u0435\u0441\u043a\u0430\u044f<\/h3>\n<p>\n\u0418\u0442\u0430\u043a \u0443 \u043d\u0430\u0441 \u0435\u0441\u0442\u044c \u043e\u043a\u043e\u043b\u043e 10 \u0442\u044b\u0441\u044f\u0447 \u0440\u0430\u0437\u043b\u0438\u0447\u043d\u044b\u0445 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432, \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u044e\u0442\u0441\u044f \u043d\u0430 \u043d\u0430\u0448\u0435\u0439 \u0411\u0414 \u0437\u0430 \u0441\u0443\u0442\u043a\u0438. \u0418\u0437 \u044d\u0442\u0438\u0445 10 \u0442\u044b\u0441\u044f\u0447 \u0435\u0441\u0442\u044c \u043c\u043e\u043d\u0441\u0442\u0440\u044b, \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u044e\u0442\u0441\u044f \u043f\u043e 2-3 \u043c\u043b\u043d \u0440\u0430\u0437 \u0441\u043e \u0441\u0440\u0435\u0434\u043d\u0438\u043c \u0432\u0440\u0435\u043c\u0435\u043d\u0435\u043c \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044f 0.1-0.3 \u043c\u0441 \u0438 \u0435\u0441\u0442\u044c \u0437\u0430\u043f\u0440\u043e\u0441\u044b \u0441\u043e \u0441\u0440\u0435\u0434\u043d\u0438\u043c \u0432\u0440\u0435\u043c\u0435\u043d\u0435\u043c \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044f 30 \u0441\u0435\u043a\u0443\u043d\u0434, \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u0432\u044b\u0437\u044b\u0432\u0430\u044e\u0442\u0441\u044f 100 \u0440\u0430\u0437 \u0432 \u0441\u0443\u0442\u043a\u0438.<\/p>\n<p>\u041e\u043f\u0442\u0438\u043c\u0438\u0437\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u0432\u0441\u0435 10 \u0442\u044b\u0441\u044f\u0447 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 \u043d\u0435 \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u044f\u043b\u043e\u0441\u044c \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u044b\u043c, \u043f\u043e\u044d\u0442\u043e\u043c\u0443 \u043c\u044b \u0440\u0435\u0448\u0438\u043b\u0438 \u0440\u0430\u0437\u043e\u0431\u0440\u0430\u0442\u044c\u0441\u044f \u0441 \u0442\u0435\u043c, \u043a\u0443\u0434\u0430 \u043d\u0430\u043f\u0440\u0430\u0432\u043b\u044f\u0442\u044c \u0443\u0441\u0438\u043b\u0438\u044f, \u0447\u0442\u043e\u0431\u044b \u043f\u043e\u0432\u044b\u0448\u0430\u0442\u044c \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u044c \u0411\u0414 \u043f\u0440\u0430\u0432\u0438\u043b\u044c\u043d\u043e. \u041f\u043e\u0441\u043b\u0435 \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u0438\u0445 \u0438\u0442\u0435\u0440\u0430\u0446\u0438\u0439 \u043c\u044b \u0441\u0442\u0430\u043b\u0438 \u0434\u0435\u043b\u0438\u0442\u044c \u0437\u0430\u043f\u0440\u043e\u0441\u044b \u043d\u0430 \u0442\u0438\u043f\u044b.<\/p>\n<h4>TOP \u0437\u0430\u043f\u0440\u043e\u0441\u044b<\/h4>\n<p>\n\u042d\u0442\u043e \u0441\u0430\u043c\u044b\u0435 \u0442\u044f\u0436\u0435\u043b\u044b\u0435 \u0437\u0430\u043f\u0440\u043e\u0441\u044b, \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u0437\u0430\u043d\u0438\u043c\u0430\u044e\u0442 \u0431\u043e\u043b\u044c\u0448\u0435 \u0432\u0441\u0435\u0433\u043e \u0432\u0440\u0435\u043c\u0435\u043d\u0438 (total time). \u042d\u0442\u043e \u0437\u0430\u043f\u0440\u043e\u0441\u044b, \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u043b\u0438\u0431\u043e \u043e\u0447\u0435\u043d\u044c \u0447\u0430\u0441\u0442\u043e \u0432\u044b\u0437\u044b\u0432\u0430\u044e\u0442\u0441\u044f \u043b\u0438\u0431\u043e \u0437\u0430\u043f\u0440\u043e\u0441\u044b, \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u043e\u0447\u0435\u043d\u044c \u0434\u043e\u043b\u0433\u043e \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u044e\u0442\u0441\u044f (\u0434\u043e\u043b\u0433\u0438\u0435 \u0438 \u0447\u0430\u0441\u0442\u044b\u0435 \u0437\u0430\u043f\u0440\u043e\u0441\u044b \u0431\u044b\u043b\u0438 \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0438\u0440\u043e\u0432\u0430\u043d\u044b \u0435\u0449\u0435 \u043d\u0430 \u043f\u0435\u0440\u0432\u044b\u0445 \u0438\u0442\u0435\u0440\u0430\u0446\u0438\u044f\u0445 \u0431\u043e\u0440\u044c\u0431\u044b \u0437\u0430 \u0441\u043a\u043e\u0440\u043e\u0441\u0442\u044c). \u0412 \u0438\u0442\u043e\u0433\u0435 \u0441\u0443\u043c\u043c\u0430\u0440\u043d\u043e \u043d\u0430 \u0438\u0445 \u0438\u0441\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u0435 \u0441\u0435\u0440\u0432\u0435\u0440 \u0442\u0440\u0430\u0442\u0438\u0442 \u0431\u043e\u043b\u044c\u0448\u0435 \u0432\u0441\u0435\u0433\u043e \u0432\u0440\u0435\u043c\u0435\u043d\u0438. \u041f\u0440\u0438\u0447\u0435\u043c \u0432\u0430\u0436\u043d\u043e \u043e\u0442\u0434\u0435\u043b\u044f\u0442\u044c \u0442\u043e\u043f \u0437\u0430\u043f\u0440\u043e\u0441\u044b \u043f\u043e \u043e\u0431\u0449\u0435\u043c\u0443 \u0432\u0440\u0435\u043c\u0435\u043d\u0438 \u0438\u0441\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044f \u0438 \u043e\u0442\u0434\u0435\u043b\u044c\u043d\u043e \u043f\u043e IO time. \u0421\u043f\u043e\u0441\u043e\u0431\u044b \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0430\u0446\u0438\u0438 \u0442\u0430\u043a\u0438\u0445 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 \u043d\u0435\u043c\u043d\u043e\u0433\u043e \u0440\u0430\u0437\u043d\u044b\u0435.<\/p>\n<p>\u041e\u0431\u044b\u0447\u043d\u0430\u044f \u043f\u0440\u0430\u043a\u0442\u0438\u043a\u0430 \u0432\u0441\u0435\u0445 \u043a\u043e\u043c\u043f\u0430\u043d\u0438\u0439- \u0440\u0430\u0431\u043e\u0442\u0430\u0442\u044c \u0441 TOP \u0437\u0430\u043f\u0440\u043e\u0441\u0430\u043c\u0438. \u0418\u0445 \u043d\u0435\u043c\u043d\u043e\u0433\u043e, \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0430\u0446\u0438\u044f \u0434\u0430\u0436\u0435 \u043e\u0434\u043d\u043e\u0433\u043e \u0437\u0430\u043f\u0440\u043e\u0441\u0430 \u043c\u043e\u0436\u0435\u0442 \u043e\u0441\u0432\u043e\u0431\u043e\u0434\u0438\u0442\u044c 5-10% \u0440\u0435\u0441\u0443\u0440\u0441\u043e\u0432. \u041e\u0434\u043d\u0430\u043a\u043e, \u043f\u043e \u043c\u0435\u0440\u0435 \u201c\u0432\u0437\u0440\u043e\u0441\u043b\u0435\u043d\u0438\u044f\u201d \u043f\u0440\u043e\u0435\u043a\u0442\u0430 \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0430\u0446\u0438\u044f TOP \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 \u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u0441\u044f \u0432\u0441\u0435 \u0431\u043e\u043b\u0435\u0435 \u043d\u0435\u0442\u0440\u0438\u0432\u0438\u0430\u043b\u044c\u043d\u043e\u0439 \u0437\u0430\u0434\u0430\u0447\u0435\u0439. \u0412\u0441\u0435 \u043f\u0440\u043e\u0441\u0442\u044b\u0435 \u0441\u043f\u043e\u0441\u043e\u0431\u044b \u0443\u0436\u0435 \u043e\u0442\u0440\u0430\u0431\u043e\u0442\u0430\u043d\u044b, \u0434\u0430 \u0438 \u0441\u0430\u043c\u044b\u0439 \u201c\u0442\u044f\u0436\u0435\u043b\u044b\u0439\u201d \u0437\u0430\u043f\u0440\u043e\u0441 \u043e\u0442\u043d\u0438\u043c\u0430\u0435\u0442 \u201c\u0432\u0441\u0435\u0433\u043e\u201d 3-5% \u0440\u0435\u0441\u0443\u0440\u0441\u043e\u0432. \u0415\u0441\u043b\u0438 TOP \u0437\u0430\u043f\u0440\u043e\u0441\u044b \u0432 \u0441\u0443\u043c\u043c\u0435 \u0437\u0430\u043d\u0438\u043c\u0430\u044e\u0442 \u043c\u0435\u043d\u0435\u0435 30-40% \u0432\u0440\u0435\u043c\u0435\u043d\u0438, \u0442\u043e \u0441\u043a\u043e\u0440\u0435\u0435 \u0432\u0441\u0435\u0433\u043e \u0432\u044b \u0443\u0436\u0435 \u043f\u0440\u0438\u043b\u043e\u0436\u0438\u043b\u0438 \u0443\u0441\u0438\u043b\u0438\u044f, \u0447\u0442\u043e\u0431\u044b \u043e\u043d\u0438 \u0440\u0430\u0431\u043e\u0442\u0430\u043b\u0438 \u0431\u044b\u0441\u0442\u0440\u043e \u0438 \u043f\u0440\u0438\u0448\u043b\u0430 \u043f\u043e\u0440\u0430 \u043f\u0435\u0440\u0435\u0445\u043e\u0434\u0438\u0442\u044c \u043a \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0430\u0446\u0438\u0438 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 \u0438\u0437 \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0435\u0439 \u0433\u0440\u0443\u043f\u043f\u044b.<br \/>\n\u041e\u0441\u0442\u0430\u0435\u0442\u0441\u044f \u043e\u0442\u0432\u0435\u0442\u0438\u0442\u044c \u043d\u0430 \u0432\u043e\u043f\u0440\u043e\u0441 \u0441\u043a\u043e\u043b\u044c\u043a\u043e \u0432\u0435\u0440\u0445\u043d\u0438\u0445 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 \u0432\u043a\u043b\u044e\u0447\u0438\u0442\u044c \u0432 \u044d\u0442\u0443 \u0433\u0440\u0443\u043f\u043f\u0443. \u042f \u043e\u0431\u044b\u0447\u043d\u043e \u0431\u0435\u0440\u0443 \u043d\u0435 \u043c\u0435\u043d\u044c\u0448\u0435 10, \u043d\u043e \u043d\u0435 \u0431\u043e\u043b\u044c\u0448\u0435 20. \u0421\u0442\u0430\u0440\u0430\u044e\u0441\u044c, \u0447\u0442\u043e\u0431\u044b \u0432\u0440\u0435\u043c\u044f \u043f\u0435\u0440\u0432\u043e\u0433\u043e \u0438 \u043f\u043e\u0441\u043b\u0435\u0434\u043d\u0435\u0433\u043e \u0432 TOP \u0433\u0440\u0443\u043f\u043f\u0435 \u043e\u0442\u043b\u0438\u0447\u0430\u043b\u043e\u0441\u044c \u043d\u0435 \u0431\u043e\u043b\u0435\u0435 \u0447\u0435\u043c \u0432 10 \u0440\u0430\u0437. \u0422\u043e \u0435\u0441\u0442\u044c \u0435\u0441\u043b\u0438 \u0432\u0440\u0435\u043c\u044f \u0438\u0441\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044f \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 \u0440\u0435\u0437\u043a\u043e \u043f\u0430\u0434\u0430\u0435\u0442 \u0441 1 \u043c\u0435\u0441\u0442\u0430 \u0434\u043e 10, \u0442\u043e \u0431\u0435\u0440\u0443 TOP-10, \u0435\u0441\u043b\u0438 \u043f\u0430\u0434\u0435\u043d\u0438\u0435 \u0431\u043e\u043b\u0435\u0435 \u043f\u043b\u0430\u0432\u043d\u043e\u0435, \u0442\u043e \u0443\u0432\u0435\u043b\u0438\u0447\u0438\u0432\u0430\u044e \u0440\u0430\u0437\u043c\u0435\u0440 \u0433\u0440\u0443\u043f\u043f\u044b \u0434\u043e 15 \u0438\u043b\u0438 20.<br \/>\n<img decoding=\"async\" alt=\"Optimizimi i k\u00ebrkesave t\u00eb baz\u00ebs s\u00eb t\u00eb dh\u00ebnave n\u00eb shembullin e nj\u00eb sh\u00ebrbimi B2B p\u00ebr nd\u00ebrtuesit\" src=\"\/wp-content\/uploads\/2019\/08\/2a9d9e6053d1aebb71aa213757bd2393.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<\/p>\n<h4>\u0421\u0435\u0440\u0435\u0434\u043d\u044f\u043a\u0438 (medium)<\/h4>\n<p>\n\u042d\u0442\u043e \u0432\u0441\u0435 \u0437\u0430\u043f\u0440\u043e\u0441\u044b, \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u0438\u0434\u0443\u0442 \u0441\u0440\u0430\u0437\u0443 \u0437\u0430 TOP, \u0437\u0430 \u0438\u0441\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u0435\u043c \u043f\u043e\u0441\u043b\u0435\u0434\u043d\u0438\u0445 5-10%. \u041e\u0431\u044b\u0447\u043d\u043e \u0432 \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0430\u0446\u0438\u0438 \u0438\u043c\u0435\u043d\u043d\u043e \u044d\u0442\u0438\u0445 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 \u043a\u0440\u043e\u0435\u0442\u0441\u044f \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u044c \u0441\u0438\u043b\u044c\u043d\u043e \u043f\u043e\u0434\u043d\u044f\u0442\u044c \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u044c \u0441\u0435\u0440\u0432\u0435\u0440\u0430. \u042d\u0442\u0438 \u0437\u0430\u043f\u0440\u043e\u0441\u044b \u043c\u043e\u0433\u0443\u0442 \u201c\u0432\u0435\u0441\u0438\u0442\u044c\u201d \u0434\u043e 80%. \u041d\u043e \u0434\u0430\u0436\u0435 \u0435\u0441\u043b\u0438 \u0438\u0445 \u0434\u043e\u043b\u044f \u043f\u0435\u0440\u0435\u0432\u0430\u043b\u0438\u043b\u0430 \u0437\u0430 50%, \u0437\u043d\u0430\u0447\u0438\u0442 \u043f\u043e\u0440\u0430 \u043d\u0430 \u043d\u0438\u0445 \u0432\u0437\u0433\u043b\u044f\u043d\u0443\u0442\u044c \u0431\u043e\u043b\u0435\u0435 \u0432\u043d\u0438\u043c\u0430\u0442\u0435\u043b\u044c\u043d\u043e.<\/p>\n<h4>\u0425\u0432\u043e\u0441\u0442 (tail)<\/h4>\n<p>\nSi\u00e7 u tha, k\u00ebto k\u00ebrkesa vijn\u00eb n\u00eb fund dhe ato k\u00ebrkojn\u00eb 5-10% t\u00eb koh\u00ebs. Mund t\u00eb harrohen p\u00ebr sa koh\u00eb q\u00eb nuk po p\u00ebrdorni mjete automatike p\u00ebr analiz\u00ebn e k\u00ebrkesave, ndryshe optimizimi i tyre mund t\u00eb jet\u00eb gjithashtu ekonomik.<\/p>\n<p>Si ta vler\u00ebsojm\u00eb \u00e7do grup?<\/p>\n<p>Un\u00eb p\u00ebrdor nj\u00eb k\u00ebrkes\u00eb SQL q\u00eb ndihmon n\u00eb praktikimin e k\u00ebsaj vler\u00ebsimi p\u00ebr PostgreSQL (jam i sigurt se p\u00ebr shum\u00eb sisteme t\u00eb tjera DBMS mund t\u00eb shkruhet nj\u00eb k\u00ebrkes\u00eb e ngjashme)<\/p>\n<p><b class=\"spoiler_title\">K\u00ebrkesa SQL p\u00ebr t\u00eb vler\u00ebsuar madh\u00ebsin\u00eb e grupeve TOP-MEDIUM-TAIL<\/b><\/p>\n<pre><code class=\"sql\">SELECT sum(time_top) AS sum_top, sum(time_medium) AS sum_medium, sum(time_tail)\nFROM\n(\n  SELECT CASE WHEN rn  20 AND rn  800              THEN tt_percent ELSE 0 END AS time_tail\n  FROM (\n    SELECT total_time \/ (SELECT sum(total_time) FROM pg_stat_statements) * 100 AS tt_percent, query,\n    ROW_NUMBER () OVER (ORDER BY total_time DESC) AS rn\n    FROM pg_stat_statements\n    ORDER BY total_time DESC\n  ) AS t\n)\nAS ts\n<\/code><\/pre>\n<p>Rezultati i k\u00ebrkes\u00ebs - tre kolona, secila p\u00ebrmban p\u00ebrqindjen e koh\u00ebs q\u00eb harxhohet p\u00ebr p\u00ebrpunimin e k\u00ebrkesave nga ky grup. Brenda k\u00ebrkes\u00ebs ka dy numra (n\u00eb rastin tim jan\u00eb 20 dhe 800), t\u00eb cil\u00ebt ndajn\u00eb k\u00ebrkesat e nj\u00eb grupi nga nj\u00eb tjet\u00ebr.<\/p>\n<p>K\u00ebshtu, p\u00ebrqindjet e k\u00ebrkesave n\u00eb fillim t\u00eb pun\u00ebs p\u00ebr optimizimin dhe tani jan\u00eb lidhur.<\/p>\n<p><img decoding=\"async\" alt=\"Optimizimi i k\u00ebrkesave t\u00eb baz\u00ebs s\u00eb t\u00eb dh\u00ebnave n\u00eb shembullin e nj\u00eb sh\u00ebrbimi B2B p\u00ebr nd\u00ebrtuesit\" src=\"\/wp-content\/uploads\/2019\/08\/9c70ad9aba8b835c94729c9dda656eab.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nNga diagrami shihet se pjesa e k\u00ebrkesave TOP ka r\u00ebn\u00eb ndjesh\u00ebm, nd\u00ebrsa jan\u00eb rritur \"mesatar\u00ebt\".<br \/>\nFillimisht, k\u00ebrkesat TOP p\u00ebrmbanin gabime t\u00eb dukshme. Me kalimin e koh\u00ebs, s\u00ebmundjet e f\u00ebmij\u00ebris\u00eb zhduken, pjesa e k\u00ebrkesave TOP u pak\u00ebsua, dhe duhej t\u00eb b\u00ebnim m\u00eb shum\u00eb p\u00ebrpjekje p\u00ebr t\u00eb p\u00ebrshpejtuar k\u00ebrkesat e r\u00ebnda. <\/p>\n<p><b class=\"spoiler_title\">P\u00ebr t\u00eb marr\u00eb tekstin e k\u00ebrkesave p\u00ebrdorim nj\u00eb k\u00ebrkes\u00eb t\u00eb till\u00eb<\/b><\/p>\n<pre><code class=\"sql\">SELECT * FROM (\n  SELECT ROW_NUMBER () OVER (ORDER BY total_time DESC) AS rn, total_time \/ (SELECT sum(total_time) FROM pg_stat_statements) * 100 AS tt_percent, query\n  FROM pg_stat_statements\n  ORDER BY total_time DESC\n) AS T\nWHERE\nrn  20 AND rn  800  -- TAIL\n<\/code><\/pre>\n<p>Ja lista e praktikave m\u00eb t\u00eb p\u00ebrdorura, t\u00eb cilat na ndihmuan t\u00eb p\u00ebrshpejtonim k\u00ebrkesat TOP:<\/p>\n<ul>\n<li>Rindizajnimi i sistemit, p\u00ebr shembull ripunimi i logjik\u00ebs s\u00eb njoftimeve n\u00eb nj\u00eb mesazh broker n\u00eb vend t\u00eb k\u00ebrkesave periodike n\u00eb DB<\/li>\n<li>Shtimi ose ndryshimi i indekseve<\/li>\n<li>Rishkrimi i k\u00ebrkesave ORM n\u00eb SQL t\u00eb past\u00ebr<\/li>\n<li>Rishkrimi i logjik\u00ebs s\u00eb ngarkimit t\u00eb t\u00eb dh\u00ebnave 'lazy'<\/li>\n<li>Keshimi p\u00ebrmes denormalizimit t\u00eb t\u00eb dh\u00ebnave. P\u00ebr shembull, ne kemi nj\u00eb lidhje midis tabelave D\u00ebrgesa -&gt; Fatura -&gt; K\u00ebrkes\u00eb -&gt; Aplikim. Pra, \u00e7do d\u00ebrges\u00eb \u00ebsht\u00eb e lidhur me aplikimin p\u00ebrmes tabelave t\u00eb tjera. P\u00ebr t\u00eb mos lidhur t\u00eb gjitha tabelat n\u00eb \u00e7do k\u00ebrkes\u00eb, ne e kopjuam lidhjen me aplikimin n\u00eb tabel\u00ebn D\u00ebrgesa.<\/li>\n<li>Keshimi i tabelave statike me tabela referencash dhe tabelave q\u00eb ndryshojn\u00eb rrall\u00eb n\u00eb memorjen e programit.<\/li>\n<\/ul>\n<p>\nNdonj\u00ebher\u00eb ndryshimet k\u00ebrkonin nj\u00eb rindizajn t\u00eb konsideruesh\u00ebm, por jepnin 5-10% shkarkim t\u00eb sistemit dhe ishin t\u00eb justifikuara. Me kalimin e koh\u00ebs, p\u00ebrfitimet b\u00ebheshin gjithnj\u00eb e m\u00eb t\u00eb vogla, dhe rindizajni k\u00ebrkonte gjithnj\u00eb e m\u00eb shum\u00eb serioz.<\/p>\n<p>At\u00ebher\u00eb ne i kushtuam v\u00ebmendje grupit t\u00eb dyt\u00eb t\u00eb k\u00ebrkesave, grupit t\u00eb mesatar\u00ebve. N\u00eb at\u00eb grup kishte shum\u00eb m\u00eb tep\u00ebr k\u00ebrkesa dhe dukej se analiza e gjith\u00eb grupit do t\u00eb k\u00ebrkonte shum\u00eb koh\u00eb. Megjithat\u00eb, shumica e k\u00ebrkesave ishin shum\u00eb t\u00eb thjeshta p\u00ebr t'u optimizuar, dhe shum\u00eb probleme p\u00ebrs\u00ebriteshin dhjet\u00ebra her\u00eb n\u00eb variante t\u00eb ndryshme. Ja disa shembuj t\u00eb optimizimeve tipike, t\u00eb cilat ne i kemi aplikuar n\u00eb dhjet\u00ebra k\u00ebrkesa t\u00eb ngjashme dhe \u00e7do grup i k\u00ebrkesave t\u00eb optimizuara shkarkonte DB-n\u00eb me 3-5%.<\/p>\n<ul>\n<li> N\u00eb vend t\u00eb kontrollit t\u00eb pranis\u00eb s\u00eb regjistrimeve me COUNT dhe skanimin e plot\u00eb t\u00eb tabel\u00ebs, filluam t\u00eb p\u00ebrdornim EXISTS\n <\/li>\n<li>U shp\u00ebtuam nga DISTINCT (nuk ka nj\u00eb recet\u00eb t\u00eb p\u00ebrgjithshme, por ndonj\u00ebher\u00eb mund t\u00eb hiqet leht\u00ebsisht duke p\u00ebrshpejtuar k\u00ebrkes\u00ebn 10-100 her\u00eb).\n<p>P\u00ebr shembull, n\u00eb vend t\u00eb nj\u00eb k\u00ebrkese p\u00ebr t\u00eb nxjerr\u00eb t\u00eb gjith\u00eb shofer\u00ebt nga nj\u00eb tabel\u00eb e madhe d\u00ebrgesash (DELIVERY) <\/p>\n<pre><code class=\"sql\">SELECT DISTINCT P.ID, P.FIRST_NAME, P.LAST_NAME\nFROM DELIVERY D JOIN PERSON P ON D.DRIVER_ID = P.ID\n<\/code><\/pre>\n<p>\nb\u00ebn\u00eb nj\u00eb k\u00ebrkes\u00eb p\u00ebr nj\u00eb tabel\u00eb t\u00eb krahasueshme t\u00eb PERSON<\/p>\n<pre><code class=\"sql\">SELECT P.ID, P.FIRST_NAME, P.LAST_NAME\nFROM PERSON\nWHERE EXISTS(SELECT D.ID FROM DELIVERY WHERE D.DRIVER_ID = P.ID)\n<\/code><\/pre>\n<p>\nDuket sikur kemi p\u00ebrdorur nj\u00eb n\u00ebnk\u00ebrkes\u00eb t\u00eb lidhur, por ajo jep nj\u00eb p\u00ebrshpejtim m\u00eb shum\u00eb se 10 her\u00eb.\n <\/li>\n<li>N\u00eb shum\u00eb raste, ne u shk\u00ebput\u00ebm nga COUNT dhe <br \/>\n<noindex><a rel=\"nofollow\" href=\"https:\/\/www.citusdata.com\/blog\/2016\/10\/12\/count-performance\/#dup_counts_estimated_filtered\">e z\u00ebvend\u00ebsuam me llogaritjen e nj\u00eb vlere af\u00ebr<\/a><\/noindex>\n <\/li>\n<li>n\u00eb vend t\u00eb\n<pre><code class=\"sql\">UPPER(s) LIKE JOHN% \n<\/code><\/pre>\n<p>\np\u00ebrdorim <\/p>\n<pre><code class=\"sql\">s ILIKE \"John%\"\n<\/code><\/pre>\n<p>\n <\/li>\n<\/ul>\n<p>\n\u00c7do k\u00ebrkes\u00eb specifike ishte e mundur ta p\u00ebrshpejtonim ndonj\u00ebher\u00eb n\u00eb 3-1000 her\u00eb. Pavar\u00ebsisht nga treguesit e mahnitsh\u00ebm, n\u00eb fillim na dukeshin se nuk kishte kuptim t\u00eb optimizohej nj\u00eb k\u00ebrkes\u00eb q\u00eb ekzekutohej p\u00ebr 10 ms, e cila ishte n\u00eb t\u00eb tretat m\u00eb t\u00eb r\u00ebnda t\u00eb k\u00ebrkesave dhe n\u00eb p\u00ebrgjith\u00ebsi, z\u00ebnien e koh\u00ebs s\u00eb ngarkes\u00ebs n\u00eb DB e kishte n\u00eb p\u00ebrqindjet e vogla. Por, duke aplikuar t\u00eb nj\u00ebjt\u00ebn recet\u00eb p\u00ebr nj\u00eb grup k\u00ebrkesash t\u00eb ngjashme, ne e fitonim disa p\u00ebrqindje. P\u00ebr t\u00eb mos humbur koh\u00eb n\u00eb shikimin manual t\u00eb t\u00eb gjitha k\u00ebrkesave qindra, ne shkruem disa skripta t\u00eb thjeshta, t\u00eb cilat me ndihm\u00ebn e shprehjeve t\u00eb rregullta gjet\u00ebn k\u00ebrkesat e ngjashme. Si rezultat, k\u00ebrkimi automatizuar i grupeve t\u00eb k\u00ebrkesave na lejoj p\u00ebrmir\u00ebsime m\u00eb t\u00eb m\u00ebdha n\u00eb performanc\u00ebn ton\u00eb, duke shpenzuar nj\u00eb sasi t\u00eb vog\u00ebl p\u00ebrpjekjesh.<\/p>\n<p>Si p\u00ebrfundim, ne tashm\u00eb po punojm\u00eb p\u00ebr tre vjet me t\u00eb nj\u00ebjtin harduer. Ngarkesa mesatare ditore \u00ebsht\u00eb rreth 30%, n\u00eb kulme arrin deri n\u00eb 70%. Numri i k\u00ebrkesave dhe p\u00ebrdoruesve \u00ebsht\u00eb rritur rreth 10 her\u00eb. Dhe gjith\u00e7ka \u00ebsht\u00eb fal\u00eb monitorimit konstant t\u00eb k\u00ebtyre grupeve t\u00eb k\u00ebrkimeve TOP-MEDIUM. Sa her\u00eb q\u00eb nj\u00eb k\u00ebrkes\u00eb e re shfaqet n\u00eb grupin TOP, ne e analizojm\u00eb at\u00eb menj\u00ebher\u00eb dhe p\u00ebrpiqemi ta p\u00ebrshpejtojm\u00eb. Grupi MEDIUM ne e shqyrtojm\u00eb \u00e7do jav\u00eb me ndihm\u00ebn e skripteve p\u00ebr analiz\u00ebn e k\u00ebrkesave. N\u00ebse na bien n\u00eb sy k\u00ebrkesa t\u00eb reja, t\u00eb cilat ne tashm\u00eb dim\u00eb si t'i optimizojm\u00eb, ne i ndryshojm\u00eb ato menj\u00ebher\u00eb. Ndonj\u00ebher\u00eb zbulojm\u00eb kritere t\u00eb reja optimizimi, t\u00eb cilat mund t\u00eb aplikohen menj\u00ebher\u00eb p\u00ebr disa k\u00ebrkesa. <\/p>\n<p>Sipas parashikimeve tona, serveri aktual do t\u00eb p\u00ebrballoj\u00eb rritjen e numrit t\u00eb p\u00ebrdoruesve edhe 3-5 her\u00eb t\u00eb tjera. Sidoqoft\u00eb, kemi nj\u00eb shtes\u00eb n\u00eb dor\u00eb - ende nuk i kemi transferuar k\u00ebrkesat SELECT n\u00eb nj\u00eb pasqyr\u00eb, si\u00e7 rekomandohet. Por ne nuk e b\u00ebjm\u00eb k\u00ebt\u00eb me vet\u00ebdije, pasi d\u00ebshirojm\u00eb fillimisht t\u00eb shfryt\u00ebzojm\u00eb deri n\u00eb fund mund\u00ebsit\u00eb e optimizimit 'inteligjent', para se t\u00eb aktivizojm\u00eb 'artillerin\u00eb e madhe'.<br \/>\nNj\u00eb qasje kritike ndaj pun\u00ebs s\u00eb kryer mund t\u00eb sugjeroj\u00eb p\u00ebrdorimin e shkall\u00ebzimit vertical. T\u00eb blejm\u00eb nj\u00eb server m\u00eb t\u00eb fuqish\u00ebm, n\u00eb vend q\u00eb t\u00eb harxhojm\u00eb koh\u00ebn e specialist\u00ebve. Nj\u00eb server mund t\u00eb mos kushtoj\u00eb kaq shum\u00eb, ve\u00e7an\u00ebrisht duke pasur parasysh q\u00eb kufijt\u00eb e shkall\u00ebzimit vertical ende nuk jan\u00eb shteruar. Megjithat\u00eb, numri i k\u00ebrkesave \u00ebsht\u00eb rritur vet\u00ebm 10 her\u00eb. N\u00eb disa vite, funksionaliteti i sistemit \u00ebsht\u00eb rritur dhe tani ka m\u00eb shum\u00eb lloje k\u00ebrkesash. Funksionaliteti q\u00eb kishte, p\u00ebrmes caching, p\u00ebrfundohet me nj\u00eb num\u00ebr m\u00eb t\u00eb vog\u00ebl k\u00ebrkesash, p\u00ebr m\u00eb tep\u00ebr, k\u00ebrkesa m\u00eb efikase. K\u00ebshtu duhet t\u00eb dyfishojm\u00eb edhe 5 her\u00eb, p\u00ebr t\u00eb marr\u00eb koeficientin real t\u00eb p\u00ebrshpejtimit. Pra, sipas llogarive m\u00eb modeste, mund t\u00eb themi se p\u00ebrshpejtimi \u00ebsht\u00eb 50 her\u00eb ose m\u00eb shum\u00eb. Shkall\u00ebzimi vertical i serverit p\u00ebr 50 her\u00eb do t\u00eb kishte kushtuar m\u00eb shum\u00eb. Sidomos duke pasur parasysh, se optimizimi i kryer nj\u00ebher\u00eb punon gjithmon\u00eb, nd\u00ebrsa faturat p\u00ebr serverin e marr\u00eb me qira vijn\u00eb \u00e7do muaj.<br \/>\n<br \/>Burimi: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/461071\/\">habr.com<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041a\u0430\u043a \u0432\u044b\u0440\u0430\u0441\u0442\u0438 \u0432 10 \u0440\u0430\u0437 \u043f\u043e\u0434 \u043a\u043e\u043b\u0438\u0447\u0435\u0441\u0442\u0432\u0443 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 \u043a \u0411\u0414 \u043d\u0435 \u043f\u0435\u0440\u0435\u0435\u0437\u0436\u0430\u044f \u043d\u0430 \u0431\u043e\u043b\u0435\u0435 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0439 \u0441\u0435\u0440\u0432\u0435\u0440 \u0438 \u0441\u043e\u0445\u0440\u0430\u043d\u0438\u0442\u044c \u0440\u0430\u0431\u043e\u0442\u043e\u0441\u043f\u043e\u0441\u043e\u0431\u043d\u043e\u0441\u0442\u044c \u0441\u0438\u0441\u0442\u0435\u043c\u044b? \u042f \u0440\u0430\u0441\u0441\u043a\u0430\u0436\u0443, \u043a\u0430\u043a \u043c\u044b \u0431\u043e\u0440\u043e\u043b\u0438\u0441\u044c \u0441 \u043f\u0430\u0434\u0435\u043d\u0438\u0435\u043c \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u0438 \u043d\u0430\u0448\u0435\u0439 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445, \u043a\u0430\u043a \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0438\u0440\u043e\u0432\u0430\u043b\u0438 SQL \u0437\u0430\u043f\u0440\u043e\u0441\u044b, \u0447\u0442\u043e\u0431\u044b \u043e\u0431\u0441\u043b\u0443\u0436\u0438\u0432\u0430\u0442\u044c \u043a\u0430\u043a \u043c\u043e\u0436\u043d\u043e \u0431\u043e\u043b\u044c\u0448\u0435 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u0439 \u0438 \u043d\u0435 \u043f\u043e\u0432\u044b\u0448\u0430\u0442\u044c \u0440\u0430\u0441\u0445\u043e\u0434\u044b \u043d\u0430 \u0432\u044b\u0447\u0438\u0441\u043b\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0435 \u0440\u0435\u0441\u0443\u0440\u0441\u044b. \u042f \u0434\u0435\u043b\u0430\u044e \u0441\u0435\u0440\u0432\u0438\u0441 \u0434\u043b\u044f \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u0431\u0438\u0437\u043d\u0435\u0441 \u043f\u0440\u043e\u0446\u0435\u0441\u0441\u0430\u043c\u0438 [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":27493,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-36704","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.0.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u041a\u0430\u043a \u0432\u044b\u0440\u0430\u0441\u0442\u0438 \u0432 10 \u0440\u0430\u0437 \u043f\u043e\u0434 \u043a\u043e\u043b\u0438\u0447\u0435\u0441\u0442\u0432\u0443 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 \u043a \u0411\u0414 \u043d\u0435 \u043f\u0435\u0440\u0435\u0435\u0437\u0436\u0430\u044f \u043d\u0430 \u0431\u043e\u043b\u0435\u0435 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0439 \u0441\u0435\u0440\u0432\u0435\u0440 \u0438 \u0441\u043e\u0445\u0440\u0430\u043d\u0438\u0442\u044c \u0440\u0430\u0431\u043e\u0442\u043e\u0441\u043f\u043e\u0441\u043e\u0431\u043d\u043e\u0441\u0442\u044c \u0441\u0438\u0441\u0442\u0435\u043c\u044b? \u042f \u0440\u0430\u0441\u0441\u043a\u0430\u0436\u0443, \u043a\u0430\u043a \u043c\u044b \u0431\u043e\u0440\u043e\u043b\u0438\u0441\u044c \u0441 \u043f\u0430\u0434\u0435\u043d\u0438\u0435\u043c \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u0438 \u043d\u0430\u0448\u0435\u0439 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445, \u043a\u0430\u043a \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0438\u0440\u043e\u0432\u0430\u043b\u0438 SQL \u0437\u0430\u043f\u0440\u043e\u0441\u044b, \u0447\u0442\u043e\u0431\u044b \u043e\u0431\u0441\u043b\u0443\u0436\u0438\u0432\u0430\u0442\u044c \u043a\u0430\u043a \u043c\u043e\u0436\u043d\u043e \u0431\u043e\u043b\u044c\u0448\u0435 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u0439 \u0438 \u043d\u0435 \u043f\u043e\u0432\u044b\u0448\u0430\u0442\u044c \u0440\u0430\u0441\u0445\u043e\u0434\u044b \u043d\u0430 \u0432\u044b\u0447\u0438\u0441\u043b\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0435 \u0440\u0435\u0441\u0443\u0440\u0441\u044b. \u042f \u0434\u0435\u043b\u0430\u044e \u0441\u0435\u0440\u0432\u0438\u0441 \u0434\u043b\u044f \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u0431\u0438\u0437\u043d\u0435\u0441 \u043f\u0440\u043e\u0446\u0435\u0441\u0441\u0430\u043c\u0438\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/optimizatsiya-zaprosov-bazy-dannyh-na-primere-b2b-servisa-dlya-stroitelej\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.0.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"sq_AL\" \/>\n\t\t<meta property=\"og:site_name\" content=\"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ud83e\udd47\u041e\u043f\u0442\u0438\u043c\u0438\u0437\u0430\u0446\u0438\u044f \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445 \u043d\u0430 \u043f\u0440\u0438\u043c\u0435\u0440\u0435 B2B \u0441\u0435\u0440\u0432\u0438\u0441\u0430 \u0434\u043b\u044f \u0441\u0442\u0440\u043e\u0438\u0442\u0435\u043b\u0435\u0439 | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041a\u0430\u043a \u0432\u044b\u0440\u0430\u0441\u0442\u0438 \u0432 10 \u0440\u0430\u0437 \u043f\u043e\u0434 \u043a\u043e\u043b\u0438\u0447\u0435\u0441\u0442\u0432\u0443 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 \u043a \u0411\u0414 \u043d\u0435 \u043f\u0435\u0440\u0435\u0435\u0437\u0436\u0430\u044f \u043d\u0430 \u0431\u043e\u043b\u0435\u0435 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0439 \u0441\u0435\u0440\u0432\u0435\u0440 \u0438 \u0441\u043e\u0445\u0440\u0430\u043d\u0438\u0442\u044c \u0440\u0430\u0431\u043e\u0442\u043e\u0441\u043f\u043e\u0441\u043e\u0431\u043d\u043e\u0441\u0442\u044c \u0441\u0438\u0441\u0442\u0435\u043c\u044b? \u042f \u0440\u0430\u0441\u0441\u043a\u0430\u0436\u0443, \u043a\u0430\u043a \u043c\u044b \u0431\u043e\u0440\u043e\u043b\u0438\u0441\u044c \u0441 \u043f\u0430\u0434\u0435\u043d\u0438\u0435\u043c \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u0438 \u043d\u0430\u0448\u0435\u0439 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445, \u043a\u0430\u043a \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0438\u0440\u043e\u0432\u0430\u043b\u0438 SQL \u0437\u0430\u043f\u0440\u043e\u0441\u044b, \u0447\u0442\u043e\u0431\u044b \u043e\u0431\u0441\u043b\u0443\u0436\u0438\u0432\u0430\u0442\u044c \u043a\u0430\u043a \u043c\u043e\u0436\u043d\u043e \u0431\u043e\u043b\u044c\u0448\u0435 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u0439 \u0438 \u043d\u0435 \u043f\u043e\u0432\u044b\u0448\u0430\u0442\u044c \u0440\u0430\u0441\u0445\u043e\u0434\u044b \u043d\u0430 \u0432\u044b\u0447\u0438\u0441\u043b\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0435 \u0440\u0435\u0441\u0443\u0440\u0441\u044b. \u042f \u0434\u0435\u043b\u0430\u044e \u0441\u0435\u0440\u0432\u0438\u0441 \u0434\u043b\u044f \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u0431\u0438\u0437\u043d\u0435\u0441 \u043f\u0440\u043e\u0446\u0435\u0441\u0441\u0430\u043c\u0438\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/optimizatsiya-zaprosov-bazy-dannyh-na-primere-b2b-servisa-dlya-stroitelej\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2019-10-31T19:13:15+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2019-10-31T19:13:15+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47 Optimizimi i k\u00ebrkesave t\u00eb baz\u00ebs s\u00eb t\u00eb dh\u00ebnave n\u00eb shembullin e nj\u00eb sh\u00ebrbimi B2B p\u00ebr nd\u00ebrtuesit | ProHoster","description":"Si t\u00eb rritet 10 her\u00eb numri i k\u00ebrkesave ndaj DB pa kaluar n\u00eb nj\u00eb server m\u00eb t\u00eb fuqish\u00ebm dhe t\u00eb ruajtur funksionalitetin e sistemit? Do t'ju tregoj se si luftuam me r\u00ebnien e performanc\u00ebs s\u00eb baz\u00ebs son\u00eb t\u00eb t\u00eb dh\u00ebnave, si optimizuam k\u00ebrkesat SQL p\u00ebr t\u00eb sh\u00ebrbyer sa m\u00eb shum\u00eb p\u00ebrdorues dhe p\u00ebr t\u00eb mos rritur shpenzimet p\u00ebr burimet llogarit\u00ebse. Un\u00eb b\u00ebj nj\u00eb sh\u00ebrbim p\u00ebr menaxhimin e proceseve t\u00eb biznesit.","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/optimizatsiya-zaprosov-bazy-dannyh-na-primere-b2b-servisa-dlya-stroitelej","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sq_AL","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u041e\u043f\u0442\u0438\u043c\u0438\u0437\u0430\u0446\u0438\u044f \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445 \u043d\u0430 \u043f\u0440\u0438\u043c\u0435\u0440\u0435 B2B \u0441\u0435\u0440\u0432\u0438\u0441\u0430 \u0434\u043b\u044f \u0441\u0442\u0440\u043e\u0438\u0442\u0435\u043b\u0435\u0439 | ProHoster","og:description":"\u041a\u0430\u043a \u0432\u044b\u0440\u0430\u0441\u0442\u0438 \u0432 10 \u0440\u0430\u0437 \u043f\u043e\u0434 \u043a\u043e\u043b\u0438\u0447\u0435\u0441\u0442\u0432\u0443 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 \u043a \u0411\u0414 \u043d\u0435 \u043f\u0435\u0440\u0435\u0435\u0437\u0436\u0430\u044f \u043d\u0430 \u0431\u043e\u043b\u0435\u0435 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0439 \u0441\u0435\u0440\u0432\u0435\u0440 \u0438 \u0441\u043e\u0445\u0440\u0430\u043d\u0438\u0442\u044c \u0440\u0430\u0431\u043e\u0442\u043e\u0441\u043f\u043e\u0441\u043e\u0431\u043d\u043e\u0441\u0442\u044c \u0441\u0438\u0441\u0442\u0435\u043c\u044b? \u042f \u0440\u0430\u0441\u0441\u043a\u0430\u0436\u0443, \u043a\u0430\u043a \u043c\u044b \u0431\u043e\u0440\u043e\u043b\u0438\u0441\u044c \u0441 \u043f\u0430\u0434\u0435\u043d\u0438\u0435\u043c \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u0438 \u043d\u0430\u0448\u0435\u0439 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445, \u043a\u0430\u043a \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0438\u0440\u043e\u0432\u0430\u043b\u0438 SQL \u0437\u0430\u043f\u0440\u043e\u0441\u044b, \u0447\u0442\u043e\u0431\u044b \u043e\u0431\u0441\u043b\u0443\u0436\u0438\u0432\u0430\u0442\u044c \u043a\u0430\u043a \u043c\u043e\u0436\u043d\u043e \u0431\u043e\u043b\u044c\u0448\u0435 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u0439 \u0438 \u043d\u0435 \u043f\u043e\u0432\u044b\u0448\u0430\u0442\u044c \u0440\u0430\u0441\u0445\u043e\u0434\u044b \u043d\u0430 \u0432\u044b\u0447\u0438\u0441\u043b\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0435 \u0440\u0435\u0441\u0443\u0440\u0441\u044b. \u042f \u0434\u0435\u043b\u0430\u044e \u0441\u0435\u0440\u0432\u0438\u0441 \u0434\u043b\u044f \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u0431\u0438\u0437\u043d\u0435\u0441 \u043f\u0440\u043e\u0446\u0435\u0441\u0441\u0430\u043c\u0438","og:url":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/optimizatsiya-zaprosov-bazy-dannyh-na-primere-b2b-servisa-dlya-stroitelej","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2019-10-31T19:13:15+00:00","article:modified_time":"2019-10-31T19:13:15+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"36704","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":"2026-01-22 04:30:19","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-03-01 01:40:22","updated":"2026-01-22 04:30:19","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/36704","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/comments?post=36704"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/36704\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media\/27493"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=36704"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=36704"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=36704"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}