Hello, Richard,
I save 2 HTML pages. SELECT processo.id, processo.na, processo.na_limpo, processo.nu, processo.nu_limpo, processo.html, processo.html1, processo.processado, processo.processado2, processo.processado_dia, processo.origem, processo.classe, processo.fase, processo.assunto, processo.instancia, processo.json, processo.conferido, processo.autuado_dia, processo.orgao_julgador, processo.relator, processo.autor, processo.reu, processo.advs, processo.autor1, processo.reu1, processo.acompanhando_dia, processo.encerrado_dia, processo.vara, processo.numero_origem, processo.ultimo_andamento_dia, processo.ultimo_andamento, processo.sentenca, processo.sentenca_dia, processo.sentenca_crc, processo.1_crc, processo.2_crc, processo.enviado_dia, processo.created_at FROM processo WHERE (processo.encerrado_dia IS NULL); One solution is select just the fields I need and not the TEXT ones... But I found that should be an easier way.... Thanks... On Fri, Jul 6, 2012 at 10:30 AM, Richard Vézina <[email protected] > wrote: > What the nature of the data in size? > > Could you show us your select statment? > > Richard > > > On Fri, Jul 6, 2012 at 8:41 AM, Marcello <[email protected]> wrote: > >> Hello all, >> >> I have a table with two text fields. >> I'm trying to make a select with about 7,000 records in a console. >> My memory goes up, until full, and then the process is killed.... >> >> If I comment those text fields in the table definition and try again, it >> run the select without problem. >> >> In the select, I don't use those fields.... >> >> What cat I do to solve this ?? >> >> >> Thanks >> Marcello >> > >
