How to (optionally) get Firebird 3 query plan?

Discussion of open issues, suggestions and bugs regarding IBDAC (InterBase Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
upscene
Posts: 306
Joined: Thu 19 Oct 2006 08:13

How to (optionally) get Firebird 3 query plan?

Post by upscene » Wed 28 Feb 2018 12:33

Hi,

Firebird 3 has a new query plan, see https://firebirdsql.org/file/documentat ... utput.html

According to the Firebird support list, you can get the new plan output programmatically
"Pass isc_info_sql_explain_plan (value 26) into isc_dsql_info() instead of isc_info_sql_get_plan (value 22)"

Any way this can be done using the component set yet?

With regards,

Martijn Tonies

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: How to (optionally) get Firebird 3 query plan?

Post by ViktorV » Wed 28 Feb 2018 14:54

At the moment, IBDAC does not support the installation of isc_info_sql_get_plan. We will consider the possibility of adding this functionality. We will consider a possibility of the specified functionality in one of the next IBDAC version. If you want us to implement the feature, please post it at our user voice forum: https://devart.uservoice.com/forums/104 ... e-firebird. If the suggestion gets a lot of votes, we will consider the possibility to implement it.

upscene
Posts: 306
Joined: Thu 19 Oct 2006 08:13

Re: How to (optionally) get Firebird 3 query plan?

Post by upscene » Tue 06 Mar 2018 08:17

This is an important Firebird 3 feature. Why should people have to 'vote' for this? It should be part of the readiness of your component set for Firebird 3.

With regards,

Martijn Tonies

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: How to (optionally) get Firebird 3 query plan?

Post by ViktorV » Tue 06 Mar 2018 13:45

We plan to add isc_info_sql_get_plan in one of the next releases of IBDAC.

upscene
Posts: 306
Joined: Thu 19 Oct 2006 08:13

Re: How to (optionally) get Firebird 3 query plan?

Post by upscene » Tue 06 Mar 2018 13:48

Thank you, please make it optional, as parsing the new output is very different, and it's much longer too.

With regards,

Martijn Tonies

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: How to (optionally) get Firebird 3 query plan?

Post by ViktorV » Tue 06 Mar 2018 13:56

We plan to add isc_info_sql_get_plan in one of the next releases of IBDAC.

Post Reply