Re: Re: [firebird-support] Schema pluses?

[liviuslivius liviusliv...@poczta.onet.pl [firebird-support]]

Hello Karol,
Thursday, June 16, 2016, 7:49:06 AM, you wrote:
>
> but this feature is considered for FB4 – then i need to know why this is 
> important feature..
>
This whole topic is off-topic in firebird-support, which is about
current releases.
However, I'm sure others (including me) are interested to know why
this is considered a flagship feature for Fb 4. The right place for
the discussion is firebird-architect. Would you kindly move it to
there?
Thanks,
Helen (list moderator)

Ok Helen, we are finish discussion now :)
 
regards,
Karol Bieniaszewski

Re: [firebird-support] Re: Schema pluses?

[liviuslivius liviusliv...@poczta.onet.pl [firebird-support]]

>>In this case, user1 does not know about user2. They live in two parallel 
>>universes.
>>Dmitry
Then i do not know who can take risk that user1 in one "universe" (product) at 
present day have e.g. two schemas and user2 have onother schema 
and in the future user2 take decision to create another schema for separation 
and call it the same as user1 ...
 
I see separation of one vendor inside one database and where user1 and user2 is 
the same vendor and know about database as a whole.
 
regards,
Karol Bieniaszewski
 
_
 

Re: [firebird-support] Re: Schema pluses?

[liviuslivius liviusliv...@poczta.onet.pl [firebird-support]]

 
Ok i then misunderstand some discussion obout increasing length of identifiers 
to support then schemas
Now i understand that this is only minor preparation
 
regards,
karol Bieniaszewski
 
 
 
W dniu 2016-06-15 23:36:56 użytkownik Dmitry Yemanov 
dim...@users.sourceforge.net [firebird-support] 
 napisał:
 
15.06.2016 22:49, 'livius' wrote:
>
> but this feature is considered for FB4
No, it's not. At least not for v4.
Dmitry
__._,_.__,___
 

Re: [firebird-support] Schema pluses?

[Helen Borrie hele...@iinet.net.au [firebird-support]]

Hello Karol,

Thursday, June 16, 2016, 7:49:06 AM, you wrote:

>
> but this feature is considered for FB4 – then i need to know why this is  
> important feature..
>   

This whole topic is off-topic in firebird-support, which is about
current releases.

However, I'm sure others (including me) are interested to know why
this is considered a flagship feature for Fb 4.  The right place for
the discussion is firebird-architect.  Would you kindly move it to
there?

Thanks,
Helen (list moderator)

[firebird-support] Re: Schema pluses?

[Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]]

15.06.2016 22:48, 'livius' wrote:
>
> we can write sql like
> select * from table_name but really this is
> select * from schema.table_name
> and if i write this in stored procedure – i suppose that “object_id”
> will be stored in blr(when schemas will be avaiable)

BLR will contain schema.table_name.

> and also some task – user1 tell user2 “send me sql to retrive something”

In this case, user1 does not know about user2. They live in two parallel 
universes.

> I see only complication over benefits

You just don't see the point from the integration (read: enterprise) 
POV. For simple setups (single database), schemas are just two-level 
namespace, with the benefit of "A.B" being longer than "A_B".


Dmitry

[firebird-support] Re: Schema pluses?

[Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]]

15.06.2016 22:49, 'livius' wrote:
>
> but this feature is considered for FB4

No, it's not. At least not for v4.


Dmitry

Re: [firebird-support] Schema pluses?

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

15.06.2016 21:49, 'livius' liviusliv...@poczta.onet.pl [firebird-support] wrote:
> i need to know why this is important feature..

   It is good from marketing POV. Biggest competitors have them, no matter what 
for.


-- 
   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/

Re: [firebird-support] Schema pluses?

['livius' liviusliv...@poczta.onet.pl [firebird-support]]

Hi,

but this feature is considered for FB4 – then i need to know why this is 
important feature..

regards,
Karol Bieniaszewski

From: mailto:firebird-support@yahoogroups.com 
Sent: Wednesday, June 15, 2016 4:16 PM
To: firebird-support@yahoogroups.com 
Subject: Re: [firebird-support] Schema pluses?

  

Firebird has no support for schemas, IIRC... or am I missing something?


Em dom, 12 de jun de 2016 às 18:18, 'livius' liviusliv...@poczta.onet.pl 
[firebird-support]  escreveu:


  Hi,

  what are + and – with working with schema?
  What benefits are between 
  schema_name__table_name and real schema implementation?
  schema_name.table_name

  I near to always have worked without schema databases or with only one schema 
in schema supported databases.

  regards,
  Karol Bieniaszewski

Re: [firebird-support] Re: Schema pluses?

['livius' liviusliv...@poczta.onet.pl [firebird-support]]

Hi,

thank you Dmitry – the last sentens show me some benefits
other sentenses show only complications for me.
we can write sql like
select * from table_name but really this is 
select * from schema.table_name

and if i write this in stored procedure – i suppose that “object_id” will be 
stored in blr(when schemas will be avaiable)
because if another user use this procedure and he have different default schema 
...

and also some task – user1 tell user2 “send me sql to retrive something” 
he send but user1 have different schema and in both schemas same tables exists 
...
I see only complication over benefits

reg

From: mailto:firebird-support@yahoogroups.com 
Sent: Wednesday, June 15, 2016 3:47 PM
To: firebird-support@yahoogroups.com 
Subject: [firebird-support] Re: Schema pluses?

  
13.06.2016 00:18, 'livius' wrote:
>
> what are + and – with working with schema?
> What benefits are between
> schema_name__table_name and real schema implementation?
> schema_name.table_name

Ability to have a default schema (per user, per connection). So that you 
may have multiple completely unrelated databases inside single physical 
database, and set up multiple "schema-less" users/applications of these 
different logical databases. E.g. one app works with USERS but actually 
it's CRM.USERS and a different app also works with USERS but actually 
it's HR.USERS. From the maintenance/administration POV it's a single 
database (configuration, backups, etc).

Dmitry

Re: [firebird-support] performance issue with firebird 3.0 embedded on linux

['livius' liviusliv...@poczta.onet.pl [firebird-support]]

Hi,

do you mean that you share one connection between multiple threads?

regards,
Karol Bieniaszewski

From: mailto:firebird-support@yahoogroups.com 
Sent: Wednesday, June 15, 2016 5:55 PM
To: firebird-support@yahoogroups.com 
Subject: RE: [firebird-support] performance issue with firebird 3.0 embedded on 
linux

  

Thanks, Helen. Please see my replies inline.  

I am sure it is not 3.0 specific, 2.5 is the same. and the main issue is 
scalability, sequential transaction performance is actually pretty good, 
comparable to ESE store on windows I was comparing firebird against.  but when 
running multiple transactions in parallel, ESE perf increased from 4 tx/sec to 
26 tx/sec (128 byte/record, 200 records per transaction, 6 transaction threads 
on 6 cores, which I expect the best, logical cpu/ht is not very useful 
performance-wise), while firebird decreased. These transactions do not 
write-conflict with each other. 

The basic flow of our code is like, first the main function creates a database 
connection, and spawns multiple threads, passing in the database connection. 
Each thread does this: create a transaction using the db connection, do 
insertion of data, and commit the transaction. Each thread measures its own 
elapsed time. sp;





To: firebird-support@yahoogroups.com
From: firebird-support@yahoogroups.com
Date: Wed, 15 Jun 2016 19:04:33 +1200
Subject: Re: [firebird-support] performance issue with firebird 3.0 embedded on 
linux

  
Wednesday, June 15, 2016, 5:58:39 PM, Karol B. wrote:

> test without details say nothing to me
> 1. Did you compare results with e.g. FB2.5 in on the same maschine with same 
> configuration (FBConfig)
My project migrated from FB2.5 to FB3.0. I am pretty sure it is not 3.0 
specific. 

> 2. What is your page size and type of HDD?
SSD. 512GB Samsung EVO 850. The file system is ext4, block size 4096. 


> 3. Do you have BOST feature enabled on CPU and HT? -- Boost?
Yes, Turbo boost and hyper threading are enabled. 

> 4. Did you compare results on GLOBAL TEMPORARY TABLE - i know this is not the 
> same but can show some info?
Could you give me some details about how to use GLOBAL TEMPORARY TABLE? 


