You can translate the question and the replies:

Derby DB

Hi, We seem to be experieincing performance issues in our data catalog and its possible that this relates to Derby. Is there a way to :- 1. Check the performance 2. Optimise Derby Other suggestions / ideas would be appreciated. Regards, Lee
user
20-12-2022 02:45:46 -0500
code

1 Answer

Hi, In general, [Apache Derby database](https://community.denodo.com/kb/en/view/document/Using%20Apache%20Derby%20as%20cache?tag=Performance+%26+Optimization) embedded in Virtual DataPort can be used for testing or for small data sets but it is not recommended for large data sets or on production environments. If I experience a performance issue with the Derby Database, I would try the following approach : * Reclaim the unused space from the database using the Predefined Stored Procedure [COMPACT_METADATA_TABLES](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/stored_procedures/predefined_stored_procedures/compact_metadata_tables). To execute the Stored Procedure, you could use the below commands in the VQL shell of the Virtual DataPort Administration Tool: > CREATE PROCEDURE compact_metadata_tables > CLASSNAME ='com.denodo.vdb.contrib.storedprocedure.CompactMetatadataTablesProcedure' > CALL COMPACT_METADATA_TABLES(compaction_type : int) * Store the Data Catalog metadata in any of the supported relational databases (JDBC) as mentioned in the [Use an External Database for the Data Catalog](https://community.denodo.com/docs/html/browse/8.0/en/vdp/data_catalog/administration/servers_configuration/servers_configuration#use-an-external-database-for-the-data-catalog) section of Data Catalog Guide for more information. If the issue persists and if you are a valid support user, you could create a support case on Denodo Support Site so that our team will assist you. Hope this Helps!
Denodo Team
20-12-2022 08:05:55 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here