… queue, message parsing, search systems etc being important components besides MySQL. MySQL is important component but just a component, though due to… this case. By adding front end optimization services we are able to help to deliver great performing web sites whatever performance limiting factors…
Post: Web Site Optimization: FrontEnd and BackEnd
June 26, 2008 By 12 Comments
… “FrontEnd”. The meaning of Frontend is not the frontend web server commonly used in many architectures but rather optimization … only 10% fetching data from MySQL database it does not make sense to focus on MySQL optimization. If 90% is … signed for me to get up to speed with front end optimization.
Comment: Why do you need many apache children ?
February 17, 2008 By 15 Comments
… in each php script on a web site are optimized best, which is the optimal concurrent mysql connections in busy state? If… so. If so 100 concurrent mysql connections per second can handle 20000 queries per second. Front end queries does not include complex group by or extra file sorting at all. Of course, the optimal concurrent mysql connections…
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
…or tuning couple of MySQL settings. When low hanging fruits are fixed you end up with either … of replication, caching, using memcached, sphinx, implementing proper web caching etc. These changes are not only …new “Applet” which will be featured on the front page you quite likely start with scaled …
Comment: When should you store serialized objects in the database?
January 22, 2010 By 42 Comments
… — it typically is better done on the application end. If you have 20 web servers for each DB server, you can spread… the client version was old. Unfortunately, MySQL‘s compress/uncompress puts a length header in front of the data so you can… is doing compression, unless the app ads the length in front. You can create a stored procedure to tease the data…
