high volume of data failed to generate report
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:
kernel.shmmax = 68719476739 kernel.shmall = 16777216 kernel.shmmni = 4096
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
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