{"id":29634,"date":"2026-01-05T11:54:29","date_gmt":"2026-01-05T11:54:29","guid":{"rendered":"https:\/\/makemehappy.sk\/?post_type=product&#038;p=29634"},"modified":"2026-06-09T22:43:51","modified_gmt":"2026-06-09T20:43:51","slug":"fastsearch-sqlite","status":"publish","type":"product","link":"https:\/\/makemehappy.sk\/en\/product-2\/fastsearch-sqlite\/","title":{"rendered":"FastSearch SQLite - ultra fast product search for WooCommerce"},"content":{"rendered":"<p>FastSearch SQLite je \u0161pecializovan\u00fd vyh\u013ead\u00e1vac\u00ed plugin pre WooCommerce, ktor\u00fd od\u013eah\u010d\u00ed datab\u00e1zu WordPressu a prinesie tvojmu e\u2011shopu v\u00fdrazne r\u00fdchlej\u0161ie vyh\u013ead\u00e1vanie produktov. Namiesto klasick\u00e9ho dopytovania MySQL pou\u017e\u00edva vlastn\u00fd index v s\u00fabore SQLite, ulo\u017een\u00fd mimo hlavnej WordPress datab\u00e1zy. V praxi to znamen\u00e1 okam\u017eit\u00e9 n\u00e1vrhy produktov u\u017e po zadan\u00ed nieko\u013ek\u00fdch znakov a plynul\u00e9 fungovanie aj na zdie\u013eanom hostingu \u010di pri vysokom za\u0165a\u017een\u00ed.<\/p>\n<p>Plugin priebe\u017ene indexuje v\u0161etky publikovan\u00e9 produkty WooCommerce \u2013 n\u00e1zov, SKU, zna\u010dky, kateg\u00f3rie a pod\u013ea nastavenia aj kr\u00e1tky aj dlh\u00fd popis produktu. Text pri indexovan\u00ed normalizuje (odstra\u0148uje diakritiku, zoh\u013ead\u0148uje varianty bez medzier a poml\u010diek), v\u010faka \u010domu si vyh\u013ead\u00e1vanie porad\u00ed aj s \u201eTOP-432\u201c vs \u201etop432\u201c, r\u00f4znymi preklepmi a rozdielnym p\u00edsan\u00edm k\u00f3dov produktov. V\u00fdsledky s\u00fa trieden\u00e9 pod\u013ea relevancie \u2013 najprv produkty, ktor\u00fdch n\u00e1zov za\u010d\u00edna na zadan\u00fd v\u00fdraz, potom tie, kde sa v\u00fdraz nach\u00e1dza v strede textu.<\/p>\n<p>Z\u00e1kazn\u00edkom sa v\u00fdsledky zobrazuj\u00fa formou AJAX n\u00e1vrhov priamo pod vyh\u013ead\u00e1vac\u00edm po\u013eom \u2013 bez reloadu str\u00e1nky. Ku ka\u017ed\u00e9mu produktu vie\u0161 zobrazi\u0165 n\u00e1zov, SKU, cenu aj miniat\u00faru, pod\u013ea toho, \u010do si nastav\u00ed\u0161 v administr\u00e1cii. Okrem produktov m\u00f4\u017ee plugin pon\u00faknu\u0165 aj zodpovedaj\u00face kateg\u00f3rie a odkaz \u201eV\u0161etky v\u00fdsledky\u201c, ktor\u00fd pou\u017e\u00edvate\u013ea presmeruje na \u0161tandardn\u00fa str\u00e1nku v\u00fdsledkov WordPressu s predvolen\u00fdm alebo obmedzen\u00fdm post type (len produkty \/ cel\u00fd obsah).<\/p>\n<p>FastSearch SQLite sa dok\u00e1\u017ee pripoji\u0165 na existuj\u00face vyh\u013ead\u00e1vacie pole t\u00e9my (napr. v hlavi\u010dke) alebo ho m\u00f4\u017ee\u0161 pou\u017ei\u0165 samostatne cez shortcode [fastsearch_sqlite_search] kdeko\u013evek v obsahu. Shortcode m\u00e1 vlastn\u00e9 nastavenia vzh\u013eadu \u2013 \u0161\u00edrka, farba okraja, pozadie, farba textu aj placeholder textu \u2013 tak\u017ee ho \u013eahko prisp\u00f4sob\u00ed\u0161 dizajnu e\u2011shopu bez potreby CSS \u00faprav.<\/p>\n<p>Pre ve\u013ek\u00e9 katal\u00f3gy je pripraven\u00e1 d\u00e1vkov\u00e1 reindex\u00e1cia cez WordPress cron. Index sa vytv\u00e1ra po \u010dastiach (batch re\u017eim) bez pou\u017eitia pomal\u00e9ho OFFSET str\u00e1nkovania, tak\u017ee je vhodn\u00fd aj pre e\u2011shopy s desiatkami tis\u00edc produktov. Automatick\u00fd pl\u00e1n reindex\u00e1cie (denne, t\u00fd\u017edenne, mesa\u010dne) d\u00e1va istotu, \u017ee nov\u00e9 a upraven\u00e9 produkty s\u00fa v\u017edy zahrnut\u00e9 vo vyh\u013ead\u00e1van\u00ed bez manu\u00e1lnych z\u00e1sahov.<\/p>\n<hr \/>\n<p><strong>Hlavn\u00e9 funkcie a v\u00fdhody<\/strong><\/p>\n<ul>\n<li>Samostatn\u00fd SQLite index mimo WordPress\/MySQL (ni\u017e\u0161ia z\u00e1\u0165a\u017e datab\u00e1zy).<\/li>\n<li>Ultra r\u00fdchle AJAX n\u00e1vrhy produktov u\u017e od 2 znakov.<\/li>\n<li>Indexovanie n\u00e1zvu, SKU, zna\u010diek, kateg\u00f3ri\u00ed, volite\u013ene short\/long popisov.<\/li>\n<li>Inteligentn\u00e1 normaliz\u00e1cia textu.<\/li>\n<li>Relevan\u010dn\u00e9 radenie: n\u00e1zov za\u010d\u00edna v\u00fdrazom \u2192 n\u00e1zov obsahuje v\u00fdraz \u2192 ostatn\u00e9 zhody.<\/li>\n<li>Zobrazenie kateg\u00f3ri\u00ed pred produktmi + mo\u017enos\u0165 filtrova\u0165 len na hlavn\u00e9 kateg\u00f3rie.<\/li>\n<li>Volite\u013en\u00e9 zobrazovanie ceny a miniat\u00fary u\u017e priamo v n\u00e1vrhoch.<\/li>\n<li>N\u00e1vrhy opraven\u00e9ho\/alternat\u00edvneho v\u00fdrazu pod\u013ea titulkov n\u00e1jden\u00fdch produktov.<\/li>\n<li>Napojenie na vyh\u013ead\u00e1vanie t\u00e9my (input[type=&#8220;search&#8220;]) alebo vlastn\u00fd shortcode.<\/li>\n<li>Plne konfigurovate\u013en\u00fd vzh\u013ead shortcode vyh\u013ead\u00e1vacieho po\u013ea.<\/li>\n<li>Manu\u00e1lna aj automatick\u00e1 reindex\u00e1cia (cron) s d\u00e1vkov\u00fdm spracovan\u00edm.<\/li>\n<li>Slovensk\u00e9 administra\u010dn\u00e9 rozhranie a nastavenia priamo v WooCommerce menu.<\/li>\n<li>Bez z\u00e1vislosti na extern\u00fdch indexovac\u00edch slu\u017eb\u00e1ch \u2013 v\u0161etko be\u017e\u00ed na tvojom hostingu.<\/li>\n<\/ul>\n<hr \/>\n<p><strong>R\u00fdchlos\u0165 a v\u00fdkon vyh\u013ead\u00e1vania (sekcia, ktor\u00fa m\u00f4\u017ee\u0161 prida\u0165 na str\u00e1nku)<\/strong><\/p>\n<p>FastSearch SQLite je navrhnut\u00fd prim\u00e1rne pre v\u00fdkon. Namiesto zlo\u017eit\u00fdch JOIN dopytov do WordPress datab\u00e1zy pracuje s kompaktnou tabu\u013ekou v SQLite, optimalizovanou len na vyh\u013ead\u00e1vanie. Pri ka\u017edom AJAX dopyte sa prebehne len jeden \u013eahk\u00fd SELECT nad predpripraven\u00fdm indexom a WordPress nemus\u00ed na\u010d\u00edtava\u0165 cel\u00e9 objekty produktov, v\u00fdpo\u010det ceny ani obr\u00e1zkov \u2013 tie s\u00fa ulo\u017een\u00e9 u\u017e pri indexovan\u00ed.<\/p>\n<p>V praxi to znamen\u00e1:<\/p>\n<ul>\n<li>odozvu n\u00e1vrhov r\u00e1dovo v desatin\u00e1ch sekundy aj pri v\u00e4\u010d\u0161\u00edch katal\u00f3goch,<\/li>\n<li>stabiln\u00e9 spr\u00e1vanie pri \u0161pi\u010dke (ve\u013ea s\u00fabe\u017en\u00fdch dopytov),<\/li>\n<li>lep\u0161iu plynulos\u0165 cel\u00e9ho e\u2011shopu, preto\u017ee server nie je zahlten\u00fd pomal\u00fdm vyh\u013ead\u00e1van\u00edm.<\/li>\n<\/ul>\n<p>D\u00e1vkov\u00e1 reindex\u00e1cia pou\u017e\u00edva tzv. \u201ekeyset paging\u201c (ID &gt; last_id), tak\u017ee ani pri opakovan\u00fdch spusteniach nebrzd\u00ed datab\u00e1zu \u0165a\u017ek\u00fdmi OFFSET dopytmi. V kombin\u00e1cii s pl\u00e1novanou reindex\u00e1ciou m\u00e1\u0161 index v\u017edy aktu\u00e1lny bez ru\u010dn\u00e9ho z\u00e1sahu a bez v\u00fdpadkov vyh\u013ead\u00e1vania.<\/p>\n<p>R\u00fdchlos\u0165 index\u00e1cie bola testovan\u00e1 na zdie\u013eanom hostingu. Pri 49 000 produktoch index\u00e1cia zabrala cca 110min\u00fat.<\/p>\n<p>&nbsp;<\/p>\n<p>Plugin je mo\u017en\u00e9 <a href=\"https:\/\/demo.makemehappy.sk\" target=\"_blank\" rel=\"noopener\">otestova\u0165 tu<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pon\u00fakame mo\u017enos\u0165 otestova\u0165 plugin na 5 dn\u00ed. V pokladni pou\u017eite kup\u00f3n <code>happy-product-test<\/code><\/p>","protected":false},"featured_media":29644,"comment_status":"open","ping_status":"closed","template":"","meta":{"_gspb_post_css":""},"product_brand":[],"product_cat":[29],"product_tag":[],"class_list":["post-29634","product","type-product","status-publish","has-post-thumbnail","product_cat-ostatne","first","instock","downloadable","virtual","taxable","purchasable","product-type-simple"],"_links":{"self":[{"href":"https:\/\/makemehappy.sk\/en\/wp-json\/wp\/v2\/product\/29634","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/makemehappy.sk\/en\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/makemehappy.sk\/en\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/makemehappy.sk\/en\/wp-json\/wp\/v2\/comments?post=29634"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/makemehappy.sk\/en\/wp-json\/wp\/v2\/media\/29644"}],"wp:attachment":[{"href":"https:\/\/makemehappy.sk\/en\/wp-json\/wp\/v2\/media?parent=29634"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/makemehappy.sk\/en\/wp-json\/wp\/v2\/product_brand?post=29634"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/makemehappy.sk\/en\/wp-json\/wp\/v2\/product_cat?post=29634"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/makemehappy.sk\/en\/wp-json\/wp\/v2\/product_tag?post=29634"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}