> 5. How do you test this times about your threads and how do you start them?
I used the monolithic time in code i.e. clock_gettime(CLOCK_MONOTONIC, )  on 
each thread to calculate the elapsed time. should be high resolution. 


> 6. Exact version of FB
Firebird-3.0.0.32483-0

and 7. If on Windows, how did you go about configuring CpuAffinityMask?
- which processors did you intend to set it for and what was the value you 
configured?
It's on Linux, I read from document that multiple processors are by default 
enabled. but I anyway set CpuAffinityMask to 4095, but it seems no change to 
performance. 

- did you try to do this configuration whilst an engine instance was running, 
without restarting?
No. each time I change configuration, I restart the program. 

HB

Re: [firebird-support] Engine12 mistery

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

The way I think of the Y-valve* is that the stem of the Y is the client -
whether the normal fbclient or the Java client or other language specific
clients.  The connection request goes from the client to a provider.
Right now, the providers are Remote (which may be built into the Y-valve)
and Engine12.  Someone could create a provider that translated Firebird
requests to Oracle/PostgreSQL/MySQL or whatever and offer a provider
to a different back end.  If there's enough demand, Firebird 2.5 could be
cut back to be a provider to older versions of Firebird.

So the stem is the client and the branches are the providers.

Cheers,

Ann

* Y-valve is a nautical term.  On a boat, the head (toilet) outflow goes
through
a Y-valve.  One leg takes the effluent to a holding tank, the other dumps it
overboard.  No parallel implied between what goes through the Firebird
Y-valve
and the nautical term.

On Tue, Jun 14, 2016 at 4:46 PM, fabia...@itbizolutions.com.au
[firebird-support]  wrote:

> 
>
>
> Mark
>
> Thank you, I think I am beggining to understand the concept, so the
> provider's have to be combined including ALWAYS Engine12 (the core FB
> server procedure/method that really goes to the file on disk and does the
> reading and writting to the DB). So the following combinations are valid:
> Providers = Remote + Engine12
> Providers = Loopback + Engine12
> Providers = Remote  + Loopback + Engine12 (the first two in any orther)
>
> And any Providers combination excluding Engine12 would not work because it
> is not including the component that goes to the DB file and reads/writes
> from /to it.
>
> It seems Engine12 is not the same "type of component" as the other
> Providers. In the documentation it is refered as a Y valve, if I understand
> it correctly Engine12 is the base of the Y, while the other providers are
> the top left and top right of the Y, you can have any top you want, BUT YOU
> MUST HAVE the base always, else it does not work, correct?
>
>
> Cheers,
> Fabian
>
>
>
> - Original Message -
> *From:* Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
> 
> *To:* firebird-support@yahoogroups.com
> *Sent:* Wednesday, June 15, 2016 5:32 AM
> *Subject:* Re: [firebird-support] Engine12 mistery
>
> On 2016-06-14 19:44, fabia...@itbizolutions.com.au [firebird-support]
> wrote:
> > My understanding from reading the documentation is:
> >
> > Provider = Remote means the client is on the network, excluding
> > 127.0.0.1
> > Provider = Loopback means the client is actually on the same OS
> > instance as the FB3 engine, and it is using the 127.0.0.1 to access
> > the database to avoid the "embedded server concept" from answering
> > the
> > request, as it would capture the DB file and will not allow any other
> > clients from remote /network source.
> > Engine12 = The local server takes control of the database as if it
> > was
> > an embedded server, killing all future chance of accessing the DB
> > from
> > the network, so Engine12 is if I understand correctly the way to talk
> > to the DB engine in "exclusive" mode when you want to perform
> > maintenance or work on the security database.
> >
> > Is the above wrong?
>
> Yes, your understanding is wrong. Engine12 **is** the component that
> actually does the work with the database file. The rest is just plumbing
> to connect to servers (or make fbclient connect to a local server),
> select the right provider, etc.
>
> As the release notes say:
>
> http://www.firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-engine.html
>
> * Remote (establish network connection)
> * Engine12 (main database engine)
> * Loopback (force network connection to the local server for  name> without an explicit network protocol being supplied).
>
> There was also talk of providing an 'Engine11' which would essentially
> be a Firebird 2.5 you could use to connect to ODS 11.2 and older
> database files.
>
> Your confusion likely stems from the fact that Firebird embedded now is
> fbclient + Engine12, as opposed to Firebird server + Engine12 for a
> normal database server, while Firebird embedded used to be a separate
> DLL/SO. BTW: In normal situations fbclient **does not** have access to
> Engine12, so it only behaves as a client library.
>
> Mark
>
>
>
> 
> 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] Case and Accent insensitive compares

