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

On Wed, May 25, 2016 at 2:53 PM, Ann Harrison wrote: > On Wed, May 25, 2016 at 1:11 PM, fabia...@itbizolutions.com.au > [firebird-support] wrote: > >> >> Now on the flip side, the performance sucks, it is worst than with FB >> 2.54,

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

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

Hi All First of all CONGRATS to all developers for the 3.0 project, the Firebird DB engine has been an excelent tool for us for more than a decade, and we do appreciate the efforts and great product the developing team has created! Specifically to the SMP capable feature, we are not sure

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

On Wed, May 25, 2016 at 1:11 PM, fabia...@itbizolutions.com.au [firebird-support] wrote: > > Now on the flip side, the performance sucks, it is worst than with FB > 2.54, and when looking at the task manager on windows it appears only one > processor it doing

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

Thanks Alexey, will try it and post back with comments - Original Message - From: Alexey Kovyazin a...@ib-aid.com [firebird-support] To: firebird-support@yahoogroups.com Sent: Thursday, May 26, 2016 6:58 AM Subject: Re: [firebird-support] Is Firebird 3 ready for Production?

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

Hi Fabian, Also I recommend you to try our optimized configuration file for FB3: http://ib-aid.com/en/optimized-firebird-configuration/ Regards, Alexey Hi Alexey Thank you for the comments. So far everything has gone ok, I fixed all the fields with ASCII charset at the FB 2.54 DB (changed

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

Hi Alexey Thank you for the comments. So far everything has gone ok, I fixed all the fields with ASCII charset at the FB 2.54 DB (changed the domain to charset NONE), and now the backup and restore workes fine, with no errors. I've noticed the new FB3 DB has now two SYSDBA users, one

Re: [firebird-support] FB 3 issues with String from FB 2.54

Mark Are you saying that the filter I placed on FB 2.5 with charset ASCII was correct from the theory, but there was a bug that made the filter be ignored by the FB engine? and the ugly characters got inside the DB because of the bug? And for me to be able to move onto FB 3 I had to remove the

Re: [firebird-support] FB 3 issues with String from FB 2.54

On 23-5-2016 03:45, fabia...@itbizolutions.com.au [firebird-support] wrote: > I have been trying to migrate from FB2.54 into FB 3 for a few weeks, and > after hitting a string related error for some time i have got to the > point where I do understand the issue, but I don't know how to solve it. >

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

Re: [firebird-support] FB 3 issues with String from FB 2.54

Hi Kjell We had a FB 2.54 DB with a few varchars defined as charset ASCII, the intention was to stop users from entering unreadable characters, so the charset was there to attempt to filter garbage, at least that was the idea), anyways we converted all domains from charset ASCII to NONE, and

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

Pete Thanks for your input. We managed to get the DB upgraded to 3.0 (removed all charset ASCII definitions on fields while on 2.54, then backup the DB and restored it on 3.0, and it all worked). Now on the flip side, the performance sucks, it is worst than with FB 2.54, and when looking

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

Hi Fabian, Is is ready for production, but migration process in not just backup/restore (it was never so in older versions, but it worked relatively well due to high backward incompatibility) - it requires thorough check of triggers, stored procedures, data itself and ad hoc queries. When

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

Fabian, I would not rush into FB 3.0 on a production system. We did and we regret it. We had the same hopes that the SMP would make great improvements. At this point things are actually running slower for us with FB 3.0. Some of the queries needed to be rewritten to perform better, and we

Re: [firebird-support] Stored Procedures Execution Plan

Hi. Since this was my first post in this list, I'm not sure if it was sent. If you already get it, or this is not the right place to discuss this kind of topic, I would be very grateful if you tell me where is. Att.João Paulo DE: "joao_paul...@yahoo.com [firebird-support]"

[firebird-support] Re: download link for fb 3 embedded?

sorry previously i writed a wrong thing (i deleted the message), anyway the download package contains all the files, then i must manually filter them using the list from https://groups.yahoo.com/neo/groups/firebird-support/conversations/topics/129046

Re: [firebird-support] Re: download link for fb 3 embedded?

25.05.2016 13:03, korkl...@yahoo.it [firebird-support] wrote: > do you think that is a normal way to get them? No. All you need is to download and unpack zip package of corresponding bitness. For example,

[firebird-support] Re: download link for fb 3 embedded?

maybe i miss something in the release notes but that exists an unique architecture is an internal implementation detail, to have the files for an embedded app i must install a full server on my machine, copy the needed files (what are the needed files? get the list from this post

Re: [firebird-support] download link for fb 3 embedded?

> 25.05.2016 12:23, korkl...@yahoo.it [firebird-support] wrote: >> where are the embedded packages for fb3? > > Not exists anymore. Read Release Notes about changes in server architecture. While this is true, that people should first read the release notes, IMHO we should make the transition

Re: [firebird-support] download link for fb 3 embedded?

25.05.2016 12:23, korkl...@yahoo.it [firebird-support] wrote: > where are the embedded packages for fb3? Not exists anymore. Read Release Notes about changes in server architecture. -- WBR, SD.

[firebird-support] download link for fb 3 embedded?

hi, where are the embedded packages for fb3? thanks

Re: [firebird-support] Re: Minimal file file requirements for FB3 (client/embedded)

On 2016-05-25 8:31, josef.gschwendt...@quattro-soft.de [firebird-support] wrote: > Hi, > > what is with msvcp100.dll and msvcr100.dll? > > Are these files not required? They are required if the MS Visual C 2010 runtime is not installed on the machine. In my experience it usually is, but it

[firebird-support] Re: Minimal file file requirements for FB3 (client/embedded)

Hi, what is with msvcp100.dll and msvcr100.dll? Are these files not required? -- Josef

Re: [firebird-support] Re: ODP: FB 3 issues with String from FB 2.54

Fabian Ernesto Chocron fabia...@itbizolutions.com.au [firebird-support] skrev: After playing with the problem for a while I noticed the definition of the field was Varchar (8192) charset ASCII collate ASCII, so that was probably causing the problem. I changed the domain settings to be Charset

Re: [firebird-support] FB 3 issues with String from FB 2.54

fabia...@itbizolutions.com.au [firebird-support] skrev: I have been trying to migrate from FB2.54 into FB 3 for a few weeks, and after hitting a string related error for some time i have got to the point where I do understand the issue, but I don't know how to solve it. The issue is pretty

Re: [firebird-support] Doubt in Firebird

lionel napoleon lionelnapol...@yahoo.com [firebird-support] skrev: I use firebird 2.5.6.I just wanted to know if there is a method by which i can speed an insert query to (insert about 5 records) into a table.Right now it is taking about 40 minutes.My front end is VBscript and i use a