Indexing is a must-have part of performance optimization from the database side. However, sometimes, many of us create indexes that might not be best and could have other side effects instead. From the last few days of my work, I did get a chance to dig a little deeper into this area and found that there are some common techniques which we should all remember while … [Read more...] about 9 Useful Mysql Indexing Tips You Should Know About
So, are you offloading time-consuming tasks by sending them to separate distributed cloud computing instances to gain performance via the gearman job server? That's great news! What if this needs to be performed on some creation/update of new/existing MySQL database table entries? Will you run another script to track it? Of course, that is not a good solution at all. So, then … [Read more...] about 2 Useful Tips For Using Gearman From MySQL UDF
This WordPress tutorial will assist you through WordPress multisite deployment. That means you will learn to set up multiple separate root domains(as much as you want!) in a single WordPress installation and utilize a single MySQL database. You can administer and use both sites in completely separate ways.
So you don't get confused, I would like to clarify that if you are … [Read more...] about WordPress Multisite With Root Domains
So, it seems like you are in big trouble. Otherwise, why will you want to execute a doctrine native SQL query? In this tutorial, I will describe and show how you can perform such operations. But that doesn't necessarily mean I am encouraging you to use it all the time. I will still strongly recommend finding your way within the doctrine's ORM, DBAL And DQL implementation as … [Read more...] about How To Execute Native SQL Query With Doctrine
OK, As we now know how to connect to amazon EC2 instance remotely, it's time for us to go ahead one step ahead to install LAMP stack on Ubuntu EC2 server instance. We will install Apache, PHP and MySQL separately and will bind them together and get working by ourselves. Those who need help installing LAMP Stack on CentOS 7 may use the guide found on this page … [Read more...] about How To Install LAMP Stack On Ubuntu Server
var JetpackInstantSearchOptions=JSON.parse(decodeURIComponent("%7B%22overlayOptions%22%3A%7B%22colorTheme%22%3A%22light%22%2C%22enableInfScroll%22%3Atrue%2C%22enableFilteringOpensOverlay%22%3Atrue%2C%22enablePostDate%22%3Atrue%2C%22enableSort%22%3Atrue%2C%22highlightColor%22%3A%22%23FFC%22%2C%22overlayTrigger%22%3A%22submit%22%2C%22resultFormat%22%3A%22expanded%22%2C%22showPoweredBy%22%3Atrue%2C%22defaultSort%22%3A%22relevance%22%2C%22excludedPostTypes%22%3A%5B%5D%7D%2C%22homeUrl%22%3A%22https%3A%5C%2F%5C%2Fcodesamplez.com%22%2C%22locale%22%3A%22en-US%22%2C%22postsPerPage%22%3A5%2C%22siteId%22%3A18994550%2C%22postTypes%22%3A%7B%22post%22%3A%7B%22singular_name%22%3A%22Post%22%2C%22name%22%3A%22Posts%22%7D%2C%22page%22%3A%7B%22singular_name%22%3A%22Page%22%2C%22name%22%3A%22Pages%22%7D%2C%22attachment%22%3A%7B%22singular_name%22%3A%22Media%22%2C%22name%22%3A%22Media%22%7D%7D%2C%22webpackPublicPath%22%3A%22https%3A%5C%2F%5C%2Fcodesamplez.com%5C%2Fwp-content%5C%2Fplugins%5C%2Fjetpack%5C%2Fjetpack_vendor%5C%2Fautomattic%5C%2Fjetpack-search%5C%2Fbuild%5C%2Finstant-search%5C%2F%22%2C%22isPhotonEnabled%22%3Afalse%2C%22isFreePlan%22%3Atrue%2C%22apiRoot%22%3A%22https%3A%5C%2F%5C%2Fcodesamplez.com%5C%2Fwp-json%5C%2F%22%2C%22apiNonce%22%3A%22155bc22a78%22%2C%22isPrivateSite%22%3Afalse%2C%22isWpcom%22%3Afalse%2C%22hasOverlayWidgets%22%3Afalse%2C%22widgets%22%3A%5B%5D%2C%22widgetsOutsideOverlay%22%3A%5B%5D%2C%22hasNonSearchWidgets%22%3Afalse%2C%22preventTrackingCookiesReset%22%3Afalse%7D"));
