Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

high volume of data failed to generate report

By
Galuh Suryono Cipto Adi
on 3/12/14, 7:20 AM 1,392 views

hi All,

Currently we have around 350,000 lines of account_move_line and 60,000 lines of account_move, and it;s increasing shortly. Those records belongs to a single partner.

my OpenERP system was failed just to generate "General Ledger" and "Partner Ledger" report from all those records. the browser is just displaying loading message with no end. All other simple reports with only few pages of PDF are fine.

my server has 6GB of RAM, 12 cores CPU, running CentOS 6 linux.

i have done openerp, postgresql and linux kernel tuning as follows:

Linux:

kernel.shmmax = 68719476739 kernel.shmall = 16777216 kernel.shmmni = 4096

Postgres:

shared_buffers = 4GB
temp_buffers = 500MB default_statistics_target = 100 maintenance_work_mem = 480MB checkpoint_completion_target = 0.9 effective_cache_size = 6GB work_mem = 50MB wal_buffers = 16MB checkpoint_segments = 64

OpenERP:

workers = 25 limit_request = 100000 osv_memory_age_limit = 1.0 limit_time_real = 240 limit_time_cpu = 600 limit_memory_hard = 6442450944 limit_memory_soft = 3221225472

but still no luck generating those reports. any help or clue will be very appreciated

thanks

0
Mind And Go
On 2/6/16, 8:53 AM

Hy

your limit_memory are too low for so much workers. I've already had this issue.

Try to multiply per 10 to see what's going on.

regards

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)

Stats

Asked: 3/12/14, 7:20 AM
Seen: 1392 times
Last updated: 2/6/16, 8:53 AM