V4RB, 4.9.1

[Ruslan Zasukhin]

On 5/9/12 1:48 PM, "Christian - ChrisKatDev.com" <christian at chriskatdev.com>
wrote:

Hi Christian, 

> A) Do you have sql command for OPTIMIZE db ?

no
 
> B) What is the best :
> 
> 1) reindex
> 2) defragment
> 3) compact
> 
> OR
> 
> 1) defragment
> 2) compact
> 3) reindex

Best for what?  For size or speed? :)

If db was teased by intensive add/remove/update
Then db.clone can be good and enough.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]