Tuning and making reliable for server

#1
For production , sometimes we modify entities.
We use this config on production for 128GB Ram server its too low ?
with 48 Core
How to increase performance more ?

Also chatgpt suggested to use this for auto update entities but when i add it , it crashes.
ObjectDB doesnt let these params :
<objectdb>
    <property name="objectdb.h2f" value="auto"/>
    <property name="objectdb.schema.auto" value="true"/>
</objectdb>

<objectdb>
    <general>
        <!-- Keep logs small and fast -->
        <temp path="$temp/ObjectDB" threshold="128mb" />
        <network inactivity-timeout="0" />
        <url-history size="100" user="true" password="true" />
        <log path="$objectdb/log/" max="16mb" stdout="true" stderr="false" />
        <log-archive path="$objectdb/log/archive/" retain="120" />
        <logger name="*" level="error" />
    </general>

    <database>
        <!-- Small pages give more granular caching; larger ones reduce overhead -->
        <size initial="1mb" resize="512kb" page="4kb" />
        <recovery enabled="true" sync="false" path="." max="256mb" />
        <recording enabled="false" sync="false" path="." mode="write" />
        <locking version-check="true" />
        <processing cache="256mb" max-threads="16" synchronized="true" />
        <query-cache results="128mb" programs="2000" />
        <extensions drop="temp,tmp" />
        <activation code="xxxx-xxxx-xxxx-xxxx-xxxx" />
    </database>

    <entities>
        <!-- Strong cache keeps entities in memory until eviction -->
        <enhancement agent="true" reflection="warning" />
        <cache ref="strong" level2="512mb" />
        <persist serialization="false" />
        <cascade-persist always="auto" on-persist="false" on-commit="true" />
        <dirty-tracking arrays="true" />
    </entities>
</objectdb>
#2

These settings do not appear to exist (likely a ChatGPT hallucination).
128 GB should be sufficient as long as your database is smaller than that.
To optimize performance, you’ll need actual profiling data.

ObjectDB Support
#3

How to optimize further so ? 

#4

It’s difficult to suggest optimizations based on the information provided, since every application has different performance characteristics. If there are specific operations that are not fast enough and you’re looking to optimize them, please share more details, such as the queries (or other operations) involved, how frequently they are executed, and any performance data from a profiler or heap dump.

Regarding the ChatGPT suggestions: ObjectDB does not support such properties. Could you clarify what you are trying to achieve with the auto-update behavior?

ObjectDB Support

Reply