Re: [Firebird-devel] ODP: Performance - 2.5 vs 3.0 vs 4.0

2019-01-24 Thread Gabor Boros
2019. 01. 24. 13:12 keltezéssel, Karol Bieniaszewski írta: Do you have permanent (dummy) connection to Firebird3 SS database? If not connect to database and then run test. Permanent connection cause to do not clear SuperServer cache. I just start the Firebird server then the ISQL session(s)

Re: [Firebird-devel] Performance - 2.5 vs 3.0 vs 4.0

2019-01-24 Thread Gabor Boros
2019. 01. 24. 9:50 keltezéssel, Gabor Boros írta: I will execute my ISQL cases with 2.5 SS and 2.5 SC on a real HDD. We will see... - 1 ISQL 1 DB 2.5 SS - 3:03 2.5 SC - 3:08 - 5 ISQL 1 DB 2.5 SS - 11:13 2.5 SC - 7:28 - 5 ISQL 5 DB 2.5 SS - 11:11 2.5 SC - 7:22 Gabor Firebird-Devel

Re: [Firebird-devel] fb_shutdown in embedded mode

2019-01-24 Thread Vlad Khorsun
24.01.2019 16:14, Adriano dos Santos Fernandes wrote: On 24/01/2019 12:00, Vlad Khorsun wrote: 24.01.2019 15:13, Jiří Činčura wrote: Vlad, is it OK to call this method multiple times (nothing else is called in between)?   Yes. All calls after first one is (almost) no-op I'm asking because

Re: [Firebird-devel] fb_shutdown in embedded mode

2019-01-24 Thread Dimitry Sibiryakov
24.01.2019 15:14, Adriano dos Santos Fernandes wrote: But if we have some libraries in the application loading Firebird, and the application writer does not have total control of that, two libraries may load Firebird and when one of them calls the shutdown function, the other will not work

Re: [Firebird-devel] fb_shutdown in embedded mode

2019-01-24 Thread Adriano dos Santos Fernandes
On 24/01/2019 12:20, Jiří Činčura wrote: >> But if we have some libraries in the application loading Firebird, and >> the application writer does not have total control of that, two >> libraries may load Firebird and when one of them calls the shutdown >> function, the other will not work anymore.

Re: [Firebird-devel] fb_shutdown in embedded mode

2019-01-24 Thread Adriano dos Santos Fernandes
On 24/01/2019 12:00, Vlad Khorsun wrote: > 24.01.2019 15:13, Jiří Činčura wrote: >> Vlad, is it OK to call this method multiple times (nothing else is >> called in between)? > >   Yes. All calls after first one is (almost) no-op > >> I'm asking because some application might load same library

Re: [Firebird-devel] fb_shutdown in embedded mode

2019-01-24 Thread Vlad Khorsun
24.01.2019 15:13, Jiří Činčura wrote: Vlad, is it OK to call this method multiple times (nothing else is called in between)? Yes. All calls after first one is (almost) no-op I'm asking because some application might load same library using different paths via symlinks. And at least

Re: [Firebird-devel] fb_shutdown in embedded mode

2019-01-24 Thread Jiří Činčura
Vlad, is it OK to call this method multiple times (nothing else is called in between)? I'm asking because some application might load same library using different paths via symlinks. And at least Windows (haven't tested Mac or Linux) is smart enough to load it just once, but I see it from user

[Firebird-devel] ODP: Performance - 2.5 vs 3.0 vs 4.0

2019-01-24 Thread Karol Bieniaszewski
Do you have permanent (dummy) connection to Firebird3 SS database? If not connect to database and then run test. Permanent connection cause to do not clear SuperServer cache. Regards, Karol Bieniaszewski Od: Gabor Boros Wysłano: czwartek, 24 stycznia 2019 10:30 Do:

[Firebird-devel] [FB-Tracker] Created: (CORE-5992) Cannot create multiple tables concurrently

2019-01-24 Thread Gabor Boros (JIRA)
Cannot create multiple tables concurrently -- Key: CORE-5992 URL: http://tracker.firebirdsql.org/browse/CORE-5992 Project: Firebird Core Issue Type: Bug Components: Engine Affects

Re: [Firebird-devel] Performance - 2.5 vs 3.0 vs 4.0

