… (normally only fraction of your database) fits in memory. What is … than you should target for web applications. So designing your application … have very sharp performance drop and complex changes may be required to … – count queries, group by, order by without indexes, search queries etc. Basically …
Post: Are PHP persistent connections evil ?
November 12, 2006 By 32 Comments
…with MySQL than with most other databases. Not only connects are expensive …get with just few queries concurrently. If you have these queries doing large sorts… spend enough time to optimize Web part of configuration. Thousands of …work perfect for you. In some complex applications it however can lead …
Post: Intro to OLAP
July 12, 2010 By 10 Comments
…queries and the kind of SQL which a ROLAP tool must generate to answer those queries. Performance challenges with larger databases…name. Probably the most popular BI activity for web sites is click analysis. As far as …to keep the tables updated and in the complexity of the many scripts or jobs which …
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
…you to get a lot of data in. Many Web 2.0 sites in particular design for having …replication delay or speeding up this 3 hours reporting query or 5 hours ALTER TABLE command. Let me … lot of pieces – filesystem, disk scheduling, database buffer management can be rather complex but you need to have at …
Post: FaceBook Search, Search for social networks
August 12, 2007 By 4 Comments
… the documents which becomes bottleneck. Working with database instead of with web documents has another benefit – you instantly … sure Sphinx can be used efficiently to perform queries going beyond full text search. Such as finding… 50 miles from given zip code matching some complex set set of …
