When it comes to overall performance, it's important to remember that the #1 contributor is always a good database design. The second highest contributor to performance is well-tuned SQL code.
Group items tagged
MySQL Performance Blog » ORDER BY … LIMIT Performance Optimization - 0 views
MySQL Performance Blog » Cache Performance Comparison - 0 views
MySQL Performance Blog » Covering index and prefix indexes - 0 views
MySQL AB :: Using the New MySQL Query Profiler - 1 views
-
-
But a better day has come along in MySQL 5.0.37 with the inclusion of the SQL Profiling utility. This interactive diagnostic aid allows a developer or DBA to gain insight into where a set of SQL code spends its time and the resources it is using.
PHP - 0 views
-
Continuing from my earlier post on PHP performance, I thought I'd share a few Mysql tips that I've learnt over the years. Hope it helps someone and please leave a comment with your own tips or provide any corrections to the ones mentioned.
MySQL Performance Blog » Using UNION to implement loose index scan in MySQL - 0 views
MySQL Performance Blog » SELECT LOCK IN SHARE MODE and FOR UPDATE - 0 views
MySQL Performance Blog » MySQL Master-Master replication manager released - 0 views
MySQL Performance Blog - 0 views
MySQL Performance Blog » Using index for ORDER BY vs restricting number of rows. - 0 views
MySQL Performance Blog » MySQL: Followup on UNION for query optimization, Que... - 0 views
MySQL Performance Blog » Debugging sleeping connections with MySQL - 0 views
MySQL Performance Blog » Descending indexing and loose index scan - 0 views
MySQL Performance Blog - 0 views
Two Thumbs Up For Computer Assistance Services - 3 views
I am so happy for the computer assistance that Computer Assistance Online gave me. They provided me with precise and fast solutions to my computer problem. Their computer specialists really know wh...
Great Remote Computer Repair Services - 1 views
I am very thankful that Remote PC Repair Now is here. I just do not know what I will do without them. Their remote PC repair services are the best. They totally helped me resolve my issues with...
The Best Remote PC Support I Ever Had - 1 views
The Remote PC Support Now excellent remote PC support services are the best. They have skilled computer tech professionals who can fix your PC while you wait or just go back to work or just simpl...
Certified Expert Remote PC Tech Support Provider! - 1 views
I used to have a slow computer. It would take 10 minutes to boot up and then another 10 minutes to load. It was really a big headache. Good thing I called Remote PC Repair Now . Their remote PC...