Re: SV: SV: SV: [PHP] Copy? - What am I doing wrong???

Jochem Maas wrote: > Wiberg wrote: >> Hi there! >> >> fgtcvs works fine, but there's another problem now... I run updates to >> the >> db for each row (every row is unique) and must be updated. If I run the >> script with 20000 rows then my site couldn't open the database from >> another >> location. Is this MySQL-specific or PHP-specific? Is there any way to >> release memoryresources in PHP? > > I am not going to answer this question for 2 reasons: > > 1. I'm not your personal helpdesk. (mail the list not me personally - use > 'Reply All') > 2. I don't get what your asking. > > with regard to memory: unset() > with regard to the rest, please post your question again, this time to the > list, > also try to formulate your question differently (if I don't understand it > probably other > people won't either - and that increases the chance that your mail will be > ignored) I'm guessing he's running into a table-locking problem while trying to update 20000 records with unique IDs. If so, solutions include: Doing the updates a few rows at a time, so the table is only locked for a few seconds every minute over the course of a day. Altering the underlying table type in MySQL from MyISAM to, err, some table format that supports row-locking??? [I could be way off base and ISAM already does that...] It's also entirely possible he's only anticipating a problem that isn't a problem. Hard to tell. -- Like Music? http://l-i-e.com/artists.htm