{"id":4440,"date":"2013-09-19T19:09:30","date_gmt":"2013-09-19T17:09:30","guid":{"rendered":"http:\/\/blog.websupport.sk\/?p=4440"},"modified":"2025-03-11T21:06:20","modified_gmt":"2025-03-11T20:06:20","slug":"efektivne-na-mysql-cast-druha","status":"publish","type":"post","link":"https:\/\/www.websupport.sk\/blog\/2013\/09\/efektivne-na-mysql-cast-druha\/","title":{"rendered":"Efekt\u00edvne na MySQL, \u010das\u0165 druh\u00e1"},"content":{"rendered":"<span class=\"span-reading-time rt-reading-time\" style=\"display: block;\"><span class=\"rt-label rt-prefix\"><b>Doba \u010d\u00edtania:<\/b><\/span> <span class=\"rt-time\"> 3<\/span> <span class=\"rt-label rt-postfix\">min.<\/span><\/span><p>Dnes by sme v\u00e1m radi priniesli pokra\u010dovanie n\u00e1\u0161ho minul\u00e9ho \u010dl\u00e1nku <a href=\"https:\/\/www.websupport.sk\/blog\/\/\/2013\/06\/efektivne-na-mysql-cast-prva-2\/\" title=Efekt\u00edvne na MySQL target=\"_blank\">Efekt\u00edvne na MySQL<\/a>. V tejto druhej \u010dasti sa budeme venova\u0165 pou\u017eitiu subquery, ktor\u00fd je niekedy dobrou alternat\u00edvou k JOIN. Pr\u00e1ve nevhodn\u00e9 pou\u017eitie subquery m\u00f4\u017ee niekedy ve\u013emi ovplyvni\u0165 na\u010d\u00edtavanie d\u00e1t z va\u0161ej datab\u00e1zy.<!--more--><\/p>\n<p>Subquery sa d\u00e1 podobne ako JOIN pou\u017ei\u0165 na v\u00fdber z viacer\u00fdch tabuliek, av\u0161ak \u010dasto sa stret\u00e1vam s t\u00fdm, \u017ee je pou\u017eit\u00e9 na mieste, kde by ove\u013ea lep\u0161ie fungoval JOIN.<\/br><\/br> <\/p>\n<p><strong>O \u010do konkr\u00e9tne ide?<\/strong><\/p>\n<p>Syntax subquery je ove\u013ea zrozumite\u013enej\u0161ia pre \u201cvo\u013en\u00e9 oko&#8220;, av\u0161ak MySQL ni\u017e\u0161\u00edch verzi\u00ed m\u00e1 \u010dasto probl\u00e9m tak\u00fato query optimalizova\u0165 a vo v\u00fdsledku vykon\u00e1va zbyto\u010dne ve\u013ea \u00fakonov. Dajme si pre ilustr\u00e1ciu tak\u00fato situ\u00e1ciu:<\/p>\n<p>M\u00e1me tabu\u013eku pivo, kde je \u010d\u00edslo identifikuj\u00face to-ktor\u00e9 pivo a n\u00e1zov piva. V druhej tabu\u013eke s n\u00e1zvom bar m\u00e1me z\u00e1znamy o tom, ak\u00e9 piv\u00e1 maj\u00fa v r\u00f4znych baroch.<\/p>\n<p>\u010ci\u017ee v datab\u00e1ze s\u00fa dve tabu\u013eky: tabu\u013eka pivo so st\u013apcami  pivo.id a pivo.n\u00e1zov a tabu\u013eka foo so st\u013apcami  foo.id , foo.bar_name, foo.pivo_zn\u00e1mka a foo.pivo_id. Samozrejme, pre v\u00e4\u010d\u0161\u00ed po\u010det oper\u00e1ci\u00ed sa n\u00e1m neoplat\u00ed porovn\u00e1va\u0165 re\u0165azce znakov, ke\u010f m\u00f4\u017eeme h\u013eada\u0165 pod\u013ea \u010d\u00edsla. Hodnoty v st\u013apci pivo.id teda kore\u0161ponduj\u00fa s hodnotami foo.pivo_id  a poskytuj\u00fa prepoj medzi tabu\u013ekami.<\/p>\n<p>Ak chceme vybra\u0165 v\u0161etky bary, ktor\u00e9 maj\u00fa pivo s n\u00e1zvom &#8218;Pivo konzumn\u00e9&#8216;, m\u00e1me na v\u00fdber viacero mo\u017enost\u00ed. Syntax pr\u00edkazu JOIN je na prv\u00fd poh\u013ead mierne m\u00e4t\u00faca, preto je bli\u017e\u0161ia intuit\u00edvna mo\u017enos\u0165 so subquery.<\/p>\n<p><code>SELECT foo.bar_name, foo.pivo_zn\u00e1mka FROM bar  WHERE foo.pivo_id IN ( SELECT id FROM pivo WHERE pivo_nazov = 'Pivo konzumne' );<\/code><\/p>\n<p>Alebo vyber v\u0161etky bary a zn\u00e1mku, ktor\u00fa ich pivo dostalo, tak\u00e9, \u017ee maj\u00fa id tak\u00e9 ist\u00e9 ako tie, v ktor\u00fdch maj\u00fa pod t\u00fdmto id aj &#8218;Pivo konzumn\u00e9&#8216;. V\u00fdsledok je tak\u00fd ist\u00fd, ako keby sme zavolali:<\/p>\n<p><code>SELECT  foo.bar_name, foo.pivo_znamka FROM foo<br \/>\nINNER JOIN pivo ON foo.pivo_id=pivo_id<br \/>\nWHERE pivo.nazov='Konzumne pivo' ;<\/code><\/br><\/br> <\/p>\n<p><strong>V \u010dom je teda rozdiel?<\/strong><\/p>\n<p>Pri pou\u017eit\u00ed subquery sa pou\u017eije in\u00fd pr\u00edstup: MySQL v takomto pr\u00edpade mus\u00ed vykon\u00e1va\u0165 subquery (t.j. zisti\u0165, ak\u00fd n\u00e1zov zodpoved\u00e1 pivo_id ) pre ka\u017ed\u00fd jeden z\u00e1znam. V tomto pr\u00edpade by situ\u00e1cia nemusela by\u0165 tak\u00e1 katastrof\u00e1lna, MySQL je na preh\u013ead\u00e1vanie ve\u013ek\u00e9ho objemu rela\u010dn\u00fdch d\u00e1t stavan\u00e1, preto tak\u00fdchto oper\u00e1ci\u00ed zvl\u00e1da naraz obrovsk\u00fd po\u010det bez toho, aby sa muselo na v\u00fdsledok \u010daka\u0165. Hor\u0161ie by napr. bolo, ak by sme vyh\u013ead\u00e1vali opa\u010dne, t.j. h\u013eadali by sme pod\u013ea n\u00e1zvu piva v tabu\u013eke pivo jeho pivo_id. Ak by sme napr\u00edklad museli porovn\u00e1va\u0165 re\u0165azec dlh\u00fd 10 znakov, u\u017e by query prebehla znate\u013ene pomal\u0161ie.<\/p>\n<p>Pri pou\u017eit\u00ed syntaxe typu JOIN za pou\u017eitia indexu si vie jeho vstavan\u00fd query optimizer zjednodu\u0161i\u0165 pr\u00e1cu tak, \u017ee nevyh\u013ead\u00e1va z kartezi\u00e1nskeho s\u00fa\u010dinu, (t.j. tabu\u013eka 2 riadky, 2 st\u013apce s tabu\u013ekou 3&#215;4 d\u00e1 na spracovanie tabu\u013eku 6&#215;8), ale z indexov, a tak sa oper\u00e1cia zjednodu\u0161\u00ed na mal\u00fd po\u010det SELECT-ov medzi 2-st\u013apcov\u00fdmi medzitabu\u013ekami, a v\u00fdsledn\u00e9 preh\u013ead\u00e1vanie zaberie r\u00e1dovo menej oper\u00e1ci\u00ed. Pri tabu\u013eke s 50 z\u00e1znamami to zrejme nepoc\u00edtite, av\u0161ak po\u010det oper\u00e1ci\u00ed s rozsahom tabu\u013eky exponenci\u00e1lne rastie.<\/p>\n<p>V\u00e4\u010d\u0161ina CMS \u010di in\u00fdch webov\u00fdch aplik\u00e1ci\u00ed, vyv\u00edjan\u00fdch profesion\u00e1lnym t\u00edmom, u\u017e podobn\u00e9 muchy d\u00e1vno vychytala, to v\u0161ak nemus\u00ed plati\u0165 o tvorcoch pluginov pre ne. Tak m\u00f4\u017ee napr. widget, ktor\u00fd pon\u00faka n\u00e1hodn\u00fdch 5 produktov z ponuky pri roz\u0161\u00edren\u00ed portf\u00f3lia e-shopu, spomali\u0165 na\u010d\u00edtanie aj o nieko\u013eko sek\u00fand. Skillerom je isto jasn\u00e9, \u017ee tieto rady treba bra\u0165 s rezervou, s\u00fa iba dobr\u00fdm &#8222;rule of thumb&#8220;. Budeme v\u0161ak radi, ke\u010f v\u00e1m tieto rady aspo\u0148 trochu pom\u00f4\u017eu pri vyla\u010fovan\u00ed va\u0161ej datab\u00e1zy. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dnes by sme v\u00e1m radi priniesli pokra\u010dovanie n\u00e1\u0161ho minul\u00e9ho \u010dl\u00e1nku Efekt\u00edvne na MySQL. V tejto druhej \u010dasti sa budeme venova\u0165 pou\u017eitiu subquery, ktor\u00fd je niekedy dobrou alternat\u00edvou k JOIN. Pr\u00e1ve nevhodn\u00e9 pou\u017eitie subquery m\u00f4\u017ee niekedy ve\u013emi ovplyvni\u0165 na\u010d\u00edtavanie d\u00e1t z va\u0161ej datab\u00e1zy.<\/p>\n","protected":false},"author":33,"featured_media":5571,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,8],"tags":[526,856],"class_list":["post-4440","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technologie","category-tipy-a-triky","tag-mysql","tag-tip"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Efekt\u00edvne na MySQL, \u010das\u0165 druh\u00e1 - Websupport blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.websupport.sk\/blog\/2013\/09\/efektivne-na-mysql-cast-druha\/\" \/>\n<meta property=\"og:locale\" content=\"sk_SK\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Efekt\u00edvne na MySQL, \u010das\u0165 druh\u00e1 - Websupport blog\" \/>\n<meta property=\"og:description\" content=\"Dnes by sme v\u00e1m radi priniesli pokra\u010dovanie n\u00e1\u0161ho minul\u00e9ho \u010dl\u00e1nku Efekt\u00edvne na MySQL. V tejto druhej \u010dasti sa budeme venova\u0165 pou\u017eitiu subquery, ktor\u00fd je niekedy dobrou alternat\u00edvou k JOIN. Pr\u00e1ve nevhodn\u00e9 pou\u017eitie subquery m\u00f4\u017ee niekedy ve\u013emi ovplyvni\u0165 na\u010d\u00edtavanie d\u00e1t z va\u0161ej datab\u00e1zy.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.websupport.sk\/blog\/2013\/09\/efektivne-na-mysql-cast-druha\/\" \/>\n<meta property=\"og:site_name\" content=\"Websupport blog\" \/>\n<meta property=\"article:published_time\" content=\"2013-09-19T17:09:30+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-11T20:06:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.websupport.sk\/blog\/app\/uploads\/sites\/2\/2015\/01\/bezova_1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"290\" \/>\n\t<meta property=\"og:image:height\" content=\"380\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Franti\u0161ek Droj\u00e1k\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Autor\" \/>\n\t<meta name=\"twitter:data1\" content=\"Franti\u0161ek Droj\u00e1k\" \/>\n\t<meta name=\"twitter:label2\" content=\"Predpokladan\u00fd \u010das \u010d\u00edtania\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 min\u00faty\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.websupport.sk\\\/blog\\\/2013\\\/09\\\/efektivne-na-mysql-cast-druha\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.websupport.sk\\\/blog\\\/2013\\\/09\\\/efektivne-na-mysql-cast-druha\\\/\"},\"author\":{\"name\":\"Franti\u0161ek Droj\u00e1k\",\"@id\":\"https:\\\/\\\/www.websupport.sk\\\/blog\\\/#\\\/schema\\\/person\\\/cfe2fdf5ce9bfcd4f149370167e2eae5\"},\"headline\":\"Efekt\u00edvne na MySQL, \u010das\u0165 druh\u00e1\",\"datePublished\":\"2013-09-19T17:09:30+00:00\",\"dateModified\":\"2025-03-11T20:06:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.websupport.sk\\\/blog\\\/2013\\\/09\\\/efektivne-na-mysql-cast-druha\\\/\"},\"wordCount\":700,\"commentCount\":3,\"publisher\":{\"@id\":\"https:\\\/\\\/www.websupport.sk\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.websupport.sk\\\/blog\\\/2013\\\/09\\\/efektivne-na-mysql-cast-druha\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.websupport.sk\\\/blog\\\/app\\\/uploads\\\/sites\\\/2\\\/2015\\\/01\\\/bezova_1.png\",\"keywords\":[\"MySQL\",\"tip\"],\"articleSection\":[\"Technol\u00f3gie\",\"Tipy a triky\"],\"inLanguage\":\"sk-SK\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.websupport.sk\\\/blog\\\/2013\\\/09\\\/efektivne-na-mysql-cast-druha\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.websupport.sk\\\/blog\\\/2013\\\/09\\\/efektivne-na-mysql-cast-druha\\\/\",\"url\":\"https:\\\/\\\/www.websupport.sk\\\/blog\\\/2013\\\/09\\\/efektivne-na-mysql-cast-druha\\\/\",\"name\":\"Efekt\u00edvne na MySQL, \u010das\u0165 druh\u00e1 - Websupport blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.websupport.sk\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.websupport.sk\\\/blog\\\/2013\\\/09\\\/efektivne-na-mysql-cast-druha\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.websupport.sk\\\/blog\\\/2013\\\/09\\\/efektivne-na-mysql-cast-druha\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.websupport.sk\\\/blog\\\/app\\\/uploads\\\/sites\\\/2\\\/2015\\\/01\\\/bezova_1.png\",\"datePublished\":\"2013-09-19T17:09:30+00:00\",\"dateModified\":\"2025-03-11T20:06:20+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.websupport.sk\\\/blog\\\/2013\\\/09\\\/efektivne-na-mysql-cast-druha\\\/#breadcrumb\"},\"inLanguage\":\"sk-SK\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.websupport.sk\\\/blog\\\/2013\\\/09\\\/efektivne-na-mysql-cast-druha\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"sk-SK\",\"@id\":\"https:\\\/\\\/www.websupport.sk\\\/blog\\\/2013\\\/09\\\/efektivne-na-mysql-cast-druha\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.websupport.sk\\\/blog\\\/app\\\/uploads\\\/sites\\\/2\\\/2015\\\/01\\\/bezova_1.png\",\"contentUrl\":\"https:\\\/\\\/www.websupport.sk\\\/blog\\\/app\\\/uploads\\\/sites\\\/2\\\/2015\\\/01\\\/bezova_1.png\",\"width\":290,\"height\":380},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.websupport.sk\\\/blog\\\/2013\\\/09\\\/efektivne-na-mysql-cast-druha\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.websupport.sk\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Efekt\u00edvne na MySQL, \u010das\u0165 druh\u00e1\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.websupport.sk\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.websupport.sk\\\/blog\\\/\",\"name\":\"Websupport blog\",\"description\":\"Websupport blog\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.websupport.sk\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.websupport.sk\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"sk-SK\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.websupport.sk\\\/blog\\\/#organization\",\"name\":\"Websupport\",\"url\":\"https:\\\/\\\/www.websupport.sk\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"sk-SK\",\"@id\":\"https:\\\/\\\/www.websupport.sk\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.websupport.sk\\\/blog\\\/app\\\/uploads\\\/sites\\\/2\\\/2021\\\/08\\\/websupport-logo.svg\",\"contentUrl\":\"https:\\\/\\\/www.websupport.sk\\\/blog\\\/app\\\/uploads\\\/sites\\\/2\\\/2021\\\/08\\\/websupport-logo.svg\",\"width\":153,\"height\":48,\"caption\":\"Websupport\"},\"image\":{\"@id\":\"https:\\\/\\\/www.websupport.sk\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.websupport.sk\\\/blog\\\/#\\\/schema\\\/person\\\/cfe2fdf5ce9bfcd4f149370167e2eae5\",\"name\":\"Franti\u0161ek Droj\u00e1k\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"sk-SK\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/05e67bbfc90db9ba65ac2120122339581cadd7636782d642912823802dc16b41?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/05e67bbfc90db9ba65ac2120122339581cadd7636782d642912823802dc16b41?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/05e67bbfc90db9ba65ac2120122339581cadd7636782d642912823802dc16b41?s=96&d=mm&r=g\",\"caption\":\"Franti\u0161ek Droj\u00e1k\"},\"description\":\"Franti\u0161ek pracuje na pozici 2nd line admin.\",\"url\":\"https:\\\/\\\/www.websupport.sk\\\/blog\\\/author\\\/frantisek-drojak\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Efekt\u00edvne na MySQL, \u010das\u0165 druh\u00e1 - Websupport blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.websupport.sk\/blog\/2013\/09\/efektivne-na-mysql-cast-druha\/","og_locale":"sk_SK","og_type":"article","og_title":"Efekt\u00edvne na MySQL, \u010das\u0165 druh\u00e1 - Websupport blog","og_description":"Dnes by sme v\u00e1m radi priniesli pokra\u010dovanie n\u00e1\u0161ho minul\u00e9ho \u010dl\u00e1nku Efekt\u00edvne na MySQL. V tejto druhej \u010dasti sa budeme venova\u0165 pou\u017eitiu subquery, ktor\u00fd je niekedy dobrou alternat\u00edvou k JOIN. Pr\u00e1ve nevhodn\u00e9 pou\u017eitie subquery m\u00f4\u017ee niekedy ve\u013emi ovplyvni\u0165 na\u010d\u00edtavanie d\u00e1t z va\u0161ej datab\u00e1zy.","og_url":"https:\/\/www.websupport.sk\/blog\/2013\/09\/efektivne-na-mysql-cast-druha\/","og_site_name":"Websupport blog","article_published_time":"2013-09-19T17:09:30+00:00","article_modified_time":"2025-03-11T20:06:20+00:00","og_image":[{"width":290,"height":380,"url":"https:\/\/www.websupport.sk\/blog\/app\/uploads\/sites\/2\/2015\/01\/bezova_1.png","type":"image\/png"}],"author":"Franti\u0161ek Droj\u00e1k","twitter_card":"summary_large_image","twitter_misc":{"Autor":"Franti\u0161ek Droj\u00e1k","Predpokladan\u00fd \u010das \u010d\u00edtania":"4 min\u00faty"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.websupport.sk\/blog\/2013\/09\/efektivne-na-mysql-cast-druha\/#article","isPartOf":{"@id":"https:\/\/www.websupport.sk\/blog\/2013\/09\/efektivne-na-mysql-cast-druha\/"},"author":{"name":"Franti\u0161ek Droj\u00e1k","@id":"https:\/\/www.websupport.sk\/blog\/#\/schema\/person\/cfe2fdf5ce9bfcd4f149370167e2eae5"},"headline":"Efekt\u00edvne na MySQL, \u010das\u0165 druh\u00e1","datePublished":"2013-09-19T17:09:30+00:00","dateModified":"2025-03-11T20:06:20+00:00","mainEntityOfPage":{"@id":"https:\/\/www.websupport.sk\/blog\/2013\/09\/efektivne-na-mysql-cast-druha\/"},"wordCount":700,"commentCount":3,"publisher":{"@id":"https:\/\/www.websupport.sk\/blog\/#organization"},"image":{"@id":"https:\/\/www.websupport.sk\/blog\/2013\/09\/efektivne-na-mysql-cast-druha\/#primaryimage"},"thumbnailUrl":"https:\/\/www.websupport.sk\/blog\/app\/uploads\/sites\/2\/2015\/01\/bezova_1.png","keywords":["MySQL","tip"],"articleSection":["Technol\u00f3gie","Tipy a triky"],"inLanguage":"sk-SK","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.websupport.sk\/blog\/2013\/09\/efektivne-na-mysql-cast-druha\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.websupport.sk\/blog\/2013\/09\/efektivne-na-mysql-cast-druha\/","url":"https:\/\/www.websupport.sk\/blog\/2013\/09\/efektivne-na-mysql-cast-druha\/","name":"Efekt\u00edvne na MySQL, \u010das\u0165 druh\u00e1 - Websupport blog","isPartOf":{"@id":"https:\/\/www.websupport.sk\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.websupport.sk\/blog\/2013\/09\/efektivne-na-mysql-cast-druha\/#primaryimage"},"image":{"@id":"https:\/\/www.websupport.sk\/blog\/2013\/09\/efektivne-na-mysql-cast-druha\/#primaryimage"},"thumbnailUrl":"https:\/\/www.websupport.sk\/blog\/app\/uploads\/sites\/2\/2015\/01\/bezova_1.png","datePublished":"2013-09-19T17:09:30+00:00","dateModified":"2025-03-11T20:06:20+00:00","breadcrumb":{"@id":"https:\/\/www.websupport.sk\/blog\/2013\/09\/efektivne-na-mysql-cast-druha\/#breadcrumb"},"inLanguage":"sk-SK","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.websupport.sk\/blog\/2013\/09\/efektivne-na-mysql-cast-druha\/"]}]},{"@type":"ImageObject","inLanguage":"sk-SK","@id":"https:\/\/www.websupport.sk\/blog\/2013\/09\/efektivne-na-mysql-cast-druha\/#primaryimage","url":"https:\/\/www.websupport.sk\/blog\/app\/uploads\/sites\/2\/2015\/01\/bezova_1.png","contentUrl":"https:\/\/www.websupport.sk\/blog\/app\/uploads\/sites\/2\/2015\/01\/bezova_1.png","width":290,"height":380},{"@type":"BreadcrumbList","@id":"https:\/\/www.websupport.sk\/blog\/2013\/09\/efektivne-na-mysql-cast-druha\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.websupport.sk\/blog\/"},{"@type":"ListItem","position":2,"name":"Efekt\u00edvne na MySQL, \u010das\u0165 druh\u00e1"}]},{"@type":"WebSite","@id":"https:\/\/www.websupport.sk\/blog\/#website","url":"https:\/\/www.websupport.sk\/blog\/","name":"Websupport blog","description":"Websupport blog","publisher":{"@id":"https:\/\/www.websupport.sk\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.websupport.sk\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"sk-SK"},{"@type":"Organization","@id":"https:\/\/www.websupport.sk\/blog\/#organization","name":"Websupport","url":"https:\/\/www.websupport.sk\/blog\/","logo":{"@type":"ImageObject","inLanguage":"sk-SK","@id":"https:\/\/www.websupport.sk\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.websupport.sk\/blog\/app\/uploads\/sites\/2\/2021\/08\/websupport-logo.svg","contentUrl":"https:\/\/www.websupport.sk\/blog\/app\/uploads\/sites\/2\/2021\/08\/websupport-logo.svg","width":153,"height":48,"caption":"Websupport"},"image":{"@id":"https:\/\/www.websupport.sk\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.websupport.sk\/blog\/#\/schema\/person\/cfe2fdf5ce9bfcd4f149370167e2eae5","name":"Franti\u0161ek Droj\u00e1k","image":{"@type":"ImageObject","inLanguage":"sk-SK","@id":"https:\/\/secure.gravatar.com\/avatar\/05e67bbfc90db9ba65ac2120122339581cadd7636782d642912823802dc16b41?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/05e67bbfc90db9ba65ac2120122339581cadd7636782d642912823802dc16b41?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/05e67bbfc90db9ba65ac2120122339581cadd7636782d642912823802dc16b41?s=96&d=mm&r=g","caption":"Franti\u0161ek Droj\u00e1k"},"description":"Franti\u0161ek pracuje na pozici 2nd line admin.","url":"https:\/\/www.websupport.sk\/blog\/author\/frantisek-drojak\/"}]}},"_links":{"self":[{"href":"https:\/\/www.websupport.sk\/blog\/wp-json\/wp\/v2\/posts\/4440","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.websupport.sk\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.websupport.sk\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.websupport.sk\/blog\/wp-json\/wp\/v2\/users\/33"}],"replies":[{"embeddable":true,"href":"https:\/\/www.websupport.sk\/blog\/wp-json\/wp\/v2\/comments?post=4440"}],"version-history":[{"count":1,"href":"https:\/\/www.websupport.sk\/blog\/wp-json\/wp\/v2\/posts\/4440\/revisions"}],"predecessor-version":[{"id":33651,"href":"https:\/\/www.websupport.sk\/blog\/wp-json\/wp\/v2\/posts\/4440\/revisions\/33651"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.websupport.sk\/blog\/wp-json\/wp\/v2\/media\/5571"}],"wp:attachment":[{"href":"https:\/\/www.websupport.sk\/blog\/wp-json\/wp\/v2\/media?parent=4440"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.websupport.sk\/blog\/wp-json\/wp\/v2\/categories?post=4440"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.websupport.sk\/blog\/wp-json\/wp\/v2\/tags?post=4440"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}