Christian Paul B. Cosinas wrote:
>
> Then I have a program that insert 1(one) million times like this:
> Insert into unique_items(item_id) values('Item001)
>
> Ofcourse we all know that it will fail because there is already a record in
> the database.
>
> Would there be any bad effect on the database or none?
No long-term effects. Obviously it takes time to run one million queries
even if they are all inserts that fail.
--
Richard Huxton
Archonet Ltd