2019-01-24 Thread Paul Reeves
On Thu, 24 Jan 2019 10:49:14 +0300 Roman Simakov wrote: > чт, 24 янв. 2019 г. в 10:25, liviuslivius > : > > > > Hi. > > > > I have thinked about oltp comparision, and i think that comparing > > e.g. classic vs superserver on RAM disc is wrong. Why? Because read > > from "disc" is as fast as read

Re: [Firebird-devel] Performance - 2.5 vs 3.0 vs 4.0

2019-01-24 Thread Lester Caine
On 24/01/2019 09:01, Doychin Bondzhev wrote: Many small installations are on hdd. My first reaction was that HDD is still the more common base for systems, and for large volumes of data I think that will be the case for a while yet? But I've been adding SSD's as the boot disk on my servers

[Firebird-devel] [FB-Tracker] Created: (CORE-5991) Trace could not work correctly with quoted file names in trace configurations

2019-01-24 Thread Vlad Khorsun (JIRA)
Trace could not work correctly with quoted file names in trace configurations - Key: CORE-5991 URL: http://tracker.firebirdsql.org/browse/CORE-5991 Project: Firebird Core

Re: [Firebird-devel] Performance - 2.5 vs 3.0 vs 4.0

2019-01-24 Thread Slavomir Skopalik
V3 super server should be compared with V2.5 super classic. Slavek 2.5 - 10:55 3.0 -  8:11 4.0 -  8:41 Same script with numbered(1..5) table names into one database concurrently: 2.5 - 10:51 - 336.72 MB 3.0 -  8:09 - 329.79 MB 4.0 -  8:45 - 329.79 MB i.e. v3 finally becomes faster than

Re: [Firebird-devel] Performance - 2.5 vs 3.0 vs 4.0

2019-01-24 Thread Gabor Boros
2019. 01. 24. 8:27 keltezéssel, Dmitry Yemanov írta: i.e. v3 finally becomes faster than v2.5, but v4 is slower than v3 (while faster than v2.5) Correct? Yes. But 2.5 SC beats them all. I made a graph from the results. The numbers are seconds and the smaller is the better. Gabor

Re: [Firebird-devel] Performance - 2.5 vs 3.0 vs 4.0

2019-01-24 Thread Doychin Bondzhev
Many small installations are on hdd. On Thu, Jan 24, 2019, 10:57 Alex Peshkoff via Firebird-devel < firebird-devel@lists.sourceforge.net wrote: > On 1/24/19 11:50 AM, Gabor Boros wrote: > > 2019. 01. 24. 8:24 keltezéssel, liviuslivius írta: > >> Hi. > >> > >> I have thinked about oltp

Re: [Firebird-devel] Performance - 2.5 vs 3.0 vs 4.0

2019-01-24 Thread Alex Peshkoff via Firebird-devel
On 1/24/19 11:50 AM, Gabor Boros wrote: 2019. 01. 24. 8:24 keltezéssel, liviuslivius írta: Hi. I have thinked about oltp comparision, and i think that comparing e.g. classic vs superserver on RAM disc is wrong. Why? Because read from "disc" is as fast as read from cache. The comparision can

Re: [Firebird-devel] Performance - 2.5 vs 3.0 vs 4.0

2019-01-24 Thread Alex Peshkoff via Firebird-devel
On 1/24/19 10:24 AM, liviuslivius wrote: Because read from "disc" is as fast as read from cache. That's worth testing for particular SSD. For example my SSD (WDS240G1G0B) works a few times slower than RAM disk. Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Performance - 2.5 vs 3.0 vs 4.0

2019-01-24 Thread Gabor Boros
2019. 01. 24. 8:24 keltezéssel, liviuslivius írta: Hi. I have thinked about oltp comparision, and i think that comparing e.g. classic vs superserver on RAM disc is wrong. Why? Because read from "disc" is as fast as read from cache. The comparision can show some problems but results must be

[Firebird-odbc-devel] Rch vom 24/01/2019

2019-01-24 Thread Michael von Boetticher
Sehr geehrter Kunde, Zu Ihrer Vorkasse / Zahlung über EUR 95,94 gibt es keine Rechnung. Vielleicht wurde hier irrtümlich eine Vorkasse ausgestellt. Vorkasse vom 27.12.2018 wurde wohl doppelt überwiesen, 3.01.2019 und 9.01.2019. Sie können die Rechnung über diesen Link herunterladen.