Re: [Firebird-net-provider] Select statements and transactions

[<car...@te...>]

Hello:

> This has worked brilliantly, I am now able to delete the file after running
> my dot net code. Thank you.

:)

> This particular problem has brought up the issue of the benefits of using
> connection pooling on a firebird db.
> If say I had a busy website using a firebird db as a back end, that was
> using connection pooling and was visited by a fair amont of people.

Huuummmm a thing you can test is to try to use the Connection Lifetime 
parameter in the connection string, for see if it can help.

> Then supposing I needed to take the website down for a short period of time,
> say for routine maintenance, I would have a whole pile of open connections
> in my database.
> I guess that I would need to close the connections gracefully, I'm not sure
> how I would do this.

Huummm you can try to create a static method in FbConnection, called for 
example CleanPool, for clean all the connections in the pool, if there 
are more people interested on this i can make it in the provider sources 
:), i can try to review too if there are anything arround this in the 
.NET Framework 1.1 and 1.2 documentation.

> This situation could arise if say a problem arose on my production site and
> I wanted to shut my production site down for a while and copy the production
> database to my development server, Firstly stoping the firebird service on
> the production server. Stopping the service would report "Overlapping I/O
> operation."

Huummm if you want to do backups you can do that without make a shutdown 
of the server, but i don't know if you mean this type of maintenance 
tasks :)





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain