Are you running this request as raw SQL with executesql?? http://web2py.com/books/default/chapter/29/6#executesql
If your request is slow at backend level, maybe you have a problem with your design... What is your backend? Richard On Fri, Jul 6, 2012 at 11:12 AM, Marcello Parra <parro...@gmail.com> wrote: > 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 < > ml.richard.vez...@gmail.com> 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 <parro...@gmail.com> 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 >>> >> >> >