[geeklog-devel] GL2 DataAccess Class

Vincent Furia vfuria at gmail.com
Mon Jan 17 10:07:14 EST 2005


Tony,

Another issue with the DAO class is that it seems catered to providing
support only for SELECT's.  It won't work for doing INSERT's,
UPDATE's, or DELETE's (etc...).

-Vinny


On Mon, 17 Jan 2005 09:39:04 -0500, Vincent Furia <vfuria at gmail.com> wrote:
> Tony,
> 
> Caching between page calls would be great.  But even having a static
> variable or something similar to persist between calls to the "find"
> method would be a good start (and probably sufficient for most sites).
> 
> -Vinny
> 
> 
> On Mon, 17 Jan 2005 08:32:53 -0600, Tony Bibbs <tony at tonybibbs.com> wrote:
> > You mean cache it to memory or to a file.  I'd love to cache it to
> > memory but, afaik, it would require php's shared memory which isn't
> > enabled by default.
> >
> > I s'pose if the xml parsing itself if that bad, would could cache a
> > php-friendly data structure to a file.
> >
> > I'm open to this.  I just learned how to profile PHP applications this
> > past week so finding poor performing code shouldn't be a problem.
> >
> > --Tony
> >
> > Vincent Furia wrote:
> >
> > >Tony,
> > >
> > >Just looking through the DAO to understand everything it is doing
> > >better.  I noticed that the "find" method (and the other methods)
> > >reloads the named queries from the xml file on every call.  We should
> > >look for a way to work around this (i.e. somehow cache the DOMXPath
> > >object) so as not to suffer huge penalties for parsing the XML file on
> > >every DB call.
> > >
> > >-Vinny
> > >_______________________________________________
> > >geeklog-devel mailing list
> > >geeklog-devel at lists.geeklog.net
> > >http://lists.geeklog.net/listinfo/geeklog-devel
> > >
> > >
> >
> > _______________________________________________
> > geeklog-devel mailing list
> > geeklog-devel at lists.geeklog.net
> > http://lists.geeklog.net/listinfo/geeklog-devel
> >
>



More information about the geeklog-devel mailing list