[Paul Vinkenoog p...@vinkenoog.nl [firebird-support]]

Hello Stefan,

> I expect that an accent insensitive compare treats accented characters
> as the "same" as their un-accented counterparts because the accent
> does not change the character itself but things like pronounciation or
> stress.
>
> So in Frech, à is similar to a, é is similar to è and you use an
> accent insensitive compare to find Gérard even though your search term
> says Gerard (without the accent).
>
> However, in the German language, the letters Ö and O are two different
> characters with a completely different pronounciation (the same is
> true for A/Ä and U/Ü). As they look similar, the sorting is done so
> that they stay together, but they can _not_ be treated as accented
> versions of each other.

UNICODE_CI_AI is a generic, language-independent collation. Since
ö, ü and ä are not specific to German (they also exist in Dutch, for
instance, and ö and ä in Swedish, and ö and ü in Hungarian, etc.)
it will simply treat them as accented forms of o, u and a.

Also, it is questionable if you should consider a and ä different
letters, even in German. See e.g. 
https://de.wikipedia.org/wiki/Alphabetische_Sortierung

DIN 5007 Variante 1 (für Wörter verwendet, etwa in Lexika; Abschnitt 6.1.1.4.1)

ä und a sind gleich
ö und o sind gleich
ü und u sind gleich
ß und ss sind gleich

DIN 5007 Variante 2 (spezielle Sortierung für Namenslisten, etwa in 
Telefonbüchern; Abschnitt 6.1.1.4.2)

ä und ae sind gleich
ö und oe sind gleich
ü und ue sind gleich
ß und ss sind gleich

If you do want to treat them as different letters, you need a German
collation that does just that. However, this collation will not work
correctly with words in some other languages containing ä, ö and ü.


Cheers,
Paul Vinkenoog

RE: [firebird-support] performance issue with firebird 3.0 embedded on linux

[chen hsu chen...@outlook.com [firebird-support]]

Thanks, Helen. Please see my replies inline. 
I am sure it is not 3.0 specific, 2.5 is the same. and the main issue is 
scalability, sequential transaction performance is actually pretty good, 
comparable to ESE store on windows I was comparing firebird against.  but when 
running multiple transactions in parallel, ESE perf increased from 4 tx/sec to 
26 tx/sec (128 byte/record, 200 records per transaction, 6 transaction threads 
on 6 cores, which I expect the best, logical cpu/ht is not very useful 
performance-wise), while firebird decreased. These transactions do not 
write-conflict with each other. 
The basic flow of our code is like, first the main function creates a database 
connection, and spawns multiple threads, passing in the database connection. 
Each thread does this: create a transaction using the db connection, do 
insertion of data, and commit the transaction. Each thread measures its own 
elapsed time. 

To: firebird-support@yahoogroups.com
From: firebird-support@yahoogroups.com
Date: Wed, 15 Jun 2016 19:04:33 +1200
Subject: Re: [firebird-support] performance issue with firebird 3.0 embedded on 
linux














 

 



  



  
  
  Wednesday, June 15, 2016, 5:58:39 PM, Karol B. wrote:



> test without details say nothing to me

> 1. Did you compare results with e.g. FB2.5 in on the same maschine with same 
> configuration (FBConfig)
My project migrated from FB2.5 to FB3.0. I am pretty sure it is not 3.0 
specific. 


> 2. What is your page size and type of HDD?
SSD. 512GB Samsung EVO 850. The file system is ext4, block size 4096. 



> 3. Do you have BOST feature enabled on CPU and HT? -- Boost?
Yes, Turbo boost and hyper threading are enabled. 


> 4. Did you compare results on GLOBAL TEMPORARY TABLE - i know this is not the 
> same but can show some info?
Could you give me some details about how to use GLOBAL TEMPORARY TABLE? 



> 5. How do you test this times about your threads and how do you start them?
I used the monolithic time in code i.e. clock_gettime(CLOCK_MONOTONIC, )  on 
each thread to calculate the elapsed time. should be high resolution. 



> 6. Exact version of FB

Firebird-3.0.0.32483-0


and 7. If on Windows, how did you go about configuring CpuAffinityMask?

  - which processors did you intend to set it for and what was the value you 
configured?
It's on Linux, I read from document that multiple processors are by default 
enabled. but I anyway set CpuAffinityMask to 4095, but it seems no change to 
performance. 


  - did you try to do this configuration whilst an engine instance was running, 
without restarting?
No. each time I change configuration, I restart the program. 



HB







 









  
  

[firebird-support] Case and Accent insensitive compares

[Stefan Heymann li...@stefanheymann.de [firebird-support]]

I expect that an accent insensitive compare treats accented characters
as the "same" as their un-accented counterparts because the accent
does not change the character itself but things like pronounciation or
stress.

So in Frech, à is similar to a, é is similar to è and you use an
accent insensitive compare to find Gérard even though your search term
says Gerard (without the accent).

However, in the German language, the letters Ö and O are two different
characters with a completely different pronounciation (the same is
true for A/Ä and U/Ü). As they look similar, the sorting is done so
that they stay together, but they can _not_ be treated as accented
versions of each other.

When I use the UNICODE_CI_AI collation to compare them, Firebird
treats them as the same:

select case when 'a' = 'ä' collate unicode_ci_ai then 'equal' else 'not equal' 
end || ' expected: not equal' from rdb$database
union all
select case when 'O' = 'Ö' collate unicode_ci_ai then 'equal' else 'not equal' 
end || ' expected: not equal' from rdb$database
union all
select case when 'Ä' = 'ä' collate unicode_ci then 'equal' else 'not equal' end 
|| ' expected: equal' from rdb$database
union all
select case when 'a' = 'à' collate unicode_ci_ai then 'equal' else 'not equal' 
end || ' expected: equal' from rdb$database
union all
select case when 'c' = 'ç' collate unicode_ci_ai then 'equal' else 'not equal' 
end || ' expected: equal' from rdb$database
union all
select case when 'é' = 'è' collate unicode_ci_ai then 'equal' else 'not equal' 
end || ' expected: equal' from rdb$database

delivers:

equal expected: not equal
equal expected: not equal
equal expected: equal
equal expected: equal
equal expected: equal
equal expected: equal


Is there something that can be done to improve this?


Regards

Stefan

-- 
Stefan Heymann, Tübingen, Germany







++

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/

Re: [firebird-support] Schema pluses?

[Gabriel Frones grfro...@gmail.com [firebird-support]]

Firebird has no support for schemas, IIRC... or am I missing something?

Em dom, 12 de jun de 2016 às 18:18, 'livius' liviusliv...@poczta.onet.pl
[firebird-support]  escreveu:

>
>
> Hi,
>
> what are + and – with working with schema?
> What benefits are between
> schema_name__table_name and real schema implementation?
> schema_name.table_name
>
> I near to always have worked without schema databases or with only one
> schema in schema supported databases.
>
> regards,
> Karol Bieniaszewski
>
> 
>

[firebird-support] Re: Schema pluses?

[Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]]

13.06.2016 00:18, 'livius' wrote:
>
> what are + and – with working with schema?
> What benefits are between
> schema_name__table_name and real schema implementation?
> schema_name.table_name

Ability to have a default schema (per user, per connection). So that you 
may have multiple completely unrelated databases inside single physical 
database, and set up multiple "schema-less" users/applications of these 
different logical databases. E.g. one app works with USERS but actually 
it's CRM.USERS and a different app also works with USERS but actually 
it's HR.USERS. From the maintenance/administration POV it's a single 
database (configuration, backups, etc).


Dmitry

[firebird-support] Re: Schema pluses?

