OrientDB - Optimize Database

As per technical terminology Optimization means "Achieve the better possible performance in the quickest amount of time." With reference to database, optimization involves maximizing the speed and efficiency with which data is retrieved.

OrientDB supports pghtweight edges, which means a direct relation between the data entities. In simple terms, it is a field-to-field relation. OrientDB provides different ways to optimize the database. It supports the conversion of regular edges to pghtweight edges.

The following statement is the basic syntax of the Optimize database command.

OPTMIZE DATABASE [-lwedges] [-noverbose] 

Where lwedges converts regular edges into pghtweight edges and noverbose disables the output.

Example

In this example, we will use the same database named ‘demo’ that we created in the previous chapter. You can use the following optimize database command.

OPTIMIZE DATABASE -lwedges

If it is successfully executed, you will get some successful notifications along with the completion message.

Database Optimization completed in 35ms