External data source selects became slow
----------------------------------------
Key: CORE-5104
URL: http://tracker.firebirdsql.org/browse/CORE-5104
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0 RC1
Environment: Windows 32bit, Firebird superserver with default
configuration
Reporter: michalk1
Since original FB3.0 RC1 release the execution of external selects became
very slow. It seems that the connection is now not reused anymore and a new one
is opened with every select. Ie., the following simple statement, which in FB
3.0.0.32136 was able to run 500 times per second, in the current snapshot build
3.0.0.32323 went down to 6/s.
EXECUTE BLOCK RETURNS (Cnt INTEGER) AS
begin
EXECUTE STATEMENT 'SELECT COUNT (*) FROM RDB$DATABASE'
ON EXTERNAL DATA SOURCE 'C:\TestDb.Fdb'
WITH COMMON TRANSACTION
AS USER 'sysdba' PASSWORD 'masterkey'
INTO :Cnt;
suspend;
end
Btw., the database connect itself is now slower than is used to be in FB 2.5.
Where FB2.5 made 15 connections/second (connect and disconnect repeatedly),
FB3.0 now does just 5 per second. But for common attachments this is probably
not as important (can be workaround with connection pool if needed).
--
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
------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
