I'm not using executesql... I'm trying just:
query = q_processos.select() It seems to load all data from database... On Fri, Jul 6, 2012 at 12:40 PM, Richard Vézina <[email protected] > wrote: > 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 <[email protected]>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 < >> [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 >>>> >>> >>> >> >
