how i can finish an ad hoc view with an combination of tables with more than 16millon registers

0

I have a issuewhen i try to create an ad hoc view with more than a 16m registers my jaspersoft just freeze here is the table structure

 

tiempo_id numeric(8,0),

nro_doc character varying(15) COLLATE pg_catalog."default",

tipo_doc_id smallint,

oficina_id integer,

nro_cuenta numeric(16,0),

tipo character varying(10) COLLATE pg_catalog."default",

moneda_id smallint,

cambio_me numeric(9,3),

monto_orig numeric(19,2),

monto_gs numeric(19,2),

sucursal_id integer,

cc smallint,

scc smallint,

cc_scc_id integer,

cantidad smallint

usign postgres 9.6 

drupal7_anonymous's picture
drupal7_anonymous

1 Answer:

0

I'm processing 12 million record in this video and getting realtime performance. Try increasing memory and tuning your database.

https://www.youtube.com/watch?v=-xtB_w0520w

hozawa's picture
64916
Joined: Apr 24 2010 - 4:31pm
Last seen: 1 year 3 months ago
Feedback
randomness