Thanks Alan and Andy. Could you elaborate more on what kind of inefficiencies it could create and what would be the performance hit?
Regards. On Mon, 2008-11-10 at 13:45 +0000, Alan Williamson wrote: > i assume you mean this for each page request. > > OpenBD by default doesn't hold a connection for the duration of the > page, as this is somewhat inefficient and blocks other pages from > utilising the inherent overlapping that comes with processing pages. > > However you can do a couple of things to make OpenBD use the same > connection throughout. > > 1. <cftransaction> around the block > > 2. [Andy is now about to email the list and tell you!] > > :) > > On 10/11/2008 13:37, Victor Balada Diaz wrote: > > seems ColdFusion does use persistent connections for MySQL and > > OpenBD isn't. This prevents you from using temporary tables, as > > they're created and destroyed in the same query. > > > > Is there any way to make OpenBSD use persistent connections? > > > --~--~---------~--~----~------------~-------~--~----~ Open BlueDragon Public Mailing List http://groups.google.com/group/openbd?hl=en official blog @ http://blog.openbluedragon.org/ !! save a network - trim replies before posting !! -~----------~----~----~----~------~----~------~--~---
