Subject | RE: [firebird-support] firebird w/dot net provider slows way down? |
---|---|
Author | Simon Carter |
Post date | 2005-05-10T17:54:57Z |
Probably better sent to the .net list
(http://lists.sourceforge.net/lists/listinfo/firebird-net-provider). Two
things to check is that you are explicitly closing all FbConnection and
FbDataReader connections, something like:
FbConnection db = new FbConnection(Global.ConnString);
db.Open();
try
{
FbTransaction tran = db.BeginTransaction();
try
{
string SQL = String.Format("SELECT blah, blah
FbCommand cmd = new FbCommand(SQL, db, tran);
FbDataReader rdr = cmd.ExecuteReader();
try
{
if (rdr.Read())
{
... Read data
}
}
finally
{
rdr.Close();
}
}
finally
{
tran.Rollback();
}
}
finally
{
db.Close();
}
hih
Si Carter
http://www.tectsoft.net/
(http://lists.sourceforge.net/lists/listinfo/firebird-net-provider). Two
things to check is that you are explicitly closing all FbConnection and
FbDataReader connections, something like:
FbConnection db = new FbConnection(Global.ConnString);
db.Open();
try
{
FbTransaction tran = db.BeginTransaction();
try
{
string SQL = String.Format("SELECT blah, blah
FbCommand cmd = new FbCommand(SQL, db, tran);
FbDataReader rdr = cmd.ExecuteReader();
try
{
if (rdr.Read())
{
... Read data
}
}
finally
{
rdr.Close();
}
}
finally
{
tran.Rollback();
}
}
finally
{
db.Close();
}
hih
Si Carter
http://www.tectsoft.net/
> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of firebirdnewbie
> Sent: 10 May 2005 16:28
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] firebird w/dot net provider slows
> way down?
>
> I am using firebird 1.5 with the dot net provider. I have tried both
> 1.6.3 and 1.7 RC 3 versions of the provider. I am running
> firebird Superserver as a service and everything is on the
> local machine. The local machine has only one processor.
> During development and testing, the same routines are
> blazingly fast then a while later unusably slow. Once slow,
> rebooting is the only thing to make them fast again. I have
> tried uninstalling both the server and the provider and
> reinstalling them. Nothing seems to keep it from happening.
> I am concerned this problem could show up in the live
> version. Anyone else seen this? Any solution to the problem?
>
>
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources
> item on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>