Re: [SQL] UPDATE and DELEte with a lot of register is to slow...

O Problema é tem tenho uma tabela muito grande com chave primaria e tudo mais... e quando eu vou fazer uma atualização de alguns campos desta tabela o banco fica devagar estou procurando algum comando que me permita atualizar os registros aos poucos por exemplo uma tabela com 100 000 atualiza-l

Re: [SQL] UPDATE and DELEte with a lot of register is to slow...

The problem is ... how to run the SCRIPT to the few? not all the 5 lines of "update" at the same time. John Evan Dizaro 2008/11/20 John Dizaro <[EMAIL PROTECTED]> > I have to execute some times an UPDATE an some times a DELETE to > register +- 5 , every time when i do that the dat

Res: [SQL] UPDATE and DELEte with a lot of register is to slow...

did you make analyse(vacuum ) in you database? De: Craig Ringer <[EMAIL PROTECTED]> Para: John Dizaro <[EMAIL PROTECTED]> Cc: pgsql-sql@postgresql.org Enviadas: Quinta-feira, 20 de Novembro de 2008 8:29:55 Assunto: Re: [SQL] UPDATE and DELEte w

Re: [SQL] UPDATE and DELEte with a lot of register is to slow...

John Dizaro wrote: I have to execute some times an UPDATE an some times a DELETE to register +- 5 , every time when i do that the database be to slow do we any way to DELETE or UPDATE by part??? I'm not sure your post really contains enough information to answer your question. If

[SQL] UPDATE and DELEte with a lot of register is to slow...

I have to execute some times an UPDATE an some times a DELETE to register +- 5 , every time when i do that the database be to slow do we any way to DELETE or UPDATE by part??? Thanks -- John Evan Dizaro -