[liviuslivius liviusliv...@poczta.onet.pl [firebird-support]]

Hi,
 
anybody?
 
regars,
Karol Bieniaszewski
 
W dniu 2016-06-12 23:18:15 użytkownik livius  
napisał:
Hi,
 
what are + and – with working with schema?
What benefits are between
schema_name__table_name and real schema implementation?
schema_name.table_name
 
I near to always have worked without schema databases or with only one schema 
in schema supported databases.
 
regards,
Karol Bieniaszewski
 

Re: [firebird-support] Engine12 mistery

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

15.06.2016 14:19, fabia...@itbizolutions.com.au [firebird-support] wrote:
> When I omit Engine12 from the provider's list at the server's config, to 
> ensure the server
> always acts as a super server

   This way you ensured that server cannot work with databases at all. I.e. it 
cannot work 
as a server.


-- 
   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/

Re: [firebird-support] Engine12 mistery

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

Dimitry

> No. Y-valve is fbclient.dll. It loads providers as configured. If you don't 
> need to 
> work with databases directly, you can omit Engine from list of providers.
>  Firebird server (fbserver.exe) uses fbclient.dll the same way as any other 
> application

mmm, now we are back to my original question / problem. When I omit Engine12 
from the provider's list at the server's config, to ensure the server always 
acts as a super server, and never acts as an embedded server, the clients from 
other computers cannot connect via tcp-ip (ip.ip.ip.ip:port/databasename); so 
why is engine12 needed as a provider at the server's config? (Everybody already 
answered that question saying because it is the engine of the database, but you 
are saying it is only the embedded engine of the DB, correct?

Cheers,
Fabian



  - Original Message - 
  From: Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] 
  To: firebird-support@yahoogroups.com 
  Sent: Wednesday, June 15, 2016 6:56 PM
  Subject: Re: [firebird-support] Engine12 mistery


  14.06.2016 22:46, fabia...@itbizolutions.com.au [firebird-support] wrote:
  > It seems Engine12 is not the same "type of component" as the other 
Providers. In the
  > documentation it is refered as a Y valve, if I understand it correctly 
Engine12 is the
  > base of the Y, while the other providers are the top left and top right of 
the Y, you can
  > have any top you want, BUT YOU MUST HAVE the base always, else it does not 
work, correct?

 No. Y-valve is fbclient.dll. It loads providers as configured. If you 
don't need to 
  work with databases directly, you can omit Engine from list of providers.
 Firebird server (fbserver.exe) uses fbclient.dll the same way as any other 
application.

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

Re: [firebird-support] Engine12 mistery

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

14.06.2016 22:46, fabia...@itbizolutions.com.au [firebird-support] wrote:
> It seems Engine12 is not the same "type of component" as the other Providers. 
> In the
> documentation it is refered as a Y valve, if I understand it correctly 
> Engine12 is the
> base of the Y, while the other providers are the top left and top right of 
> the Y, you can
> have any top you want, BUT YOU MUST HAVE the base always, else it does not 
> work, correct?

   No. Y-valve is fbclient.dll. It loads providers as configured. If you don't 
need to 
work with databases directly, you can omit Engine from list of providers.
   Firebird server (fbserver.exe) uses fbclient.dll the same way as any other 
application.

-- 
   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/

Re: [firebird-support] performance issue with firebird 3.0 embedded on linux

[Helen Borrie hele...@iinet.net.au [firebird-support]]

Wednesday, June 15, 2016, 5:58:39 PM, Karol B. wrote:

> test without details say nothing to me
> 1. Did you compare results with e.g. FB2.5 in on the same maschine with same 
> configuration (FBConfig)
> 2. What is your page size and type of HDD?
> 3. Do you have BOST feature enabled on CPU and HT? -- Boost?
> 4. Did you compare results on GLOBAL TEMPORARY TABLE - i know this is not the 
> same but can show some info?
> 5. How do you test this times about your threads and how do you start them?
> 6. Exact version of FB

and 7. If on Windows, how did you go about configuring CpuAffinityMask?
  - which processors did you intend to set it for and what was the value you
  configured?
  - did you try to do this configuration whilst an engine instance was running,
  without restarting?

  HB