[HACKERS] What executes faster?
Now that I've found the solution for my duplicate key problem,
I'm wondering what executes faster when I have to check for
duplicates.
1. try to update
if no row affected -> do the insert
else done
2. do a select
if row not found -> do the insert
else do the update
Another idea I'm thinking about:
I'm doing the check for duplicate key by myself now.
Aren't insert commands running faster, if I replace
an unique index by a not-unique index.
Regards, Christoph
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
