Hi all,
my situation:
I generate 300 rows at a time - they should be stored in the a mysql
table.
99 % of the keys of these rows already exist in the table, so these
rows need an update.
The remaining 1 % have to be inserted in the table.
I was wondering if it is a good idea to to this with
300 UPDATE statements and if one of them fails do an INSERT.
Or if it's recommendable to use a single REPLACE statement.
My problem with the REPLACE is that the documentation says that a
REPLACE always does an DELETE and then an INSERT.
In my case a lot of rows (99%) would be deleted in the index that
only need an update.
Is it a good idea to do that much index manipulations that aren't
necessary?
Ciao, Stephan
--
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php