');background-repeat:no-repeat;background-position:center;background-size:18px;width:40px;height:40px;z-index:1}nav{flex-grow:1;display:flex;flex-direction:column;justify-content:center;align-items:center}nav ul{list-style:none;padding:0;margin:0}nav ul li{margin:15px 0}nav ul li a{color:#fff;text-decoration:none;font-size:18px}nav li strong{color:#ffbf00;margin-left:-2.5rem}#post-interno-ppl{width:max(90vw,100px);margin-inline:auto;overflow-x:hidden}#post-interno-ppl .interno-imagen img{margin:0;padding:0;width:100%;height:auto;background-size:cover;background-position:center;z-index:1}#post-interno-ppl .interno-contenido{top:50%;left:50%;transform:translate(0%,-2%);width:80%;margin-inline:auto;background:rgba(255,255,255,1);padding:20px;border-radius:10px;box-shadow:0 4px 10px rgba(0,0,0,.3)}.post-meta{margin-block:2rem}.post-meta p{color:#666;display:inline-block;font-family:'Lato',Helvetica,sans-serif;font-size:.75em;font-weight:900;letter-spacing:1px;line-height:200%;margin:0;text-transform:uppercase}.post-meta a{color:#8d0505;text-decoration:none}.post-content p{padding-bottom:1.5rem}.post-content p a{color:#8d0505;text-decoration:none}.post-navigation{border-top:1px solid #ddd;position:relative;margin-top:3rem}.post-navigation .group{display:flex;justify-content:space-between;padding-block:2rem}.post-nav-prev{text-align:left;width:70%}.post-nav-next{text-align:right;width:70%}.interno-contenido article h4{padding:2rem 0 1rem}.interno-contenido article p{padding-block:.5rem}blockquote{font-style:italic;color:#010021;font-weight:400;margin:0 1rem 1rem 2rem;padding:2rem 1.5rem;border-left:4px solid #ccc;font-size:1.2rem;line-height:1.4rem}.comment-respond p.comment-notes{display:none}.comment-respond p{margin-bottom:25px}.comment-respond form label{display:block;margin-bottom:8px;font-family:'Lato',Helvetica,sans-serif;font-size:.8rem;font-weight:900;text-transform:uppercase;letter-spacing:1px;color:#111}input[type=text],input[type=search]{background-color:#fafafa;border:1px solid #ddd;border-radius:0;color:#111;font-size:.9em;margin:0;padding:20px;width:100%;-moz-appearance:none;-webkit-appearance:none}input{font-family:'Lato',Helvetica,sans-serif}.comment-respond form label{display:block;margin-bottom:8px;font-family:'Lato',Helvetica,sans-serif;font-size:.8rem;font-weight:900;text-transform:uppercase;letter-spacing:1px;color:#111}.comment-respond p.comment-notes{display:none}.comment-respond p{margin-bottom:25px}@media (max-width:480px){body{top:0;left:0;font-size:14px}a{text-decoration:none}main,#post-interno-ppl{top:0;left:0;margin:0;padding:0}.ribbon{top:20px;left:-100px}.post-dos .contenido .bajada,.post-tres a .contenido .bajada,.post-cuatro a .contenido .bajada{font-size:1.4em}#post-interno-ppl{top:0;left:0;width:100svw}.interno-imagen{top:0;left:0}.img-interno-ppl{width:90%}.interno-contenido{width:90%;margin-inline:auto}.post-content p{padding-bottom:1.5rem;font-size:1.5em}.interno-contenido article p{padding-block:.5rem;width:100%}.post-inner .post-header h1{font-family:"Caveat",serif;font-optical-sizing:auto;font-weight:700;font-style:normal;font-size:3rem}}@media (min-width:790px){.post-dos .bajada,.post-tres .bajada,.post-cuatro .bajada{display:none;opacity:0;margin-top:1rem}.post-dos .bajada{font-size:1rem}.post-tres .bajada,.post-cuatro .bajada{font-size:.8rem}}ul{box-sizing:border-box}.entry-content{counter-reset:footnotes}:root{--wp--preset--font-size--normal:16px;--wp--preset--font-size--huge:42px}.screen-reader-text{border:0;clip:rect(1px,1px,1px,1px);clip-path:inset(50%);height:1px;margin:-1px;overflow:hidden;padding:0;position:absolute;width:1px;word-wrap:normal!important}:root{--wp--preset--aspect-ratio--square:1;--wp--preset--aspect-ratio--4-3:4/3;--wp--preset--aspect-ratio--3-4:3/4;--wp--preset--aspect-ratio--3-2:3/2;--wp--preset--aspect-ratio--2-3:2/3;--wp--preset--aspect-ratio--16-9:16/9;--wp--preset--aspect-ratio--9-16:9/16;--wp--preset--color--black:#000;--wp--preset--color--cyan-bluish-gray:#abb8c3;--wp--preset--color--white:#fff;--wp--preset--color--pale-pink:#f78da7;--wp--preset--color--vivid-red:#cf2e2e;--wp--preset--color--luminous-vivid-orange:#ff6900;--wp--preset--color--luminous-vivid-amber:#fcb900;--wp--preset--color--light-green-cyan:#7bdcb5;--wp--preset--color--vivid-green-cyan:#00d084;--wp--preset--color--pale-cyan-blue:#8ed1fc;--wp--preset--color--vivid-cyan-blue:#0693e3;--wp--preset--color--vivid-purple:#9b51e0;--wp--preset--gradient--vivid-cyan-blue-to-vivid-purple:linear-gradient(135deg,rgba(6,147,227,1) 0%,#9b51e0 100%);--wp--preset--gradient--light-green-cyan-to-vivid-green-cyan:linear-gradient(135deg,#7adcb4 0%,#00d082 100%);--wp--preset--gradient--luminous-vivid-amber-to-luminous-vivid-orange:linear-gradient(135deg,rgba(252,185,0,1) 0%,rgba(255,105,0,1) 100%);--wp--preset--gradient--luminous-vivid-orange-to-vivid-red:linear-gradient(135deg,rgba(255,105,0,1) 0%,#cf2e2e 100%);--wp--preset--gradient--very-light-gray-to-cyan-bluish-gray:linear-gradient(135deg,#eee 0%,#a9b8c3 100%);--wp--preset--gradient--cool-to-warm-spectrum:linear-gradient(135deg,#4aeadc 0%,#9778d1 20%,#cf2aba 40%,#ee2c82 60%,#fb6962 80%,#fef84c 100%);--wp--preset--gradient--blush-light-purple:linear-gradient(135deg,#ffceec 0%,#9896f0 100%);--wp--preset--gradient--blush-bordeaux:linear-gradient(135deg,#fecda5 0%,#fe2d2d 50%,#6b003e 100%);--wp--preset--gradient--luminous-dusk:linear-gradient(135deg,#ffcb70 0%,#c751c0 50%,#4158d0 100%);--wp--preset--gradient--pale-ocean:linear-gradient(135deg,#fff5cb 0%,#b6e3d4 50%,#33a7b5 100%);--wp--preset--gradient--electric-grass:linear-gradient(135deg,#caf880 0%,#71ce7e 100%);--wp--preset--gradient--midnight:linear-gradient(135deg,#020381 0%,#2874fc 100%);--wp--preset--font-size--small:13px;--wp--preset--font-size--medium:20px;--wp--preset--font-size--large:36px;--wp--preset--font-size--x-large:42px;--wp--preset--spacing--20:.44rem;--wp--preset--spacing--30:.67rem;--wp--preset--spacing--40:1rem;--wp--preset--spacing--50:1.5rem;--wp--preset--spacing--60:2.25rem;--wp--preset--spacing--70:3.38rem;--wp--preset--spacing--80:5.06rem;--wp--preset--shadow--natural:6px 6px 9px rgba(0,0,0,.2);--wp--preset--shadow--deep:12px 12px 50px rgba(0,0,0,.4);--wp--preset--shadow--sharp:6px 6px 0px rgba(0,0,0,.2);--wp--preset--shadow--outlined:6px 6px 0px -3px rgba(255,255,255,1),6px 6px rgba(0,0,0,1);--wp--preset--shadow--crisp:6px 6px 0px rgba(0,0,0,1)}*{margin:0;padding:0}h1,h4,p,blockquote,img,li,ul,form,label,button{margin:0;padding:0;border:0;font-size:100%;line-height:inherit;font-family:inherit;text-align:inherit}:root{--color-mas-suave:#fbfbfb;--color-suave:#e8f9ff;--color-normal:#c4d9ff;--color-oscuro:#c5baff;--color-blanco:#fff;--color-negro:#000;--color-oscuro-transparencia:rgba(197,186,255,.8)}body{font-family:"Montserrat",serif;font-optical-sizing:auto;font-weight:400;font-style:normal;word-spacing:.2rem;background-color:var(--color-mas-suave)}h1{font-family:"Caveat",serif;font-optical-sizing:auto;font-weight:700;font-style:normal;font-size:3rem}main{width:max(90vw,100px);margin-inline:auto}.comment-form-country{display:none}.ribbon{position:relative;padding:5px 45px;width:200px;top:50px;left:-70px;-webkit-transform:rotate(315deg);-moz-transform:rotate(315deg);-ms-transform:rotate(315deg);transform:rotate(315deg);box-shadow:0 0 0 3px #ff5e00;text-shadow:0 0 0 #fff;background-color:#ff5e00;color:#fff;font-size:13px;font-family:sans-serif;text-decoration:none;font-weight:700;border:2px dotted #fff;-webkit-backface-visibility:hidden;letter-spacing:.5px;z-index:6;text-align:center}.menu-button{position:fixed;top:20px;right:20px;font-size:30px;background:0 0;border:none;z-index:1000;animation:pulse 2s infinite,colorChange 8s infinite}.menu-button svg{display:block}.menu-button svg .line1,.menu-button svg .line2,.menu-button svg .line3{stroke-linecap:round}@keyframes pulse{0%{transform:scale(1);opacity:1}50%{transform:scale(1.5);opacity:.85}100%{transform:scale(1);opacity:1}}@keyframes colorChange{0%{color:red}25%{color:#ff6b6b}50%{color:#f39c12}75%{color:#e74c3c}100%{color:red}}.menu{position:fixed;top:0;right:-100%;width:300px;height:100%;background-color:#222;color:#fff;box-shadow:-2px 0 5px rgba(0,0,0,.5);z-index:999;display:flex;flex-direction:column}.menu-header{padding:20px;background-color:#333;justify-content:center;align-items:center;display:flex;flex-direction:column}.cajaformulario{position:relative;width:100%;max-width:300px}.search-form{display:flex;align-items:center}input[type=search]{padding:.5rem!important;margin:2rem .5rem 2rem 2rem!important}.search-field{width:100%;padding:10px;padding-right:40px;border:1px solid #ccc;border-radius:4px;font-size:16px}.search-submit{position:absolute;right:0;top:50%;transform:translateY(-50%);background:0 0;border:none;padding:10px;color:#fff;font-size:16px;text-indent:-9999px;background-image:url('data:image/svg+xml;utf8, ');background-repeat:no-repeat;background-position:center;background-size:18px;width:40px;height:40px;z-index:1}nav{flex-grow:1;display:flex;flex-direction:column;justify-content:center;align-items:center}nav ul{list-style:none;padding:0;margin:0}nav ul li{margin:15px 0}nav ul li a{color:#fff;text-decoration:none;font-size:18px}nav li strong{color:#ffbf00;margin-left:-2.5rem}#post-interno-ppl{width:max(90vw,100px);margin-inline:auto;overflow-x:hidden}#post-interno-ppl .interno-imagen img{margin:0;padding:0;width:100%;height:auto;background-size:cover;background-position:center;z-index:1}#post-interno-ppl .interno-contenido{top:50%;left:50%;transform:translate(0%,-2%);width:80%;margin-inline:auto;background:rgba(255,255,255,1);padding:20px;border-radius:10px;box-shadow:0 4px 10px rgba(0,0,0,.3)}.post-meta{margin-block:2rem}.post-meta p{color:#666;display:inline-block;font-family:'Lato',Helvetica,sans-serif;font-size:.75em;font-weight:900;letter-spacing:1px;line-height:200%;margin:0;text-transform:uppercase}.post-meta a{color:#8d0505;text-decoration:none}.post-content p{padding-bottom:1.5rem}.post-content p a{color:#8d0505;text-decoration:none}.post-navigation{border-top:1px solid #ddd;position:relative;margin-top:3rem}.post-navigation .group{display:flex;justify-content:space-between;padding-block:2rem}.post-nav-prev{text-align:left;width:70%}.post-nav-next{text-align:right;width:70%}.interno-contenido article h4{padding:2rem 0 1rem}.interno-contenido article p{padding-block:.5rem}blockquote{font-style:italic;color:#010021;font-weight:400;margin:0 1rem 1rem 2rem;padding:2rem 1.5rem;border-left:4px solid #ccc;font-size:1.2rem;line-height:1.4rem}.comment-respond p.comment-notes{display:none}.comment-respond p{margin-bottom:25px}.comment-respond form label{display:block;margin-bottom:8px;font-family:'Lato',Helvetica,sans-serif;font-size:.8rem;font-weight:900;text-transform:uppercase;letter-spacing:1px;color:#111}input[type=text],input[type=search]{background-color:#fafafa;border:1px solid #ddd;border-radius:0;color:#111;font-size:.9em;margin:0;padding:20px;width:100%;-moz-appearance:none;-webkit-appearance:none}input{font-family:'Lato',Helvetica,sans-serif}.comment-respond form label{display:block;margin-bottom:8px;font-family:'Lato',Helvetica,sans-serif;font-size:.8rem;font-weight:900;text-transform:uppercase;letter-spacing:1px;color:#111}.comment-respond p.comment-notes{display:none}.comment-respond p{margin-bottom:25px}@media (max-width:480px){body{top:0;left:0;font-size:14px}a{text-decoration:none}main,#post-interno-ppl{top:0;left:0;margin:0;padding:0}.ribbon{top:20px;left:-100px}.post-dos .contenido .bajada,.post-tres a .contenido .bajada,.post-cuatro a .contenido .bajada{font-size:1.4em}#post-interno-ppl{top:0;left:0;width:100svw}.interno-imagen{top:0;left:0}.img-interno-ppl{width:90%}.interno-contenido{width:90%;margin-inline:auto}.post-content p{padding-bottom:1.5rem;font-size:1.5em}.interno-contenido article p{padding-block:.5rem;width:100%}.post-inner .post-header h1{font-family:"Caveat",serif;font-optical-sizing:auto;font-weight:700;font-style:normal;font-size:3rem}}@media (min-width:790px){.post-dos .bajada,.post-tres .bajada,.post-cuatro .bajada{display:none;opacity:0;margin-top:1rem}.post-dos .bajada{font-size:1rem}.post-tres .bajada,.post-cuatro .bajada{font-size:.8rem}}
Un pequeño update – Alaluz
No es visible, pero espero que noten la mejora en la velocidad de carga. Decidí rehacer el calendario que había copiado de otro sitio por una versión propia. ¿Cuál es la diferencia? Simple. Si se fijan, los días que tienen posts aparecen resaltados y con un link, mientras que los otros aparecen sólo como texto. Esto se lograba con un loop, haciendo una consulta a la base de datos por cada día. Eso quiere decir que en cada página se hacían, sólo en el calendario, entre 30 y 31 consultas a la base de datos. ¡Por cada página y por cada carga!
Pensando en eso, y para disminuir el stress de la base de datos, cambié la filosofía del cuentito. Ahora hago una consulta que recupera todos los dias del mes que tienen algun post. Luego guardo esos días en una variable y la uso para hacer las comparaciones. El resultado es que bajo de 30-31 a 1 consulta, haciendo el proceso más rápido.
Quedó bacán
Alaluz.cl Dando jugo desde 2002