Mysql Insert/Update Problem
| From: | Haseeb Iqbal | Date: | Wed, 07 Jan 2004 22:48:17 +0000 |
| Subject: | Mysql Insert/Update Problem | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-174016@lists.php.net to get a copy of this message | ||
here is what i am trying to achieve,i have 2 servers. Win2k and linux.
mysql is running on my linux server.now i have quite a lot of that i need to update on linux server
from win2k machine.
here is what i am trying to do.i have a PHP CLI script that will open a dbx file extract records
from the dbf file one by one check is the record is already on the linux server (mysql database). if
the record is already on the linux server then it will update the mysql database on the linux
server. but if the record is not in the mysq database running on linux then it will insert the
record. the script is running on win2k server.
there are 6 dbf file that i need to extract.
comcat.dbf contains 581 records
comgrp.dbf contains 79 records
comsub.dbf contains 1896 records
manuf.dbf contains 793 records
prodaux.dbf conatins 170000+ records
products.dbf conatins 170000+ records
the script it taking to much time while inserting. it almost 24 hours now and still it isnt
finished.what can i do to update the db faster.
thanx for any help in advance
Haseeb Iqbal.