Re: [firebird-support] Very slow response after massive delete on table. (FB3 on Win 64)

2018-10-01 Thread fabia...@itbizolutions.com.au [firebird-support]
Thank you, much appreciated.

Re: [firebird-support] force disconnect and replace db in use

2018-10-01 Thread Issam Boughanmi amigof...@gmail.com [firebird-support]
sorry for the lack of informations : the firebird version is 2.5.8 embedded in windows 64 *shared hosting* the web application is developped using asp.net core in c# this database hosted on the net are exclusively used for read only operations i mean no configuration is done but the users only

Re: [firebird-support] Very slow response after massive delete on table. (FB3 on Win 64)

2018-10-01 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
fabia...@itbizolutions.com.au wrote: > I've noticed the following strange behavior on Firebird 3 latest > release, 64 bits, on Windows 2012, 24 processor server, 200 GB ram, magnetic > HDDs (no SSDs): > 1) After executing and commiting a massive delete on a table, any > select or insert takes ti

Re: [firebird-support] force disconnect and replace db in use

2018-10-01 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 1-10-2018 21:10, Dalton Calford dalton.calf...@gmail.com [firebird-support] wrote: > Different versions of firebird, give you different options.. The versions with extremely limited shutdown capabilities are end-of-life. All currently supported versions have it. > Some versions you just giv

Re: [firebird-support] force disconnect and replace db in use

2018-10-01 Thread Dalton Calford dalton.calf...@gmail.com [firebird-support]
Different versions of firebird, give you different options. Some versions you just give it a forced or timed shutdown command via the api or command line tools, others you can view the monitor tables and see what various connections are doing and you can delete connections as needed.. You can even

Re: [firebird-support] force disconnect and replace db in use

2018-10-01 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 1-10-2018 19:45, Issam Boughanmi amigof...@gmail.com [firebird-support] wrote: > is there any programming api to force firebird connections and pools to > disconnect . Firebird itself has no 'pools', connection pools are driver specific. > i have a database that run on a shared web hosting i

Re: [firebird-support] force disconnect and replace db in use

2018-10-01 Thread Dalton Calford dalton.calf...@gmail.com [firebird-support]
What version of firebird? On Mon, 1 Oct 2018 at 13:52, Issam Boughanmi amigof...@gmail.com [firebird-support] wrote: > > > hi, > > is there any programming api to force firebird connections and pools to > disconnect . > > i have a database that run on a shared web hosting in embedded mode . > >

[firebird-support] force disconnect and replace db in use

2018-10-01 Thread Issam Boughanmi amigof...@gmail.com [firebird-support]
hi, is there any programming api to force firebird connections and pools to disconnect . i have a database that run on a shared web hosting in embedded mode . i want to be able to force disconnect in order to be able to replace the database programatically .