Basic Request Optimization (WooCommerce)
Website HTTPS://bit.ly/3shGiai
Hosting Ukraine, Tariff Business 32
Filter plugins: HUSKY (WOOF) - turbo mode
Multi-language plugin WP Multilang (now only one language)
Woocommerce translated into HPOS
Minimum task: optimize the filter work in the catalogue (create slow requests)
Maximum task: correctly set up and cache on hosting
Complete requests at this time:
Here are the details of the longest request:SELECT
by wp_posts.ID
From
by wp_posts
LEFT JOIN wp_postmeta ON (
wp_posts.ID = wp_postmeta.post_id
AND wp_postmeta.meta_key = '_languages'
( The
LEFT JOIN wp_postmeta AS mt1 ON (wp_posts.ID = mt1.post_id)
LEFT JOIN wp_postmeta AS postmeta ON (wp_posts.ID = postmeta.post_id)
WHERE
1 = 1
and (
Wp_posts.ID NOT IN (
Select
The object_id
From
WP_term_relationships
WHERE
term_taxonomy_id IN (6, 7)
( The
( The
and (
( The
wp_postmeta.post_id is zero
or (
mt1.meta_key = '_languages'
AND mt1.meta_value LIKE '%s:2:\"uk\";%'
( The
( The
( The
AND wp_posts.post_type = 'product'
and (
(wp_posts.post_status = ‘publish’ )
( The
and (
( The
( The
wp_posts.post_title LIKE '%Bakuchiol%'
( The
or (
wp_posts.post_excerpt LIKE '%Bakuchiol%'
( The
or (
wp_posts.post_content LIKE '%Bakuchiol%'
( The
or (
postmeta.meta_key = '_sku'
AND postmeta.meta_value LIKE '%Bakuchiol%'
( The
( The
( The
Group by
by wp_posts.ID
Order by
wp_posts.post_date
-
На сервері активуйте Redis і встановіть https://uk.wordpress.org/plugins/redis-cache/
Буде кешувати запити до БД.
-
Ihor Kit MORKVA
Наразі основний домен повернув до старої конфігурації:
фільтр premmerce,
WooCommerce без HPOS.
Redis увімкнув.
Але питання оптимізації залишається відкритим, вірю що можна ще якось дооптимізувати сайт вцілому.
Поки підозра падає на:
плагін багатомовності, плагін фільтру HUSKY -
Current freelance projects in the category Databases & SQL
A Senior Flutter + Backend developer is required to create an MVP for a startup (similar to Uber for household services).
223 USD
Looking for an experienced developer (or a small team) to create an MVP mobile application — a service for urgent calls to specialists similar to Uber, Uklon. Development needed: • mobile application for iOS and Android (Flutter); • server part (REST API); • admin panel; •… Databases & SQL, Hybrid Mobile Apps ∙ 9 hours 47 minutes back ∙ 21 proposals |
Database parsing
45 USD
Channel requirements: 1. Content language: Russian or Ukrainian (mixed RU/UA content is allowed) 2. Number of subscribers: At least 500 subscribers 3. Activity: The last post published no later than 32 hours ago 4. Comments: Comments must be open under the posts (through a group… Databases & SQL, Data Parsing ∙ 1 day 15 hours back ∙ 32 proposals |
It is necessary to check the scripts and update the data in the Postgres database.It is necessary to correct the SQL scripts for the Postgres database. It is required to check the scripts and update data from external Excel tables and between two Postgres databases (different servers). Scripts will be run through AnyDesk using Navicat. List of data for… Databases & SQL ∙ 4 days 18 hours back ∙ 18 proposals |
Need an Airtable architect to build a relational schema and a new clean Airtable base.Need help rethinking and building a clean relational schema for an internal operational system on Airtable. The current database is already in use by the team, but it has grown organically: the structure is partially flat, some tables/views are actively used, while others are… Databases & SQL, Desktop Apps ∙ 5 days 11 hours back ∙ 10 proposals |
Basketball Coaching Education Platform + Custom CMSBasketball Coaching Education Platform + Custom CMSProject Overview We are looking for an experienced web development team or full-stack developer to build a modern basketball coaching education platform. The website will provide basketball coaches with access to educational… Databases & SQL, Web Programming ∙ 6 days 5 hours back ∙ 93 proposals |
Lvov