Skip to content

Booting arcadedb with a 1.1Gb database takes some time (+20s) #1890

Description

@ExtReMLapin

Hello,

ArcadeDB Version:

ArcadeDB Server v24.11.2 (build 055592c73d27d894c26f3faaf7df22e15c28f03d/1733838531445/main)

OS and JDK Version:

Running on Linux 6.8.0-49-generic - OpenJDK 64-Bit Server VM 17.0.13

Description

With this 1.1Gb database, ArcadeDB takes some time to boot up (+20s), and spams the following lines :

(Thousands of spammed lines)

WARNI [PaginatedComponentFile] <ArcadeDB_0> Unable to disable channel close on interrupt: Unable to make field private sun.nio.ch.Interruptible java.nio.channels.spi.AbstractInterruptibleChannel.interruptor accessible: module java.base does not "opens java.nio.channels.spi" to unnamed module @8909f18

Alright I understand it's not easy to debug without the database.

Data in it is confidential so I can't really share it.

(venv) pierre@cfia-IDEXTEND:/opt/arcadedb-24.2.1$ du -sh databases/CENSORED/
1,1G    databases/CENSORED/

Database stats :

db directory contains 63794 files

match (n) return count(n) -> 63276 nodes

MATCH ()-[r]->() RETURN count(r) -> 222565 edges

11 types of nodes

7839 types of edges

ls result (biggest files only) if it can you give you some indication of the base contructions : LS.txt

Notes :

During database creation and data ingestion, we went ooga booga mode, we did not create buckets, we only created Nodes types in SQL and then used them in Cypher.

Comments

Considering the database size, we're happily surprised of the execution speed of the queries. Well from a query to another, it goes from 60ms to 200ms and back down to 60ms but it's more than acceptable, again considering the DB scale.

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions