Thursday, 28 July 2016

[firebird-support] Firebird 3 performance

 

Hello,

I've got a question about the Firebird 3 performance. I've created a test
application which does the following:

FB 2.5.5 (Superclassic)

FB 3.0 (Superserver)

1.000.000 inserts

27 sec

47 sec

# of connections in 30 sec

~1800 connections

~1300 connections

Concurent reads 50 threads 100/queries / thread - average query time

1,35 ms

2,45 ms

Firbebird is installed local as 64-bit service. The database is on an SSD.

I was under the impression that the results should be the other way around.
Ergo, Firebird 3.0 should be a lot faster.

Am I doing something wrong?

Met vriendelijke groet,


E.G. (Gert) Scholten
Technisch Manager

Projectleider

+ 31 (0)528 82 00 55 (T)
+ 31 (0)528 82 00 59 (F)
04086914 (KvK)

Elbe 2
7908 HB Hoogeveen

<mailto:e.g.scholten@syntri.nl> e.g.scholten@syntri.nl (E)
<http://www.syntri.nl/> www.syntri.nl (I)



[Non-text portions of this message have been removed]

__._,_.___

Posted by: "Gert Scholten | Syntri ERP B.V." <e.g.scholten@syntri.nl>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

Save time and get your email on the go with the Yahoo Mail app
Get the beautifully designed, lighting fast, and easy-to-use Yahoo Mail today. Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

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/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

.

__,_._,___

No comments:

Post a Comment