Yeah, for my purposes, ZSQL Methods have been totally adequate, if not perfect. I have not seen any performance issues, even if they have that 40% overhead. Actually, the only thing that is slow is running very large reports, but you cant really get around that when you call up thousands of records in one shot. (or can you?) Of course, I only have my apps running with 60-70 users, so I cant speak for those running at high capacity. I would just use the already built zope machinery instead of dealing with all that yourself, if you can help it.
Also (and I am quite ignorant when it comes to the details on db connections), if you are concerned about caching and the performance of your queries, I am guessing you might be running several queries in one operation. If so, wouldnt the use of stored procedures help with that? That would reduce the connection overhead and I think the parameters you spoke of could be used, right? Although, it is still just building the sql command from zope. Just a thought I had. I use procedures as much as possible and in my experience it really helps performance. Anyway, just thought I'd throw my 2 cents out there. I could be way off on this. Greg On 7/28/05, Marcin Wudarczyk <[EMAIL PROTECTED]> wrote: > > Hello, > > I've read the manual for Z SQL method and set up a simple example with > query having a parameter. Everything works fine but then I realised that > parametric Z SQL Methods are not passing its parameters to DB as > parameters but inserting it into SQL string. I think this has > significant impact on perfomance - DBs have special facilities to cache > compiled queries and change only parameters. Is there a way to use this > features from Zope? > > (I understand that I can manually make queries via DB-API, but I loose > sync with Zope transactions? Anyway I would prefer to use Z SQL Methods) > > Regards > > Marcin Wudarczyk > > > _______________________________________________ > Zope-DB mailing list > [email protected] > http://mail.zope.org/mailman/listinfo/zope-db > -- Greg Fischer 1st Byte Solutions http://www.1stbyte.com _______________________________________________ Zope-DB mailing list [email protected] http://mail.zope.org/mailman/listinfo/zope-db
