Re: UPDATE and DELEte with a lot of register is to slow...
| От | John Dizaro |
|---|---|
| Тема | Re: UPDATE and DELEte with a lot of register is to slow... |
| Дата | |
| Msg-id | 11c2d5210811210434x153a20c0j95c01ebbaecaf70a@mail.gmail.com обсуждение исходный текст |
| Ответ на | UPDATE and DELEte with a lot of register is to slow... ("John Dizaro" <jedsoftware@gmail.com>) |
| Список | pgsql-sql |
The problem is ...<br /><div dir="ltr" id="result_box" style="text-align: left;"><div dir="ltr" id="result_box" style="text-align:left;">how to run the SCRIPT to the few? <br />not all the 50000 lines of "update" at the same time.<br/> John Evan Dizaro<br /></div></div><br /><br /><div class="gmail_quote">2008/11/20 John Dizaro <span dir="ltr"><<ahref="mailto:jedsoftware@gmail.com">jedsoftware@gmail.com</a>></span><br /><blockquote class="gmail_quote"style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> I have to execute some times an UPDATE an some times a DELETE to register +- 50000 , every time when i do that the database be to slow <br />do we any way to DELETE or UPDATE by part???<br />Thanks<br clear="all" /><font color="#888888"><br/> -- <br /> John Evan Dizaro - <br /><br /><br /></font></blockquote></div><br /><br clear="all" /><br/>-- <br />John Evan Dizaro Software - <br />Fone: (41) 3333-0303<br />Fone: (41) 9243-3240<br />Rua: Alferes Poli Curitiba- PR - Brasil<br />
В списке pgsql-sql по дате отправления: