Some sample scripts for testing

[Hernan Cano]

Hi, friends.

I am interested in using FireBird as a database manager for my apps.

And I want to write some kind of tests for verifying its performance.

Could you show me some kind of doc about this, where I can read about the best way to write a lot of test-sentences that can take advantage of the better concepts in FireBird, or some RDBMS?

Thanks.

[Karol Bieniaszewski]

Hi

 

It is really too broad question. Better for what usage case? What you need from such RDBMS?

You can compare performance as single statement running explicitly or multimple statements one by one, simple queries or complicated one, multiple connections with one statement, multiple connections with multiple, multiple connections with multiple but totally random statements.

You can compare time taken, numer of queries, resources used...

You can also compare how easy it is to use, configure and admin it.

You can compare in wihich other scenarion you can use some DB as eg. Firebird Embeded.

And other comparision…

 

regards,

Karol Bieniaszewski

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/c6b0bc6e-2d29-48b1-b91f-cdfc66a1c39bn%40googlegroups.com.

 

[Dimitry Sibiryakov]

07.02.2021 06:56, Hernan Cano wrote:
> Could you show me some kind of doc about this, where I can read about the best way to
> write a lot of test-sentences that can take advantage of the better concepts in FireBird,
> or some RDBMS?

Start from learning script used for Firebird testing.

https://github.com/FirebirdSQL/fbt-repository
https://github.com/FirebirdSQL/oltp-emul

--
WBR, SD.

[Hernan Cano]

Thanks, Karol.

I could/should try any of what you say.

If there is only one of what you say, it will be enough for me.

[Hernan Cano]

Fine, Dimitry.

I am reviewing the URLs you propose me.

Very complex, but I am reading....

--

[Hernan Cano]

Hi, friends.

In second URL I found "oltp-emul-praha-2014.ppt" that is near what I want to develop. I page 26 are described the scenarios.

But I couldnot find the SQL sentences that one need to run.

In the first URL I can find a lot, but there is not any description that guides me to what is the objective.

In   www.sqlite.org/sqllogictest/doc/trunk/about.wiki   and   

in   www.sqlite.org/draft/speed.html    

I can find a very good explanation of a series of test, but these are in a SQLite-environments. I can take the SQL sentences but I lack the improvements for FireBird.

Thanks, Dimitry and Karol, for helping.