Jump to content
Changes to the Jaspersoft community edition download ×

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


Recommended Posts

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 

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...