OBject relational mapper looks like an overkill. All I need is a way to create 'empty' database object just like mysql would return from a row query and a function to update the data back to mysql on the background process. seems simple and streightforward, and gives memcached a very powerful use case.
On Sep 21, 1:09 pm, Henrik Schröder <[email protected]> wrote: > What you want is an object-relational mapper, but I have no idea if there > are any good ones for PHP. We implemented our own in C# after having looked > at Django which we liked alot. As always, google is your friend: > > http://en.wikipedia.org/wiki/List_of_object-relational_mapping_software > > /Henrik > > On Sun, Sep 20, 2009 at 21:35, Nbd <[email protected]> wrote: > > > Hi, > > > On all examples I could find of using memcached it is used as query > > result cache. This means that all data manipulations and updates are > > done on the db level and not in memory. > > > On applications with many updates, it seems to be much more efficient > > to update the memcache object and write it to the db periodically with > > a background process. > > > I couldn't find any information on how to do this on PHP/Mysql > > configuration. > > > In pseudo code: > > > is user data in cache? > > if not check if user data in database. if so fetch it. > > if user data is not in the database/cache create PHP object > > representing user data row with default values. > > update user data > > > once in 10 minutes write all updated users data to database. > > > I tried to implement it on a rather complex user data and found its > > complicated to create the object and write it to the db. > > Has anyone done it automatically? > > Some of the issues that have to be tackeled: > > 1.Creating empty user data object from mysql . > > 2.Writing the data back to the database from the data object. > > > Any help is very much appreciated.
