|
|
Posted by Wiberg on 10/04/83 11:09
Hi there!
You're right. It wasn't a problem. It was my local Win-computer that failed
totally...
/G
@varupiraten.se
-----Ursprungligt meddelande-----
Från: Richard Lynch [mailto:ceo@l-i-e.com]
Skickat: den 25 februari 2005 21:46
Till: Jochem Maas
Kopia: gustav@varupiraten.se; [php] PHP General List
Ämne: 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
--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 266.4.0 - Release Date: 2005-02-22
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 266.4.0 - Release Date: 2005-02-22
Navigation:
[Reply to this message]
|