Sunday, 1 May 2016

[firebird-support] Re: Migrating from Super Classic FB 2.5.2 to SuperServer FB 3.0 could have a problems

 

01.05.2016 19:49, trskopo@yahoo.com wrote:
>
> This is the Query plan from SS FB 3.0
>
> PLAN (GET_STCK NATURAL)

This is just a different output for select from procedure GET_STCK, v3.0
does not show all its internals as v2.5 did.

You'd better compare per table performance counters (indexed/non-indexed
reads) after execution.

> This could be a big problem, all queries/stored procedures/triggers must
> be test again for its performance.

This is always required when migrating to the new major version.

Dmitry

__._,_.___

Posted by: Dmitry Yemanov <dimitr@users.sourceforge.net>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (6)

Upgrade your account with the latest Yahoo Mail app
Get organized with the fast and easy-to-use Yahoo Mail app. Upgrade today!

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

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