Gradual slowdown compilation (create, recreate or drop) of views
----------------------------------------------------------------
Key: CORE-5612
URL: http://tracker.firebirdsql.org/browse/CORE-5612
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0.2, 2.5.7
Reporter: Rashid Abzalov
Attachments: BUILD.sql
With a large number of existing views, the compilation of new views (or drop
existing) is very slow and the time increases as the number of views increases.
Time for create 1 view:
- on empty database: 0.2s
- 50 view already exist: 1s
- 100 view already exist: 1.7s
- 200 view already exist: 3.3s
The CPU load (1 core) is 100%, and the time is almost independent of the
computer configuration, i.e. that on the server with 2 Xeon processors, 64Gb of
memory and hardware RAID, that on the usual desktop.
When creating real databases ~ 1000-1500 view, creating 1 view gradually slows
down ~ from 30 sec. up to 1 min.
On real databases ~1000 view, creating 1 view takes ~ from 30 seconds up to 1
min.
Approximate number of records in real databases:
RDB$DEPENDENCIES ~ 1 000 000
RDB$RELATION_FIELDS ~ 300 000
RDB$RELATIONS ~ 3 500
--
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
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
