|
Posted by Jerry Stuckle on 01/05/08 02:46
Rowan wrote:
>
>
> What is the best approach to caching database results. example say i'm
> doign an update on several entries which i've loaded into an array. I
> want to allow the user to click through and up date each array entry
> then dump everythign to the db once they are done...
>
Don't bother. It's normally cheaper to just keep track of the ID's and
fetch the results again.
You should be fetching them again before updating anyway, and verifying
the rows haven't changed (i.e. two people updating at the same time).
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|