Re: SV: SV: SV: Copy? - What am I doing wrong???

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux