UDFs declared with large varchars take excessive time to execute
----------------------------------------------------------------
Key: CORE-5314
URL: http://tracker.firebirdsql.org/browse/CORE-5314
Project: Firebird Core
Issue Type: Bug
Components: UDF
Affects Versions: 2.5.6
Environment: Windows
Reporter: Paul Reeves
UDFs declared with large varchars take excessive time to execute
An IBPhoenix client reported the following problem to us.
A single udf, when declared with a 32k string length takes 20 times longer to
execute than the same udf declared with a 16k string length.
Likewise, declaring the UDF with a string length of 1K takes half the time
again.
Here is a quick summary of the times:
f_strpos_huge - 60s
f_strpos_middling - 3s
f_strpos_1024 - 1.5s
In all cases the same actual function was executed. The only difference was in
the declaration.
I have a test case which demonstrates the problem.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are
consuming the most bandwidth. Provides multi-vendor support for NetFlow,
J-Flow, sFlow and other flows. Make informed decisions using capacity planning
reports.http://sdm.link/zohodev2dev
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
