Thanks Ingo, we will go through the below pointers. Appreciate it.
On Tue, Apr 23, 2024 at 11:24 AM Ingo Wolfmayr <ingo.wolfm...@wolfix.at> wrote: > Hi Mk, > > I recommend checking the following points first: > > 1. Database Optimization: > Indexes: Ensure that your database tables are properly indexed. Missing > indexes can dramatically slow down query performance. > Query Analysis: Use tools like slow query logs to identify inefficient > queries and optimize them. > Connection Pooling: Verify that your database connection settings are > optimized for your usage pattern. > > For mysql/mariadb I use: https://github.com/major/MySQLTuner-perl for > performance recommendations > > 2. Server and JVM Tuning: > Memory Allocation: Increase the JVM heap size if necessary. This is > especially important if you are experiencing OutOfMemoryErrors. > Garbage Collection: Optimize garbage collection parameters to reduce > overhead. Tools like VisualVM can help monitor garbage collection and tweak > settings. > > 3. OFBiz Configuration: > Thread Pools: Adjust the size of thread pools in OFBiz to match your > server’s hardware capabilities. > Service Engine: Review the service engine configuration for performance > bottlenecks. > > Best regards > Ingo > > -----Ursprüngliche Nachricht----- > Von: Mandar K <mankul...@gmail.com> > Gesendet: Dienstag, 23. April 2024 06:51 > An: user@ofbiz.apache.org > Betreff: Performance issues > > Hi All, > > In a recent switchover to Ofbiz we are observing performance issues where > almost all the application is running very slow. > > Please give pointers which will give breakthrough. Thanks for your > inputs, much appreciated. > > > Regards > Mk > -- Regards Mandar Kulkarni Adaptability is the whole mystery of life - Swami Vivekanand