|
|
Posted by Richard Lynch on 10/04/79 11:09
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
Navigation:
[Reply to this message]
|