… following MySQL or PHP landscape you should have seen announcement by MySQL to develop pure PHP driver. If not – Here is FAQ . I’m to meet… I would appreciate to hear your ideas. Build In Profiling I would like to see how many connections and queries page generated and how long they took…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 12 Comments
…debugging and profiling tools, as…MySQL. Good design will help dictate how many tables are required in order to get the job done. To…IN() than do 100 of queries in this case. > This most applies to subqueries Where Subselects with IN…IN on your PHP application: > SELECT * FROM articles WHERE user_id IN…
Post: Caching could be the last thing you want to do
July 24, 2010 By 14 Comments
…in with a very popular PHP ecommerce package which makes me want to voice a recurring mistake I see in how…query_time=0 and use mk-query-digest to capture queries. Run them through MySQL‘s EXPLAIN command. Do your queries SELECT *, only to…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
…re just looking to see how you can get …profiling in place all you have to do is to run the query to see what are contributing factors to the response time of the problematic pages: mysql…in this case we could spend a lot of time optimizing PHP code but because it takes only 10% of response time in…
Post: Progress with ClickAider project
October 24, 2007 By 21 Comments
…profile and working out few bugs which we might have. We use GeoIP DNS based load balancing between “gathering” servers in…to do some of it for certain most common queries. At this point however we’re looking how…to register any more to see system in action. We used our MySQL…
