Re: Update a row or insert if don´t exist

[Armin]

Hi,

I have the same problem with PHP. (Data synchronisation dBase-File to MySQL)
Did you find a solution?

At them moment I submit a SELECT to the Server.
--> "SELECT `products_id` FROM `" . $ASE_DBTABL_PROD . "` WHERE `products_dist` LIKE '" . $DIST . "' AND `products_anr` LIKE '" . $DIST . $products_anr . "' LIMIT 0 , 1";
If there are rows matching that query I sumit a UPDATE.
--> "UPDATE `" . $ASE_DBTABL_PROD . "` SET `products_hnr` = '" . $products_hnr . "' WHERE `products_dist` LIKE '" . $DIST . "' AND `products_anr` LIKE '" . $DIST . $products_anr . "'"
Otherwise I Submit an INSERT.
--> "INSERT INTO `" . $ASE_DBTABL_PROD . "` (`products_dist`) VALUES ('" . $DIST . "')"

But that stresses the server! MySQL needs 99% cpu for about 3-4 hours!
That SQL-Table has 32.000 rows with 27 Fields.

Knows anybody an other way to do this and get a better performance?

Thanks,
Armin