Solved

how can i speed up my database

Posted on 2011-03-15
2
427 Views
Last Modified: 2012-05-11
How can I speed up my database so things load quicker?
0
Comment
Question by:Computer Guy
2 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 125 total points
ID: 35137961
you have  to double-check the slow-running queries, with their EXPLAIN plan, if you are missing indexes eventually.
http://dev.mysql.com/doc/refman/5.0/en/explain.html

it might that some server parameter tuning can help:
http://dev.mysql.com/doc/refman/5.0/en/server-parameters.html
0
 
LVL 39

Expert Comment

by:Aaron Tomosky
ID: 35138117
If you give us a slow query we can give specific advice. Otherwise you will just get general info
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question