Temp Projects

Taking one minutes to generate report with the single barcode.Pleas advice.

Please find the attached screenshot for the reference.

Suhail, did you check this?

please update the status.

It's taking 20 Seconds to search a single item

Please check by item name, description, group and category search.

Still the report is slow, Please resolve immediately this is an important screen for us.

Please retrieve the hardware spec of EURO central server

Amal

Please do the needful.

Architecture: x86_64
CPU op-mode(s): 32-bit, 64-bit
Byte Order: Little Endian
Address sizes: 46 bits physical, 48 bits virtual
CPU: 8
On-line CPU list: 0-7
Thread(s) per core: 1
Core(s) per socket: 8
Socket(s): 1
NUMA node(s): 1
Vendor ID: GenuineIntel
CPU family: 6
Model: 79
Model name: Intel(R) Xeon(R) CPU E5-2609 v4 @ 1.70GHz
Stepping: 1
CPU MHz: 1697.977
CPU max MHz: 1700.0000
CPU min MHz: 1200.0000
BogoMIPS: 3395.95
Virtualization: VT-x
L1d cache: 32K
L1i cache: 32K
L2 cache: 256K
L3 cache: 20480K
NUMA node0 CPU: 0-7

os - openSUSE Leap

RAM - 15G
SWAP - 4.0G

Amal

Please update the status.

posibolt java memory increased to 4GB.

ADEMPIERE_JAVA_OPTIONS=-Xms1024M -Xmx4090M.

also test server stopped.

Visited the office and advice to change the RAM.

We increased RAM 32 GB in our server. As per checking currently taking 19 Seconds to search one item from Stock position report [Previous it was 23 Sec]. Please check and let us know if there are ways to improve performance.

Please check this issue

Jidhin

Please share the slow running queries with dev team.Also share posibolt JAVA memory.

Expensive Queries of more than 5,000 ms is Attached

Current ram : 46Gb
Java memmory : ADEMPIERE_JAVA_OPTIONS=-Xms1024M -Xmx4090M

Sharil, Did we update the postgres and posibolt memory after upgrading RAM?

Danish

Please check and update.

Noufalka,
Postgres Tuning is done for accounting for 10GB RAM,Meanwhile the system has 46GB of Total RAM.

Sharilka,
Should I tune the database for 30GB RAM since both Adempieres uses 6GB RAM and I am leaving 10GB for system functions.

make postgres 12 GB and 10 GB to Posibolt live.

Shabeer,
I have tuned postgres for 12GB RAM ,you just need to restart database and allocate 10GB to live server after shop hours today.

Euro live posibolt memory increased 10GB.

ADEMPIERE_JAVA_OPTIONS=-Xms1024M -Xmx10240M -Djava.library.path\=/usr/local/apr/lib/ -Dorg.apache.jasper.Constants.DEFAULT_TAG_BUFFER_SIZE\=2048 -Dorg.apache.jasper.runtime.BodyContentImpl.LIMIT_BUFFER\=true -XX\:+HeapDumpOnOutOfMemoryError

.Also restarted postgres

Muzammil

Please verify the report from your side.

Rijas,
Please check from your side.