[firebird-support] Re: Problem installing Firebird 2.5.8

2018-11-12 Thread em...@tot-consult.com [firebird-support]
I had a similar problem, although with a different error messages. I had to rename the package (amd64 -> x86_64) and forc the installation with rpm -ivh --force --nodeps FirebirdSS-2.5.8.27089-0.x86_64.rpm and now it works OK on my system. The Firebird 2.5.8 rpm has some problems on

[firebird-support] Problem installing Firebird 2.5.8

2018-11-12 Thread carlosemazarieg...@gmail.com [firebird-support]
Hi. I am trying to install Firebird 2.5.8 (FirebirdSS-2.5.8.27089-0.amd64.rpm), but I get the following error: the file / installation of FirebirdSS-2.5.8.27089-0.amd64 conflicts with the package file filesystem-3.2-25.el7.x86_64 I have: Linux Centos 7.5.1804 Kernel

ODP: ODP: [firebird-support] Converting dates and the ISO-8601 format

2018-11-12 Thread Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support]
>> Yes but in the scenario you describe - all computers are on the same network. No, you can have web server on e.g. shared hosting and you can connect to it from every place. You can show web page on your phone, tablet … Regards, Karol Bieniaszewski

Re: [firebird-support] Speed difference 2.5.3 - 2.5.7

2018-11-12 Thread André Knappstein knappst...@beta-eigenheim.de [firebird-support]
Svein and Karol (not Livius, sorry), no it's not a secret. I have a complete turnkey, in separate FDB, since I need it to create some C# examples for students on different machines anyway, and if you want I can share it. But - before you're wasting precious time: I already know, why the

Re: ODP: [firebird-support] Converting dates and the ISO-8601 format

2018-11-12 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
12.11.2018 15:10, i...@synapsesoftware.co.uk [firebird-support] wrote: > Yes but in the scenario you describe - all computers are on the same network. > I need to be > able to connect to a remote server. I have mobile devices that need to > communicate with > the database (over a mobile

Re: ODP: [firebird-support] Converting dates and the ISO-8601 format

2018-11-12 Thread i...@synapsesoftware.co.uk [firebird-support]
Yes but in the scenario you describe - all computers are on the same network. I need to be able to connect to a remote server. I have mobile devices that need to communicate with the database (over a mobile network.) So unfortunately, I dont think I could manage with the embedded approach,

Re: [firebird-support] Speed difference 2.5.3 - 2.5.7

2018-11-12 Thread Svein Erling Tysvær setys...@gmail.com [firebird-support]
Almost seems like the PI_T_INVOICES is lacking or not active. Either that or that the part of it being used for the query in question has lousy selectivity. It is not unusual for the optimizer to think that two PLANs are almost equally good and then sometimes make a terrible choice, but I'm

Re: ODP: [firebird-support] Converting dates and the ISO-8601 format

2018-11-12 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
Please define local/remote here.For mee, it looks like this.On shared hosting i have web server e.g IIS. This web server operate locally with embeded Firebird server. Remote are only connections from clients to those web server. All is working for me without any problems.Regards,Karol

Re: [firebird-support] Speed difference 2.5.3 - 2.5.7

2018-11-12 Thread André Knappstein knappst...@beta-eigenheim.de [firebird-support]
Livius, thank you. And: cool! You obviously have hit *something*. I learned before on different groups and seminars, that when comparing different execution times you better start by looking at the plans... only... I usually don't :-) So, the question needs to be changed from: "Was there

Re: [firebird-support] Speed difference 2.5.3 - 2.5.7

2018-11-12 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
Probably difference in query plans.Show query plan for both server versionsRegards,Karol Bieniaszewski Oryginalna wiadomość Od: "André Knappstein knappst...@beta-eigenheim.de [firebird-support]" Data: 12.11.2018 12:01 (GMT+01:00) Do: firebird-support@yahoogroups.com Temat:

[firebird-support] Speed difference 2.5.3 - 2.5.7

2018-11-12 Thread André Knappstein knappst...@beta-eigenheim.de [firebird-support]
Hello all, for a local conference, Iampreparing a session for a Firebird beginners' group, to demonstrate the basics of Stored Procedures and their usage from different clients. One scenario is about transforming a *slightly* complex sql query into a selectable stored