updating slow for one table

    Date: 05/25/07 (MySQL Communtiy)    Keywords: php, database

    i have a production database and a development database running on the same server. (i know that's dumb but it's all we've got.) i copied a table from production to dev and performed an update on it via a php script. the script reads a csv file, checks to see if the item is already in the table, updates the row if it is, and inserts if it's not. 90% of the time it's an update. when i ran the script on the dev table, the process took about 30 minutes. everything looked good so i ran it on the production table. it's been running for ~3 hours. as far as i know, the tables in production and dev are exactly the same -- same server, same data, same indexes. almost no one is working today so the server is practically idle. is there any reason the same process would take so much longer in another database?

    Source: http://community.livejournal.com/mysql/113841.html

« Linux Database jobs || Mysql control center user... »


antivirus | apache | asp | blogging | browser | bugtracking | cms | crm | css | database | ebay | ecommerce | google | hosting | html | java | jsp | linux | microsoft | mysql | offshore | offshoring | oscommerce | php | postgresql | programming | rss | security | seo | shopping | software | spam | spyware | sql | technology | templates | tracker | virus | web | xml | yahoo | home