Answered Question

timcadieu...

M¢25 Funded By Mahalo ? | June 24, 2009 09:01 PM

mySQL, is it possible to compact the db?

I have a 25 meg mySQL database that runs fairly quickly on my laptop, but running the same code on the server take about 6x longer? I was wondering what I should be looking at?

I've created the same indexes?

Interesting Question? Yes (0) No (0)

In Programming |
Tags: database, php, mysql |
|
Report |
Share

RSS

Best Answer Decided by Votes

socalsue

July 17, 2009 10:58 PM

Have you had the opportunity to measure the performance directly at the server, eliminating the network delays? If the slow down is definitely at the server, you want to look at what other processes you are competing with for cpu, memory and disk access. It is possible your little database got stuck on a busy drive or one that is severely fragmented, or that the server is just so busy your process is competing for run-time.

Helpful Answer?

(0)

(0) Tip socalsue for this answer

Permalink | Report

Voted as best: wdawe, dannyjohnson, girlieq3000

Answer this Question

Ask a Question

Top of Page

Buy Mahalo Dollars with Credit Card or PayPal

Top Members

This Week All Time

buddawiggi
2nd Degree Black Belt
28354 Points
M$813.91 Earned
opher
Purple Belt with a Brown Tip
5119 Points
M$210.34 Earned
annelisle
Purple Belt
3596 Points
M$110.02 Earned

See All

Most Popular Tags

mahalo(1707)

twitter(965)

music(485)

iphone(476)

google(374)

food(331)

internet(309)

online(306)

beer(282)

money(276)

movies(270)

apple(255)

facebook(245)

answers(235)

aotd(235)

health(225)

video(213)

free(210)

dog(207)

windows(200)

See All

Welcome New Members

meganann415, December 04, 2009 05:39 PM
acecowboy55555, December 04, 2009 05:37 PM
miraclesolarisk..., December 04, 2009 05:37 PM
chriswalbert, December 04, 2009 05:33 PM
xtanner15x, December 04, 2009 05:33 PM

Mahalo Dollars are the currency of Mahalo Answers.

Each Mahalo Dollar costs $1.

Once you earn more than 40 Mahalo Dollars, you can request to be paid via PayPal. Each Mahalo Dollar is currently worth $0.75 when paid out via PayPal. Learn More