{"id":303,"date":"2007-08-24T08:20:00","date_gmt":"2007-08-24T11:20:00","guid":{"rendered":"http:\/\/helbertt.16mb.com\/site\/index.php\/2007\/08\/24\/best-practice-select-lentas-rapidas-e-super-rapidas\/"},"modified":"2007-08-24T08:20:00","modified_gmt":"2007-08-24T11:20:00","slug":"best-practice-select-lentas-rapidas-e-super-rapidas","status":"publish","type":"post","link":"https:\/\/helbertt.xyz\/site\/best-practice-select-lentas-rapidas-e-super-rapidas\/","title":{"rendered":"Best Practice: Select lentas, r\u00e1pidas e super-r\u00e1pidas."},"content":{"rendered":"<div>  <\/p>\n<p>Infelizmente nos dedicamos tanto na hora de desenvolver, que n\u00e3o nos   aprofundamos nas caracter\u00edsticas que oferecem cada ferramenta.<\/p>\n<p>  <\/p>\n<p>E as melhores pr\u00e1ticas entram exatamente ai. Neste primeiro post desta   categoria, vamos comentar sobre o uso do comando Select em uma base de dados   Mysql, que com algumas otimiza\u00e7\u00f5es podemos ter resultados bem mais r\u00e1pidos.<\/p>\n<p>  <\/p>\n<h3>Busca de Palavras<\/h3>\n<p>\/* Muito r\u00e1pida *\/<br \/>      SELECT * FROM tabela WHERE <a href=\"http:\/\/dev.mysql.com\/doc\/refman\/5.0\/es\/fulltext-search.html\" target=\"_blank\">MATCH<\/a> (`campo`) AGAINST (\u2019palavra\u2019) <\/p>\n<p>\/* R\u00e1pida *\/<br \/>      SELECT * FROM tabela WHERE MATCH (`campo`) AGAINST   (\u2019+palavra\u2019 IN BOOLEAN MODE) <\/p>\n<p>\/* Lentas *\/<br \/>      SELECT * FROM tabela WHERE <a href=\"http:\/\/dev.mysql.com\/doc\/refman\/5.0\/es\/pattern-matching.html\" target=\"_blank\">RLIKE<\/a> \u2018(^| +)palavra($| +)\u2019 <\/p>\n<p>\/* Super lenta *\/<br \/>      SELECT * FROM tabela WHERE RLIKE   \u2018([[:space:]]|[[:&lt;:]])palavra([[:space:]]|[[:&gt;:]])\u2019 <\/p>\n<h3>Busca de Conte\u00fado<\/h3>\n<p>\/* Muito r\u00e1pida *\/<br \/>      SELECT * FROM tabela WHERE MATCH (`campo`) AGAINST   (\u2019palavra*\u2019 IN BOOLEAN MODE) <\/p>\n<p>\/* R\u00e1pida *\/<br \/>      SELECT * FROM tabela WHERE FIELD LIKE \u2018palavra%\u2019 <\/p>\n<p>\/* Lentas *\/<br \/>      SELECT * FROM tabela WHERE MATCH (`campo`) AGAINST   (\u2019*palavra*\u2019 IN BOOLEAN MODE)<\/p>\n<p>\/* Super lenta *\/<br \/>      SELECT * FROM tabela WHERE campo LIKE \u2018%palavra%\u2019 <\/p>\n<h3>N\u00famero de registros<\/h3>\n<p>\/* Muito r\u00e1pida *\/<br \/>      SELECT SQL_CALC_FOUND_ROWS * FROM tabla WHERE condici\u00f3n   LIMIT 0, 10<br \/>      SELECT <a href=\"http:\/\/dev.mysql.com\/doc\/refman\/4.1\/en\/information-functions.html#function_found-rows\" target=\"_blank\">FOUND_ROWS<\/a>() <\/p>\n<p>    <\/p>\n<p>\/* R\u00e1pida *\/<br \/>      SELECT * FROM tabela WHERE condicao LIMIT 0, 10<br \/>      SELECT   COUNT(chave) FROM TABELA WHERE condicao <\/p>\n<p>  <\/p>\n<p>Fonte: <a href=\"http:\/\/www.thespanner.co.uk\/2007\/07\/23\/php-mysql-tips\" target=\"_blank\">PHP Mysql tips<\/a><\/p>\n<p><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Infelizmente nos dedicamos tanto na hora de desenvolver, que n\u00e3o nos aprofundamos nas caracter\u00edsticas que oferecem cada ferramenta. E as<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"colormag_page_container_layout":"default_layout","colormag_page_sidebar_layout":"default_layout"},"categories":[70],"tags":[],"_links":{"self":[{"href":"https:\/\/helbertt.xyz\/site\/wp-json\/wp\/v2\/posts\/303"}],"collection":[{"href":"https:\/\/helbertt.xyz\/site\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/helbertt.xyz\/site\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/helbertt.xyz\/site\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/helbertt.xyz\/site\/wp-json\/wp\/v2\/comments?post=303"}],"version-history":[{"count":0,"href":"https:\/\/helbertt.xyz\/site\/wp-json\/wp\/v2\/posts\/303\/revisions"}],"wp:attachment":[{"href":"https:\/\/helbertt.xyz\/site\/wp-json\/wp\/v2\/media?parent=303"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/helbertt.xyz\/site\/wp-json\/wp\/v2\/categories?post=303"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/helbertt.xyz\/site\/wp-json\/wp\/v2\/tags?post=303"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}