John Dizaro wrote:
> 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
> 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 you are having problems with slow DELETEs, could it be a problem with
a foreign key that lacks an index on the referencing (rather than
referenced) column?
What do you mean by "to register 50000" ? Do you mean "affecting 50,000
rows" ?
Just how slow do you mean? Is the problem that the UPDATE or DELETE
takes a long time, or that it slows down other queries?
--
Craig Ringer
