{"id":32987,"date":"2026-05-09T17:34:31","date_gmt":"2026-05-09T17:34:31","guid":{"rendered":"https:\/\/aman-arch.com\/web2021\/?p=32987"},"modified":"2026-05-09T17:34:33","modified_gmt":"2026-05-09T17:34:33","slug":"sfinga-a-take-prokleta-scarabet-cz-matka-pro-nintendo-switch","status":"publish","type":"post","link":"https:\/\/aman-arch.com\/web2021\/sfinga-a-take-prokleta-scarabet-cz-matka-pro-nintendo-switch\/","title":{"rendered":"Sfinga a tak\u00e9 proklet\u00e1 Scarabet CZ matka pro Nintendo Switch"},"content":{"rendered":"

I kdy\u017e Sphinx ve verzi 2.1.1-beta pou\u017e\u00edv\u00e1 dvojit\u00e9 ukl\u00e1d\u00e1n\u00ed do vyrovn\u00e1vac\u00ed pam\u011bti k ukon\u010den\u00ed blokov\u00e1n\u00ed insertu. Od verze 0.1-beta a v\u00edce jsou RT pavouci kvalitn\u00ed, i p\u0159es n\u011bkolik chyb\u011bj\u00edc\u00edch prvk\u016f. P\u0159i dotazov\u00e1n\u00ed z RT indexesu m\u016f\u017eete pracovat s jak\u00fdmkoli SphinxAPI, SphinxQL nebo SphinxSE, jejich aktualizace je v sou\u010dasn\u00e9 dob\u011b mo\u017en\u00e1 pouze prost\u0159ednictv\u00edm SphinxQL. Slou\u010den\u00ed n\u011bkolika zaveden\u00fdch pavouk\u016f m\u016f\u017ee b\u00fdt efektivn\u011bj\u0161\u00ed ne\u017e pouh\u00e9 indexov\u00e1n\u00ed nov\u00fdch dat z abraze a v n\u011bkter\u00fdch p\u0159\u00edpadech to m\u016f\u017ee b\u00fdt \u017e\u00e1douc\u00ed (nap\u0159\u00edklad kombinov\u00e1n\u00ed index\u016f 'main' a 'delta' nam\u00edsto pouh\u00e9ho p\u0159eindexov\u00e1n\u00ed 'main' v sch\u00e9matu d\u011blen\u00ed 'main+delta'). Zm\u00edn\u011bno je, jak p\u0159episujeme sql_query_pre u delta zdroje. Toto by m\u011blo b\u00fdt jasn\u011b vynech\u00e1no.<\/p>\n

Rozd\u00edl mezi dotazy typu article-ask a article-list je v jednom bod\u011b, proto\u017ee post-query funguje rychleji, kdy\u017e Sphinx z\u00edsk\u00e1 v\u0161echny dokumenty, ale dal\u0161\u00ed indexov\u00e1n\u00ed m\u016f\u017ee st\u00e1le zav\u00e1hat u t\u00e9m\u011b\u0159 v\u0161ech ostatn\u00edch pot\u0159eb. V dob\u011b verze 1.1-beta m\u016f\u017eete zadat textov\u00fd trend jako n\u00e1hradu za legislativu. Nap\u0159\u00edklad, vzhledem k legislativ\u011b, by m\u011blo b\u00fdt nastaveno na z\u00e1klad\u011b seznamu \u010dl\u00e1nk\u016f pomoc\u00ed parametru charset_table. charset_table ur\u010duje novou tabulku, kterou chcete namapovat na p\u00edsmena a jejich n\u00e1zvy.<\/p>\n

Scarabet CZ – Na\u010d\u00edt\u00e1n\u00ed vy\u0161et\u0159ov\u00e1n\u00ed…<\/h2>\n

A\u0165 tak \u010di onak, z\u00e1znam je vytvo\u0159en pro probl\u00e9my a zpomal\u00edte dotazy, kter\u00e9 mohou b\u00fdt pom\u011brn\u011b vz\u00e1cn\u00e9. Podepsan\u00e9 koment\u00e1\u0159e SphinxQL jsou ji\u017e k dispozici ve form\u00e1tech Discover Scarabet CZ<\/a> , Insert a Exchange; tento seznam se pravd\u011bpodobn\u011b v budoucnu rozroste. V ka\u017ed\u00e9m p\u0159\u00edpad\u011b d\u016frazn\u011b doporu\u010duji p\u0159ej\u00edt na form\u00e1t datadir. Aby bylo zaji\u0161t\u011bno, \u017ee zaznamenan\u00e9 dotazy budou snadno a \u010dasto vyhodnocov\u00e1ny.<\/p>\n

Pennova 25 000 liber v\u00e1\u017e\u00edc\u00ed a 3 000 let star\u00e1 egyptsk\u00e1 sfinga m\u00e1 alternativn\u00ed domov<\/h2>\n

A\u017e do verze 2.0.1-beta byla poskytov\u00e1na pouze 32bitov\u00e1 bezznam\u00e9nkov\u00e1 metoda. V dob\u011b verze 2.0.2-beta mohla b\u00fdt metoda MVA bu\u010f 32bitov\u00e1 bezznam\u00e9nkov\u00e1 \u010d\u00edsla (UNSIGNED INTEGER), nebo 64bitov\u00e1 bezznam\u00e9nkov\u00e1 \u010d\u00edsla (BIGINT). \u010casto je \u017e\u00e1douc\u00ed sou\u010dasn\u011b zpracov\u00e1vat v\u00fdsledky vyhled\u00e1v\u00e1n\u00ed textov\u00fdch zpr\u00e1v nejen na z\u00e1klad\u011b voln\u00e9ho ID souboru a jeho po\u0159ad\u00ed, ale i na z\u00e1klad\u011b mnoha dal\u0161\u00edch hodnot pro ka\u017ed\u00fd soubor. \u017d\u00e1dn\u00e1 z dal\u0161\u00edch akc\u00ed dotazov\u00e1n\u00ed nen\u00ed zastaral\u00e1, nicm\u00e9n\u011b od verze 2.1-beta je SphinxQL pova\u017eov\u00e1n za nejkomplexn\u011bj\u0161\u00ed metodu. Ud\u011blejte si pr\u00e1ci s pr\u016fmyslem, ne\u017e poslat partnerovi p\u0159i\u0159azen\u00ed k dan\u00e9mu za\u0159\u00edzen\u00ed.<\/p>\n

\"Scarabet<\/p>\n

Po\u010d\u00ednaje verz\u00ed 2.0.1-beta podporuje IN() tak\u00e9 syntaxi (expr,@uservar) pro kontrolu, zda hodnota pat\u0159\u00ed k \u010d\u00edslu nab\u00edzen\u00e9ho glob\u00e1ln\u00edho \u010dlenu. To umo\u017e\u0148uje po\u017eadovat v\u00fdzkum \u010d\u00edseln\u00fdch JSON pol\u00ed. Pro v\u011bt\u0161\u00ed vzd\u00e1lenosti m\u016f\u017eete pou\u017e\u00edt GEOPOLY2D, kter\u00fd mozaikuje nov\u00fd uva\u017eovan\u00fd polygon v men\u0161\u00edch bitech s ohledem na k\u0159ivku Zem\u011b. Tyto vlastnosti byly p\u0159id\u00e1ny ve verzi 1.1-beta. Konkr\u00e9tn\u011b se jedn\u00e1 o vlastnosti agregace pol\u00ed, polo\u017eky po\u0159ad\u00ed na \u00farovni pol\u00ed a v\u00fd\u0161ky dokumentu. V\u00fdstup dotazu by se nem\u011bl zm\u011bnit, pokud vynech\u00e1te klauzuli OPTION, proto\u017ee v\u00fdchoz\u00ed ranker (PROXIMITY_BM25) se chov\u00e1 p\u0159esn\u011b tak, jak je uvedeno ve v\u00fd\u0161e uveden\u00e9m vzorci rankeru. Dobr\u00fd ranker je tak\u00e9 form\u00e1ln\u011b definov\u00e1n jako funkce, kter\u00e1 p\u0159ij\u00edm\u00e1 dokument a dotazuje se na jeho typ a generuje hodnotu hodnoty jako \u00fa\u010dinnost.<\/p>\n

St\u016fl mimo dosah informac\u00ed<\/h2>\n

Kdy\u017e se pt\u00e1te, jak to vypad\u00e1 norm\u00e1ln\u011b, m\u016f\u017eete vid\u011bt, \u017ee se chov\u00e1 jinak, proto\u017ee @annot je v na\u0161em p\u0159\u00edkladu speci\u00e1ln\u00ed anota\u010dn\u00ed kari\u00e9ra. Anotace jsou kr\u00e1tk\u00e9 fragmenty textu (a\u017e 64 token\u016f) v t\u00e9to textov\u00e9 profesi, kter\u00e9 m\u016f\u017eete pozd\u011bji p\u0159izp\u016fsobit a se\u0159adit samostatn\u011b a budete je moci sami. Sphinx v.3.5 vylep\u0161uje slu\u017ebu o nov\u00e9 pole anotac\u00ed, kter\u00e9 v\u00e1m umo\u017e\u0148uje ukl\u00e1dat do n\u011bj n\u011bkolik kr\u00e1tk\u00fdch \u201efr\u00e1z\u00ed\u201c (neboli anotac\u00ed) a pot\u00e9 je p\u0159izp\u016fsobit a m\u016f\u017eete si je sami prohl\u00e9dnout. Indexov\u011b-v\u00fd\u0161kov\u00e9 my\u0161len\u00ed je seznam 32d\u00edln\u00fdch cel\u00fdch \u010d\u00edsel (rowid\u016f) a ty jsou v\u017edy se\u0159azen\u00e9 a obvykle zhutn\u011bn\u00e9.<\/p>\n

RT znamen\u00e1 Real Time a ve skute\u010dnosti se jedn\u00e1 o \u201eplynul\u00fd re\u00e1ln\u00fd \u010das\u201c, co\u017e znamen\u00e1, \u017ee v\u011bt\u0161ina zm\u011bn adres\u00e1\u0159e je navr\u017eena tak, aby vypadala kr\u00e1tce jako 1 milisekunda nebo m\u00e9n\u011b, ale n\u011bkdy m\u016f\u017ee trvat i pouh\u00e9 sekundy. RT indexy umo\u017e\u0148uj\u00ed aplikovat dynamick\u00e9 um\u00edst\u011bn\u00ed a inkrement\u00e1ln\u00ed vylep\u0161en\u00ed pro cel\u00fd text adres\u00e1\u0159e. Omezen\u00ed \u201ejednoduch\u00e9 rekonstrukce\u201c se tedy na prvn\u00ed pohled m\u016f\u017ee jevit jako velk\u00e9 omezen\u00ed.<\/p>\n

    \n
  • D\u00e1le, pro vlastn\u00ed vyhled\u00e1v\u00e1n\u00ed ve v\u00edce indexech by se limit thesiege_max_fetched_docs rozd\u011blil mezi lok\u00e1ln\u00ed indexy (shardy) a upravil podle jejich obsahu soubor\u016f.<\/li>\n
  • Automaticky transformuje, tak\u017ee m\u016f\u017eete m\u00edt stabiln\u00ed 0, kdy\u017e nebude k dispozici \u017e\u00e1dn\u00e9 vhodn\u00e9 \u201edotazovac\u00ed\u201c slovo, Internet Explorer.<\/li>\n
  • N\u011bkdy pot\u0159ebujeme, aby se ur\u010dit\u00e9 pozice provedly rychle a z\u00e1rove\u0148 se vsadily, nebo v\u016fbec ne, a aktualizace INPLACE n\u00e1m to umo\u017e\u0148uje.<\/li>\n
  • I kdy\u017e ne, st\u00e1le mus\u00edte m\u00edt ve sv\u00e9m syst\u00e9mu nainstalovanou konkr\u00e9tn\u00ed knihovnu rider\u016f, abyste zajistili, \u017ee indexer ji bude dynamicky na\u010d\u00edtat a budete moci novou datab\u00e1zi zp\u0159\u00edstupnit.<\/li>\n<\/ul>\n

    Pro textovou zpr\u00e1vu dotazu m\u016f\u017eete ze server\u016f obnovit libovoln\u00fd po\u010det shod, kter\u00e9 maj\u00ed nejnov\u011bj\u0161\u00ed nastaven\u00ed po\u017eadavku. Celkov\u00fd po\u010det shod obnoven\u00fdch pro servery (tj. pro nastaven\u00ed efekt\u016f na stran\u011b serveru) t\u00edmto dotazem. K va\u0161emu \u00fasp\u011bchu Query() vygeneruje pole s v\u00fdsledky, kter\u00e9 obsahuje n\u011bkter\u00e9 z nalezen\u00fdch shod (od o\u010dek\u00e1van\u00fdch SetLimits()) a dal\u0161\u00ed standard pro statistiky jednotliv\u00fdch po\u017eadavk\u016f. Po\u010d\u00ednaje verz\u00ed 2.0.1-beta je poskytov\u00e1no seskupov\u00e1n\u00ed podle atribut\u016f sekvence na z\u00e1klad\u011b nejnov\u011bj\u0161\u00edho \u0159azen\u00ed.<\/p>\n","protected":false},"excerpt":{"rendered":"

    I kdy\u017e Sphinx ve verzi 2.1.1-beta pou\u017e\u00edv\u00e1 dvojit\u00e9 ukl\u00e1d\u00e1n\u00ed do vyrovn\u00e1vac\u00ed pam\u011bti k ukon\u010den\u00ed blokov\u00e1n\u00ed insertu. Od verze 0.1-beta a v\u00edce jsou RT pavouci kvalitn\u00ed, i p\u0159es n\u011bkolik chyb\u011bj\u00edc\u00edch prvk\u016f. P\u0159i dotazov\u00e1n\u00ed z RT indexesu m\u016f\u017eete pracovat s jak\u00fdmkoli SphinxAPI, SphinxQL nebo SphinxSE, jejich aktualizace je v sou\u010dasn\u00e9 dob\u011b mo\u017en\u00e1 pouze prost\u0159ednictv\u00edm SphinxQL.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"","site-content-layout":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-32987","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/aman-arch.com\/web2021\/wp-json\/wp\/v2\/posts\/32987","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aman-arch.com\/web2021\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aman-arch.com\/web2021\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aman-arch.com\/web2021\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aman-arch.com\/web2021\/wp-json\/wp\/v2\/comments?post=32987"}],"version-history":[{"count":1,"href":"https:\/\/aman-arch.com\/web2021\/wp-json\/wp\/v2\/posts\/32987\/revisions"}],"predecessor-version":[{"id":32988,"href":"https:\/\/aman-arch.com\/web2021\/wp-json\/wp\/v2\/posts\/32987\/revisions\/32988"}],"wp:attachment":[{"href":"https:\/\/aman-arch.com\/web2021\/wp-json\/wp\/v2\/media?parent=32987"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aman-arch.com\/web2021\/wp-json\/wp\/v2\/categories?post=32987"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aman-arch.com\/web2021\/wp-json\/wp\/v2\/tags?post=32987"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}