Loading DB Interface Libraries
\The Sandbox \PB History & Future \New In PB8 \Loading DB Libs
Workspaces
Code Examples
UI changes
Working with 
PB8
Starting PB
System Tree
Library painter
Clip & Output
Source editor
AutoScript
Source Control
Exception
Handling
Web Targets
4GL Web
Pages
Web DW
Scripting
Web DW
Container
Web DW
Events
Server-side
Methods
JavaScript
Includes
HTML
Rendering
EAServer
Profiles
EAS/Existing
Interfaces
EJB Clients
EAS
Transactions
SSL
Connections
Concurrency
Property
Multiple
PB VMs
DB Interfaces
ANSI
Outer Join
Proxy
Connections
Loading
DB Libs
PB.INI/DB Info
Command Line
Deployment
Version
for EXEs
Color Support
New Object
Properties
DW
Expressions
DW
Properties
PowerScript
Functions
SaveObject
OLE Event
DBCS Support
GUIDs & MIMEs

Description

PowerBuilder loads the libraries used by a database interface when it connects to the database. Prior to PowerBuilder 8, PowerBuilder freed the database interface libraries when it disconnected from the database. In PowerBuilder 8, PowerBuilder does not automatically free the database interface libraries when it disconnects.

While memory use is somewhat increased by this technique (since the loaded database interface libraries continue to be held in memory), this change in PowerBuilder's behavior has improved performance and eliminated problems associated with the freeing and subsequent reloading of libraries experienced by some database connections.

Usage

If you want PowerBuilder to free database interface libraries upon disconnecting from the database (as it did in earlier versions of PowerBuilder), you can change its default behavior:

To change the default behavior for

Do this

Connections in the development environment

Select the Free Database Driver Libraries On Disconnect checkbox on the General tab of the System Options dialog box

Runtime connections

Set the FreeDBLibraries property of the Application object to TRUE on the General tab of the Properties view in the Application painter or in a script

EAServer components This behavior cannot be controlled when components are deployed to EAServer.

PBL Peeper PB Help PB History
& Future About Us Feedback Site Map

Google
 
Web www.techno-kitten.com
www.sybase.com