Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:54300
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: error (pb1.pair.com: domain lsces.co.uk from 213.123.20.125 cause and error)
Message-ID: <4E3895A4.8000606@lsces.co.uk>
Date: Wed, 03 Aug 2011 01:26:12 +0100
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.1.19) Gecko/20110420 SUSE/2.0.14-2.2 SeaMonkey/2.0.14
MIME-Version: 1.0
To: PHP internals <internals@lists.php.net>
References: <CACs9DU4jhCBHEYXd-N1rvYE5jbCDztvXEi=gsZh4ozLoqQrRXw@mail.gmail.com>	<CAEZPtU7dB9-ATrKqNF_sk+aeEPuKBZCFxYiZ41T1QSy4xgKLYw@mail.gmail.com>	<CACs9DU6MAmJt6veeOEVdkL5spO+8YVgmvbhioc7ORWZH-1d1LQ@mail.gmail.com>	<4E3814C9.2020407@lsces.co.uk> <CACs9DU487gCv91oF=rWyb+shxfAd35gmTGpmMKJn_yqMQPS7SQ@mail.gmail.com>
In-Reply-To: <CACs9DU487gCv91oF=rWyb+shxfAd35gmTGpmMKJn_yqMQPS7SQ@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Subject: Re: [PHP-DEV] [VOTE] Weak References
From: lester@lsces.co.uk (Lester Caine)

Hannes Landeholm wrote:
> Certain function in the application runs a MySQL procedure that updates a
 > certain complex selection of products in the products database rendering the
 > currently loaded products in memory obsolete since they might have been
 > updated.

Then you are caching the wrong data in memory?
Following an update like that one would either have to commit the changes or 
rollback. So the data has to be reloaded from the server anyway. You can't rely 
on any of the data already loaded.

> Joe deploys the application again and can only hope that this was the
> only loop that triggered the memory problem and that the application
> doesn't crash anywhere else when the products table grows larger.

So you are trying to load lots of unnecessary data from the database through 
poor design. Redesign the data so it works properly ... or switch to a database 
that handles business logic via triggers properly ;) You should only be 
downloading the data you need to look at, leave the volume data on the server.

The majority of my business logic is done in the database (Firebird) and I 
simply can't see how I would ever fall into the trap you seem to be creating? 
Perhaps I am doing something wrong, but my systems all run multiuser real time 
and handle large numbers of records without these sorts of problem.

-- 
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php