…approach I often use called to optimize web application performance if problem happens with few …. Just remember avoiding accessing database is the best way you can optimize database access. This applies to anything …seen people trying to join all queries in single UNION (with padding to accommodate…
Post: Are you designing IO bound or CPU bound application ?
December 20, 2006 By 10 Comments
… Performance Optimization. In fact I probably have to touch it in… database) fits in memory. What is fast when data is in…web applications. So designing your application think what kind of application are you designing ? Can you make it CPU bound/In…these rows are “random access” to large tables (so…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…optimizations in Innodb in 5.0 series. Also note the “Auto Increment Issue” is finally solved in…database, I believe different applications work best on different database brands. Oracle’s main database…
Post: Are PHP persistent connections evil ?
November 12, 2006 By 31 Comments
…MySQL than with most other databases. Not only connects are …In optimal configuration with Apache talking to local MySQL installation hand having no remote network accesses…in some tricky way it would work perfect for you. In some complex applications…ID so if you track web requests in MySQL Logs by …
