WebmasterSite.net: PHP scripts to enable your creativity
WSN Links PHP Directory Software
PHP Scripts Webmaster Links Support Forums

Register | Forgot Password

Repair / Optimize tables
When do we know if they are done?

Version: 3.20
printPrint


Repair / Optimize tables
david
Forum Regular

Usergroup: Customer
Joined: Jun 22, 2005
Total Topics: 88
Total Posts: 304
Posted 08/08/05 - 07:55 PM:
quote post
#1
Hey Paul,

How long do these functions run?

David
Paul
Administrator
Avatar

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 57
Total Posts: 6316
Posted 08/09/05 - 10:10 AM:
quote post
#2
That's entirely dependent on the size of your database. It takes a millisecond on a small database and many hours on a large database, and something in between on midrange sizes. With my largest database I prefer to run the commands directly from SSH so that I can see when it's done. (Which is not to say I run them often, probably haven't in the last 6 months at least, as on said large database is brings down the site for an annoyingly long time and I've never really been able to measure the benefits.)

"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat
Search thread for
Download thread as


You don't have permission to post.

Please login or register.

   
 
© 2008 Paul Knierim. All rights reserved.