I'm new to .NET, and only have about 6 months of web application
development, so any help or push in the right direction is appreciated.
I've got a web application developed in RAD Studio 2007, using Delphi
for .NET and am seeking the best practices for managing the connections.
Several users will be browsing and searching within the app with some
being logged in updating data that is being searched.
Below is my connectionStrings tag in my web.config file:
<add name="MyConnString"
connectionString=
"userid=SYSDBA;password=masterkey;database=c:\mydb.fdb;datasource=Localh
ost;port=3050;charset=NONE;Role=;Connection lifetime=0;Connection
timeout=15;Pooling=True;MinPoolSize=10;MaxPoolSize=20;Connection
Lifetime=5;dialect=1;Packet Size=8192;server type=0;"
providerName="FirebirdSql.Data.FirebirdClient"/>
The simple code below is similar to what I'm calling to open / close a
connection when needed:
procedure Ttest.Page_Load(sender: System.Object; e: System.EventArgs);
var
conn : FirebirdSql.Data.FirebirdClient.FbConnection;
begin
// TODO: Put user code to initialize the page here
conn := FirebirdSql.Data.FirebirdClient.FbConnection.Create;
conn.ConnectionString :=
System.Configuration.ConfigurationManager.ConnectionStrings['MyConnStrin
g'].ToString;
conn.Open;
Response.Write ('Connection open<BR>');
Response.Write ('Connection Pools Count = ' +
conn.ConnectionPoolsCount.ToString + '<BR>');
conn.Close;
Response.Write('Connection close<BR>');
Response.Write('Connection Pools Count = ' +
conn.ConnectionPoolsCount.ToString + '<BR>');
end;
Will this manage the connection pool properly? Is this the best possible
way to maximize performance using the
FirebirdSql.Data.FirebirdClient.dll version 2.0.1.0?
Please advise if I can provide any additional information.
Thanks for your time,
-John Martinez
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
