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

[Ann Harrison aharri...@ibphoenix.com [firebird-support]]

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, and when looking at the task manager on windows it appears only one
>> processor it doing the job, as if the code was not SMP enabled very
>> strange.
>>
>
> One possibility is that you're testing V3.0 SuperServer single user.  In
> V3.0, Firebird is multi-threaded at the client statement level.  It does
> not decompose queries and schedule the pieces on different processors.
> That means that a full-table scan runs on only one processor.  Two
> simultaneous full-table scans will run on two processors.
>

I should have continued to say that two full-table scans probably won't be
any faster in 3.0 than they were in 2.5 because you're measuring disk
transfers and adding processors doesn't make the disk go faster.  I might
also have mentioned that sharing caches and other internal structures
between simultaneous threads is one challenge.  Distributing queries across
processors is another and totally different challenge.  The Firebird
developers were wise (in my opinion) to take the challenges one at a time.

Good luck,

Ann

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

['Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]]

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

[fabia...@itbizolutions.com.au [firebird-support]]

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 what is going on, but 
at least on our server it appears to be switched off, windows task manager 
shows only one processor doing the job, off course we set affinity to zero, so 
at least on the conf file it is correctly setup. Any ideas why the SMP is not 
activated?
 

 We are using a HP DL 380 G5 2 x Xeon x5470, 32 GB ram, Windows 2008 server 64 
bit, FB 3.0.0.32483 64 bits, and the client side is still using the FB 2.54 32 
bit client library and the latest firebird ODBC to connect to the database, 
would that have anything to do with it?
 

 Cheers,
 Fabian
 

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

[Ann Harrison aharri...@ibphoenix.com [firebird-support]]

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 the job, as if the code was not SMP enabled very
> strange.
>

One possibility is that you're testing V3.0 SuperServer single user.  In
V3.0, Firebird is multi-threaded at the client statement level.  It does
not decompose queries and schedule the pieces on different processors.
That means that a full-table scan runs on only one processor.  Two
simultaneous full-table scans will run on two processors.

Good luck,

Ann

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

[fabia...@itbizolutions.com.au [firebird-support]]

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?





  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 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 seems to be 
disabled, and the other has the masterkey password even though the install 
asked me for the password, but it appears it ignored my answer, or it used the 
password I entered for the disabled SYSDBA users... no big deal.


Other than that I have not encountered any other issues so far, I will 
recompile all stored procedures and views and triggers shortly, but I don't 
expect any issues there because the DB is operational with the Application and 
no errors have appeared on the APP side using the FB3 DB.


Cheers,
Fabian








  

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

[Alexey Kovyazin a...@ib-aid.com [firebird-support]]

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 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 seems to be 
disabled, and the other has the masterkey password even though the 
install asked me for the password, but it appears it ignored my 
answer, or it used the password I entered for the disabled SYSDBA 
users... no big deal.


Other than that I have not encountered any other issues so far, I will 
recompile all stored procedures and views and triggers shortly, but I 
don't expect any issues there because the DB is operational with the 
Application and no errors have appeared on the APP side using the FB3 DB.


Cheers,
Fabian

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

[fabia...@itbizolutions.com.au [firebird-support]]

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 seems to be 
disabled, and the other has the masterkey password even though the install 
asked me for the password, but it appears it ignored my answer, or it used the 
password I entered for the disabled SYSDBA users... no big deal.
 

 Other than that I have not encountered any other issues so far, I will 
recompile all stored procedures and views and triggers shortly, but I don't 
expect any issues there because the DB is operational with the Application and 
no errors have appeared on the APP side using the FB3 DB.
 

 Cheers,
 Fabian
 

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

[fabia...@itbizolutions.com.au [firebird-support]]

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 ASCII filter 
(charset) because otherwise the restore onto 3.0 would fail, so now I have lots 
of records with unwanted characters and cannot put the filter back onto 3.0 
because if I do so I would end up having a table that does not allow such 
characters however the characters are already there, so for intance a user 
trying to change a dot, or a comma on one of those records would get a failed 
message as the DB cannot write back into the engine the same text that is 
alraedy there becuase of the offending character. Is that correct?  How do I 
solve the issue? At the moment I set charset to NONE and it allows garbage in 
and out with no issues, but I don't want the bad characters there..

Cheers,
Fabian

  - Original Message - 
  From: Mark Rotteveel m...@lawinegevaar.nl [firebird-support] 
  To: firebird-support@yahoogroups.com 
  Sent: Thursday, May 26, 2016 4:08 AM
  Subject: 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.
  > The issue is pretty simple, the FB 2.54 DB contains a few characters
  > that are not allowed into the FB 3 database, one example of a character
  > causing an error during the restore was "Mcgarrity’s" (note the ’) as it
  > appears to be outside the scope of the FB3 string domain, I have trying
  > creating a new FB3 DB with many different charsets but none works. The
  > other string causing issues is for example "΢ÈíÑźÚ", I have many
  > records with this type of strings because the DB contains raw emails
  > received by the system, stored into Varchars, and apparently some emails
  > contain very weird characters, all were handled by FB2.54 but FB3
  > rejects the records. I have been able to isolate all recrods with issues
  > using IBExpert's table data comparer function, as it created a script
  > with all recrods from all tables from FB2.54 and when running the script
  > against FB3.0 it singles out all the offending records.
  >
  > Can anyone advise what options I have available to force FB3.0 to accept
  > any stuff into string fields?

  In your other e-mail you indicate you solved this by changing the 
  character set from ASCII to NONE. The fact it worked before was a bug, 
  see http://tracker.firebirdsql.org/browse/CORE-3416. ASCII only supports 
  characters 0-127, characters outside that range are 'extended ascii', eg 
  one of the other singly by character sets like WIN1252 or ISO8859_1. The 
  characters shown (΢ÈíÑÅºÚ and ’) are all outside the ASCII range.

  The last (’) is particularly nasty, because it should have been a ' 
  (u+0027 Apostrophe, ascii 39), instead u+2019 Right single quotation 
  mark (character 146 in Windows-1252) was used.

  Given the context of e-mails either NONE or OCTETS is the only real 
  option, as e-mails can have multiple parts with each their own character 
  set, and can also have binary parts (although usually those are encoded 
  with something like base64).

  Mark
  -- 
  Mark Rotteveel


  
  Posted by: Mark Rotteveel 
  

  ++

  Visit http://www.firebirdsql.org and click the Documentation item
  on the main (top) menu.  Try FAQ and other links from the left-side menu 
there.

  Also search the knowledgebases at 
http://www.ibphoenix.com/resources/documents/ 

  ++
  

  Yahoo Groups Links

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

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

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.
> The issue is pretty simple, the FB 2.54 DB contains a few characters
> that are not allowed into the FB 3 database, one example of a character
> causing an error during the restore was "Mcgarrity’s" (note the ’) as it
> appears to be outside the scope of the FB3 string domain, I have trying
> creating a new FB3 DB with many different charsets but none works. The
> other string causing issues is for example "΢ÈíÑźÚ", I have many
> records with this type of strings because the DB contains raw emails
> received by the system, stored into Varchars, and apparently some emails
> contain very weird characters, all were handled by FB2.54 but FB3
> rejects the records. I have been able to isolate all recrods with issues
> using IBExpert's table data comparer function, as it created a script
> with all recrods from all tables from FB2.54 and when running the script
> against FB3.0 it singles out all the offending records.
>
> Can anyone advise what options I have available to force FB3.0 to accept
> any stuff into string fields?

In your other e-mail you indicate you solved this by changing the 
character set from ASCII to NONE. The fact it worked before was a bug, 
see http://tracker.firebirdsql.org/browse/CORE-3416. ASCII only supports 
characters 0-127, characters outside that range are 'extended ascii', eg 
one of the other singly by character sets like WIN1252 or ISO8859_1. The 
characters shown (΢ÈíÑÅºÚ and ’) are all outside the ASCII range.

The last (’) is particularly nasty, because it should have been a ' 
(u+0027 Apostrophe, ascii 39), instead u+2019 Right single quotation 
mark (character 146 in Windows-1252) was used.

Given the context of e-mails either NONE or OCTETS is the only real 
option, as e-mails can have multiple parts with each their own character 
set, and can also have binary parts (although usually those are encoded 
with something like base64).

Mark
-- 
Mark Rotteveel

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

['Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]]

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

[fabia...@itbizolutions.com.au [firebird-support]]

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 then backup and restore 
onto FB 3.0, and it all worked fine. So I guess we were lucky, and the 
migration process was not too painfull. On the flip side, the performance we 
are getting on 3.0 is worst than on 2.54 it seems the SMP is not active as 
only one processor is doing all the job, and CPU affinity is set to zero, so we 
are not sure what's going on.
 

 Cheers,
 Fabian
 

 

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

[fabia...@itbizolutions.com.au [firebird-support]]

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 at the task manager on windows it appears 
only one processor it doing the job, as if the code was not SMP enabled 
very strange. We will leave 3.0 for testing at the moment, and continue to use 
2.54 in production, in the meantime we will play with 3.0 and try to figure out 
what is it we are doing wrong.
 

 Cheers,
 Fabian
 

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

[Alexey Kovyazin a...@ib-aid.com [firebird-support]]

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 we do migration for our clients, we use our automation tools which 
ensure that we have traced all problematic queries before going to 
production.
I don't think it's possible to do such checking manually in case of big 
enough system - and comments in this thread confirm it.


Regards,
Alexey Kovyazin
IBSurgeon
http://ib-aid.com/en/firebird-database-migration/




Hi All

We have a multi-user, multi-company, cloud based system running with
Firebird 2.54 as the main database, with about 100 concurrent 
connections.

We are considering migrating to FB 3.0 to take advantaje of the SMP
architecture, we have a 32 core / processors server, so we are hopping to
see an increased performance. We also have the need to set up online
replication.
Would anyone be able to advise if it it too soon to jump into FB 3.0 for
production? And if the performance increase would be enough to make the
upgrade worth considering 3.0 has not been around for long yet, and 
may be

"taking too much risk" to move into it so soon? And regarding the
replication, any advise on what product may be the right choice?

Cheers
Fabian

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

[p...@royston.com [firebird-support]]

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 have worked around 
a FB 3 bug where passing a null in a query param could make it do a full table 
scan instead of using an index. 
 [#CORE-5196] Index not used when search criteria is NULL in FB 3.0 RC 2 - 
Firebird RDBMS Issue Tracker http://tracker.firebirdsql.org/browse/CORE-5196  


   In general FB 3 seems much slower than FB 2.5 with anything that does a full 
table scan.  We have struggled for the past week to try to get performance back 
to where we were under 2.5. 
   Also not sure if you can revert to 2.5 once you move to 3.0.  The GBAK file 
under 3.0 will not restore under 2.5.
   Best of luck.
 --Pete

---In firebird-support@yahoogroups.com,  wrote :

 Hi All
 
 We have a multi-user, multi-company, cloud based system running with 
 Firebird 2.54 as the main database, with about 100 concurrent connections. 
 We are considering migrating to FB 3.0 to take advantaje of the SMP 
 architecture, we have a 32 core / processors server, so we are hopping to 
 see an increased performance. We also have the need to set up online 
 replication. 
 Would anyone be able to advise if it it too soon to jump into FB 3.0 for 
 production? And if the performance increase would be enough to make the 
 upgrade worth considering 3.0 has not been around for long yet, and may be 
 "taking too much risk" to move into it so soon? And regarding the 
 replication, any advise on what product may be the right choice?
 
 Cheers
 Fabian

Re: [firebird-support] Stored Procedures Execution Plan

[João Paulo Carvalho joao_paul...@yahoo.com [firebird-support]]

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]" 

 Para: firebird-support@yahoogroups.com 
 Enviadas: Sexta-feira, 20, Maio 2016 15:54:07
 Assunto: [firebird-support] Stored Procedures Execution Plan
   
    Hi.

I would like to know if it is possible to display the plan of stored procedure 
statements.
I'm interested in the plan of the statements inside the stored procedure (SP), 
not the plan just informing that I'm executing an SP.
We are running also selectable SP's.
Att.João Paulo
  #yiv1927926194 #yiv1927926194 -- #yiv1927926194ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1927926194 
#yiv1927926194ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1927926194 
#yiv1927926194ygrp-mkp #yiv1927926194hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv1927926194 #yiv1927926194ygrp-mkp #yiv1927926194ads 
{margin-bottom:10px;}#yiv1927926194 #yiv1927926194ygrp-mkp .yiv1927926194ad 
{padding:0 0;}#yiv1927926194 #yiv1927926194ygrp-mkp .yiv1927926194ad p 
{margin:0;}#yiv1927926194 #yiv1927926194ygrp-mkp .yiv1927926194ad a 
{color:#ff;text-decoration:none;}#yiv1927926194 #yiv1927926194ygrp-sponsor 
#yiv1927926194ygrp-lc {font-family:Arial;}#yiv1927926194 
#yiv1927926194ygrp-sponsor #yiv1927926194ygrp-lc #yiv1927926194hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1927926194 
#yiv1927926194ygrp-sponsor #yiv1927926194ygrp-lc .yiv1927926194ad 
{margin-bottom:10px;padding:0 0;}#yiv1927926194 #yiv1927926194actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1927926194 
#yiv1927926194activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1927926194
 #yiv1927926194activity span {font-weight:700;}#yiv1927926194 
#yiv1927926194activity span:first-child 
{text-transform:uppercase;}#yiv1927926194 #yiv1927926194activity span a 
{color:#5085b6;text-decoration:none;}#yiv1927926194 #yiv1927926194activity span 
span {color:#ff7900;}#yiv1927926194 #yiv1927926194activity span 
.yiv1927926194underline {text-decoration:underline;}#yiv1927926194 
.yiv1927926194attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv1927926194 .yiv1927926194attach div a 
{text-decoration:none;}#yiv1927926194 .yiv1927926194attach img 
{border:none;padding-right:5px;}#yiv1927926194 .yiv1927926194attach label 
{display:block;margin-bottom:5px;}#yiv1927926194 .yiv1927926194attach label a 
{text-decoration:none;}#yiv1927926194 blockquote {margin:0 0 0 
4px;}#yiv1927926194 .yiv1927926194bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv1927926194 
.yiv1927926194bold a {text-decoration:none;}#yiv1927926194 dd.yiv1927926194last 
p a {font-family:Verdana;font-weight:700;}#yiv1927926194 dd.yiv1927926194last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1927926194 
dd.yiv1927926194last p span.yiv1927926194yshortcuts 
{margin-right:0;}#yiv1927926194 div.yiv1927926194attach-table div div a 
{text-decoration:none;}#yiv1927926194 div.yiv1927926194attach-table 
{width:400px;}#yiv1927926194 div.yiv1927926194file-title a, #yiv1927926194 
div.yiv1927926194file-title a:active, #yiv1927926194 
div.yiv1927926194file-title a:hover, #yiv1927926194 div.yiv1927926194file-title 
a:visited {text-decoration:none;}#yiv1927926194 div.yiv1927926194photo-title a, 
#yiv1927926194 div.yiv1927926194photo-title a:active, #yiv1927926194 
div.yiv1927926194photo-title a:hover, #yiv1927926194 
div.yiv1927926194photo-title a:visited {text-decoration:none;}#yiv1927926194 
div#yiv1927926194ygrp-mlmsg #yiv1927926194ygrp-msg p a 
span.yiv1927926194yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1927926194 
.yiv1927926194green {color:#628c2a;}#yiv1927926194 .yiv1927926194MsoNormal 
{margin:0 0 0 0;}#yiv1927926194 o {font-size:0;}#yiv1927926194 
#yiv1927926194photos div {float:left;width:72px;}#yiv1927926194 
#yiv1927926194photos div div {border:1px solid 
#66;height:62px;overflow:hidden;width:62px;}#yiv1927926194 
#yiv1927926194photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1927926194
 #yiv1927926194reco-category {font-size:77%;}#yiv1927926194 
#yiv1927926194reco-desc {font-size:77%;}#yiv1927926194 .yiv1927926194replbq 
{margin:4px;}#yiv1927926194 #yiv1927926194ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv1927926194 #yiv1927926194ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1927926194 
#yiv1927926194ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1927926194 
#yiv1927926194ygrp-mlmsg select, #yiv1927926194 input, #yiv1927926194 textarea 

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

[korkl...@yahoo.it [firebird-support]]

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
 
https://groups.yahoo.com/neo/groups/firebird-support/conversations/topics/129046
   

 it's simpler if we can have an embedded packages with only the needed files

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

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

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, 
https://sourceforge.net/projects/firebird/files/firebird-win32/3.0-Release/Firebird-3.0.0.32483-2_Win32.zip/download
   No further steps required.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

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

[korkl...@yahoo.it [firebird-support]]

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 
https://groups.yahoo.com/neo/groups/firebird-support/conversations/topics/129046
 
https://groups.yahoo.com/neo/groups/firebird-support/conversations/topics/129046
 ) and then uninstall it

do you think that is a normal way to get them?

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

['Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]]

> 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 for Embedded users more clear/prominent/present on 
the website, e.g. in the download area for 3.0 packages. Due to a missing 
downloadable Embedded package, a clear statement on what is needed for an 
Embedded deployment out of the regular server distribution might help as well. 
Perhaps in a dedicated chapter of the release notes (possibly I haven't read 
the release notes carefully myself *g*). I know Carlos' migration guide deals 
with that, but IMHO the release notes should make that clear as well.

The current situation is a bit confusing for Embedded users.

Just my thoughts.


--
With regards,
Thomas Steinmaurer
http://www.upscene.com

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.

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

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

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.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

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

[korkl...@yahoo.it [firebird-support]]

hi, where are the embedded packages for fb3? 
thanks
 

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

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

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 might be wise to 
include it.

Mark

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

[josef.gschwendt...@quattro-soft.de [firebird-support]]

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

[Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support]]

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 NONE, Collate NONE, and that fixed the issue! 
Probably better to use UTF-8, but perhaps make that switch as a separate 
operation before or after the upgrade to FB 3.


Kjell
--

Marknadsinformation logotyp

Kjell Rilbe
Telefon: 08-761 06 55
Mobil: 0733-44 24 64

Marknadsinformation i Sverige AB
Ulvsundavägen 106C
168 67 Bromma
www.marknadsinformation.se 
08-514 905 90

Företagskontakt.se 
Personkontakt.se 

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

[Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support]]

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 simple, the FB 2.54 DB contains a few 
characters that are not allowed into the FB 3 database, one example of 
a character causing an error during the restore was "Mcgarrity’s" 
(note the ’) as it appears to be outside the scope of the FB3 string 
domain, I have trying creating a new FB3 DB with many different 
charsets but none works. The other string causing issues is for 
example "΢ÈíÑźÚ", I have many records with this type of strings 
because the DB contains raw emails received by the system, stored into 
Varchars, and apparently some emails contain very weird characters, 
all were handled by FB2.54 but FB3 rejects the records. I have been 
able to isolate all recrods with issues using IBExpert's table data 
comparer function, as it created a script with all recrods from all 
tables from FB2.54 and when running the script against FB3.0 it 
singles out all the offending records.



Can anyone advise what options I have available to force FB3.0 to 
accept any stuff into string fields?




The first thing that comes to mind is that ' needs to be duplicated 
inside string literals, so if your method of upgrading is backing up to 
insert statements, it might be the case that the backup file is 
incorrectly formatted in this reagard. I.e. to insert Mcgarrity's you 
would insert this string literal: 'Mcgarrity''s' (note the duplicated ').


Apart from that I would recommend UTF-8 for "everything", i.e. old table 
charset, connection charset when performing backup, backup file format, 
connection charset for importing the backup file into FB3, charset for 
all char/varchar columns in new database. Not sure all those "places" 
are even applicable.


Are you using gbak for backup from 2.5 and restore into 3.0, or how are 
you actually trying to perform the upgrade?


Regards,
Kjell
--

Marknadsinformation logotyp

Kjell Rilbe
Telefon: 08-761 06 55
Mobil: 0733-44 24 64

Marknadsinformation i Sverige AB
Ulvsundavägen 106C
168 67 Bromma
www.marknadsinformation.se 
08-514 905 90

Företagskontakt.se 
Personkontakt.se 

Re: [firebird-support] Doubt in Firebird

[Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support]]

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 prepared statement.Any 
help would be

 appreciated.


Hi,

In addition to Helen's advice, if it's still slow, I recommend using an 
external table. Write the data to a fixed-width format text file, create 
an external table referencing that file, then insert the records using a 
insert intoselect from statement.


I've found this approach beats any client insert iteration approach by 
several orders of magnitude.


For example, if you need to insert records with a string, a number and a 
date, create a text file like this (preferable with a fixed-width 
character encoding like iso-8859-1 or win1252:


This is some string with trailing space padding   \t0044838\t2016-05-25\r\n
Here's another string \t545\t2016-01-31\r\n

Save this file as e.g. C:\Dummy.txt and then create external table:

*create table*  "ExDummy"*external file*  'D:\DataDIA\Data\Firebird\Dummy.txt' (
  "TheString"*char*(50)*character set*  win1252,-- Adjust to your max string 
length.
  "Tab1"*char*(1)*character set*  win1252,
  "TheNumber"*char*(7)*character set*  win1252,-- Adjust accoring to your 
required number of digits.
  "Tab2"*char*(1)*character set*  win1252,
  "TheDate"*char*(10)*character set*  win1252,-- Use a date format that 
Firebird can cast from easily.
  "CRLF"*char*(2)*character set*  win1252
);

You can skip the \t separators and even skip line breaks if you wish. In 
that case, remove them from the external table create statement accordingly.


Next, insert the data into your actual data table:

insert into "MyTable" ("S", "N", "D")
select trim(cast("TheString" as varchar(50))),
  cast("TheNumber" as int),
  cast("TheDate" as date)
from "ExDummy";

You can then drop the external table, or keep it permanently for 
repeated batch imports. (Note: dropping tables should be done with 
exclusive database access to avoid risk of corruption).


It is possible to create external file in Firebird-native format rather 
than text format, but that's so complicated that it's probably not worth 
the effort.


This method will normally import several thousand records per second, 
but speed obviously depends on factors that Helen mentioned, e.g. 
indexes, index tree depth, page size, ...


Regards,
Kjell

--

Marknadsinformation logotyp

Kjell Rilbe
Telefon: 08-761 06 55
Mobil: 0733-44 24 64

Marknadsinformation i Sverige AB
Ulvsundavägen 106C
168 67 Bromma
www.marknadsinformation.se 
08-514 905 90

Företagskontakt.se 
Personkontakt.se