Re: [firebird-support] Searching for FB3 backup suggestions

Sorry, I just realised I was thinking of an option that had been removed. You need to run Firebird as SuperClassic or Classic (or do the backup through localhost as suggested earlier. Mark - Bericht beantwoorden - Van: "'Mark Rotteveel' m...@lawinegevaar.nl [firebird-support]"

Re: [firebird-support] Searching for FB3 backup suggestions

26.05.2016 13:50, dondondonje...@yahoo.com [firebird-support] wrote: > "C:\Program Files\Firebird\Firebird_3_0\gbak.exe" -b -v -t -se service_mgr > employee > e:\xxx.bak -user SYSDBA > works if no one is connected else i always get error "file is used by anot > her process". Use "-se

[firebird-support] Re: Searching for FB3 backup suggestions

26.05.2016 14:50, dondondonje...@yahoo.com wrote: > > "C:\Program Files\Firebird\Firebird_3_0\gbak.exe" -b -v -t -se > service_mgr employee e:\xxx.bak -user SYSDBA > works if no one is connected else i always get error "file is used by > another process". gbak.exe -b -v -t -se

Re: [firebird-support] Searching for FB3 backup suggestions

You need to backup through localhost, or you need to set the database in databases.conf (or the Firebird default in Firebird.conf) to Shared. You should have had the same problem with Firebird 2.5 if you used SuperServer. Mark - Bericht beantwoorden - Van: "dondondonje...@yahoo.com

Re: [firebird-support] Re: Is Firebird 3 ready for Production?

Ann > I might also have mentioned that sharing caches and other internal structures > between simultaneous threads is one challenge. So the above mentioned changes have been implemented in FB3. And the was referred as true SMP in the white papers about FB3. Correct? > Distributing queries

Re: [firebird-support] Re: Searching for FB3 backup suggestions

26.05.2016 21:33, hv...@users.sourceforge.net [firebird-support] wrote: >Specify remote (network) access explicitly (else it tries to open database > using > embedded engine and fails) Shouldn't the next provider to be tried in this case? -- WBR, SD.

[firebird-support] Re: Searching for FB3 backup suggestions

---In firebird-support@yahoogroups.com, wrote : > "C:\Program Files\Firebird\Firebird_3_0\gbak.exe" -b -v -t -se service_mgr > employee e:\xxx.bak -user SYSDBA > works if no one is connected else i > always get error "file is used by another process". Specify remote

[firebird-support] Searching for FB3 backup suggestions

Hello, i am currently testing to migrate FB2.5 databases into FB3 databases. Cant tell how many hours i recoded SP, triggers and and and... but database is working for me now. Then i came to the point to backup the FB3 databases on a running system. Yes, i read the manuals and release

Re: [firebird-support] FB 3 - SMP switched off ?

Thanks Dimitry Cheers Fabian - Original Message - From: Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] To: firebird-support@yahoogroups.com Sent: Thursday, May 26, 2016 10:44 PM Subject: Re: [firebird-support] FB 3 - SMP switched off ? 26.05.2016 14:42,

Re: [firebird-support] FB 3 - SMP switched off ?

26.05.2016 14:42, fabia...@itbizolutions.com.au [firebird-support] wrote: > Do you know if it is planned for Firebird to distribute each client request > across all > CPUs? When? Parallel execution of a single request is not planned at all yet. -- WBR, SD.

Re: [firebird-support] Re: Is Firebird 3 ready for Production?

On Thu, May 26, 2016 at 8:30 AM, fabia...@itbizolutions.com.au [firebird-support] wrote: > > I wrote: > > > In V3.0, Firebird is multi-threaded at the client statement level. It > does not decompose queries and schedule the pieces on different processors. > >

Re: [firebird-support] Is Firebird 3 ready for Production?

Re: [firebird-support] Is Firebird 3 ready for Production?I see, will read it Cheers Fabian - Original Message - From: 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support] To: fabia...@itbizolutions.com.au [firebird-support] Sent: Thursday, May 26, 2016 6:01 AM

Re: [firebird-support] FB 3 - SMP switched off ?

Dimitry I see, I will shut the FB server many requests at once from different instances of client APP and see how it performs, I guess this test will show many CPUs going high. Do you know if it is planned for Firebird to distribute each client request across all CPUs? When? Cheers,

Re: [firebird-support] Re: Is Firebird 3 ready for Production?

Ann I understand, I thought true SMP was referring to assigning each client's request to all CPU at once, instead of balacing the clients requests across processors. So the current version (FB 3) is probably going to outperform the FB 2.54 when there are concurrent requests passed to the

Re: [firebird-support] Finding a single row

26.05.2016 12:48, Ertan Küçükoğlu ertan.kucuko...@1nar.com.tr [firebird-support] wrote: > Below didn't work for me because complete card number is longer, and I do > lack SQL knowledge: > select * from FIYATKODLARI where Kodu like 'SB1%' select * from FIYATKODLARI where 'FullCardNumber'

[firebird-support] Finding a single row

Hi, I have a table where I keep some part from the beginning of a discount card number. Length of beginning is variable. User provides a complete card number at runtime, I need to find a single row in my table which begins as the complete card number, or I need to know no match exists in my

Re: [firebird-support] FB 3 - SMP switched off ?

25.05.2016 19:34, fabia...@itbizolutions.com.au [firebird-support] wrote: > Any ideas why the SMP is not activated? Single connection uses only one execution thread. -- WBR, SD.