[firebird-support] Re: What is the difference between these connection strings?

[brucedickin...@wp.pl [firebird-support]]

Thanks Helen for the nice explanation.

Out of curiosity I need to check what do you write about connections and these 
protocols in your books. :)

The thing is that I am not able to find any information about XNET in the 
Internet. I've looked thorougly. Could you point me to any reliable source that 
describes this protocol?

Re: [firebird-support] Firebird performance question

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

Hi Bill,

If your application and database are the same and and you using them in 
the same manner with the same Firebird configuration 
(http://ib-aid.com/en/optimized-firebird-configuration/), the difference 
in performance is always explained by hardware - either hardware problem 
(like absence of BBU on RAID) or absence of necessary (modern) drivers.


Moreover, 2008r2 has the same core as W7, and even can be tuned to look 
and act like W7:

http://www.win2008workstation.com/

If you want more detailed answer, you should provide exact details, 
according the questions here

http://ib-aid.com/required-information-for-firebird-database-performance-optimization

Regards,
Alexey Kovyazin
IBSurgeon



Hi,

We have been using Firebird Super Server version 1.5.6 on both Windows 
7 (64 Bit) and Server 2008 (64 Bit).  Both systems are the same except 
for the OS and they have 2 CPUs and about 4 gig of RAM. We have 
noticed that any applications, with large multiple writes, is much 
faster on Windows 7 than on Server 2008.  I know there is newer 
version and we are planning to upgrade the Firebird, but is there 
something missing on 2008 that would improve the performance. Also, 
when we upgrade to version 2.5, would we see similar performance 
between Windows 7 and Server 2008?


Thanks,

Bill

*Bill Newhall | Technical Director | MedAssets*
153 Cordaville Rd., Suite 110 | Southborough, MA, 01772 | Work: 
508.460.8524| Mobile: 617.515.3073 | Fax: 508.460.8539

bnewh...@medassets.com 
Visit us at www.medassets.com 
Follow us on LinkedIn , 
YouTube , Twitter 
, and Facebook 



*
**Attention***
This electronic transmission may contain confidential, sensitive, 
proprietary and/or privileged information belonging to the sender. 
This information, including any attached files, is intended only for 
the persons or entities to which it is addressed. Authorized 
recipients of this information are prohibited from disclosing the 
information to any unauthorized party and are required to properly 
dispose of the information upon fulfillment of its need/use, unless 
otherwise required by law. Any review, retransmission, dissemination 
or other use of, or taking of any action in reliance upon this 
information by any person or entity other than the intended recipient 
is prohibited. If you have received this electronic transmission in 
error, please notify the sender and properly dispose of the 
information immediately.


*/[Marius Labuschagne] /*

*/Hi Bill, I don’t have the answer, but will also keep an eye on this 
question. /*


*/What I can tell you as that I am running my Client sites on 2.5.3 
Superserver, some Clients with 2008 Server, and some using Desktop 
machines with Windows 7 on it as Server machines./*


*/And without fail the Windows 7 machines outperforms the 2008 Server 
machines by magnitudes. There are a lot of discussions you can find 
about this, but I was not able yet to find a solid solution to this 
problem./*


*/Regards/*

*/Marius/*

Re: [firebird-support] Re: What is the difference between these connection strings?

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

At 08:55 p.m. 2/10/2014, brucedickin...@wp.pl [firebird-support] wrote:


>Thanks Helen for the nice explanation.
>
>Out of curiosity I need to check what do you write about connections and these 
>protocols in your books. :)

That's a good idea. ;-) Volume 1 Chapter 3.


>The thing is that I am not able to find any information about XNET in the 
>Internet. I've looked thorougly. Could you point me to any reliable source 
>that describes this protocol? 

No, I can't.  My understanding is that XNET is a customisable application 
space/subsystem on Windows that developers can use for their own purposes.  If 
you want to know more about XNET and Firebird's use of it, firebird-devel will 
be the place to ask.  I'm fairly sure Dmitry Yemanov did the main part of the 
implementation.

Helen

[firebird-support] Re: What is the difference between these connection strings?

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

02.10.2014 11:55, brucedickin...@wp.pl wrote:
>
> The thing is that I am not able to find any information about XNET in
> the Internet. I've looked thorougly. Could you point me to any reliable
> source that describes this protocol?

XNET is just a Firebird specific abbrevation, WNET (aka Named Pipes) and 
INET (aka TCP/IP) belong to the same category.

Technically speaking, XNET is a homebrew implementation of the shared 
memory channel between processes.


Dmitry

[firebird-support] Re: What is the difference between these connection strings?

[brucedickin...@wp.pl [firebird-support]]

Thanks again Helen:) Now I feel kinda embarassed because I should check it 
before creating this topic, but for the other hand..I wouldn't get Dmitry's 
attention;) so..I will use the occasion and ask:

Dmitry, few years ago there was a rumour that connecting through TCP/IP was 
slower than through XNET / pipes. Could you clarify on this? Is there any 
difference in terms of performance when retrieving/inserting data from/to 
database depending on the protocol?

[firebird-support] "wait" vs "nowait" on meta data statements

['Martijn Tonies (Upscene Productions)' m.ton...@upscene.com [firebird-support]]

Hi all,

I noticed that with Classic 2.5, you can get “object in use” when trying to 
modify a
stored procedure that’s been previously executed, see also:
http://tracker.firebirdsql.org/browse/CORE-4016


When using “wait” on the transaction to save the procedure, instead of 
“nowait”, 
the problem goes away.

Is it safe to always use “wait” on such transactions?

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

[firebird-support] Re: What is the difference between these connection strings?

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

02.10.2014 16:24, brucedickin...@wp.pl wrote:

> Dmitry, few years ago there was a rumour that connecting through TCP/IP
> was slower than through XNET / pipes. Could you clarify on this? Is
> there any difference in terms of performance when retrieving/inserting
> data from/to database depending on the protocol?

I don't know for sure about WNET/pipes, this protocol is not commonly used.

But XNET/shmem is really known to be faster than INET/tcp, at least 
before http://tracker.firebirdsql.org/browse/CORE-4563 is implemented.

However, it has its own drawbacks, see 
http://tracker.firebirdsql.org/browse/CORE-4567.


Dmitry

Re: [firebird-support] Compile Firebird-2.5.3 with Ptxdist for ARM

[Frank Schlottmann-Gödde fr...@schlottmann-goedde.de [firebird-support]]

On 01.10.2014 14:28, Mathias Stucki mathias.stu...@fasnacht.biz 
[firebird-support] wrote:
>
>
> Hello,
>
> I am trying to compile Firebird-2.5.3 with ptxdist-2014.09.0, using
> OSELAS.Toolchain-2013.12.2.
>
> Unfortunately I’m getting a lot of compile errors:

Well, the build process for FB2.5 isn't fit for cross-compiling.

You may either create a build environment on your embedded system or use 
qemu to create an emulation and build it there.

A short tutorial (in german language for a raspberry pi) can be found here:

http://www.forum-raspberrypi.de/Thread-firebird-sql-server-compilieren

hth

Frank

-- 
"Fascinating creatures, phoenixes, they can carry immensely heavy loads,
   their tears have healing powers and they make highly faithful pets."
   - J.K. Rowling

[firebird-support] Issue with firebird 2.5.3 setup exe for windows

[Peter Saric peter...@rocketmail.com [firebird-support]]

I have a customer who is trying to setup fb 2.5.3 on his server. He has fb 1.5 
installed on the server, so is trying to install fb 2.5 to run as an 
application; however, the setup does not display the Select Additional Tasks 
form where fb can be setup to run as an application. It works fine on our PCs 
displaying the Select Additional Tasks page as expected. Can anyone shed any 
light on why this page in the setup is not being displayed on our customers?
Many Thanks for any assistance.

[firebird-support] Re: What is the difference between these connection strings?

[brucedickin...@wp.pl [firebird-support]]

Thank you.