| Subject | Re: Odp: [firebird-support] Performance of Firebird (Superserver vs Superclassic, etc.) |
|---|---|
| Author | |
| Post date | 2014-10-29T22:19:29Z |
There are 46,527 records in the main table, but the calculation touches many other tables. Here is a copy of the analysis of the main procedure from IB Expert:
Query
------------------------------------------------
Plan
------------------------------------------------
Query Time
------------------------------------------------
Prepare : 156.00 ms
Execute : 16.00 ms
Avg fetch time: 16.00 ms
Memory
------------------------------------------------
Current: 9,821,456
Max : 9,951,376
Buffers: 75
Operations
------------------------------------------------
Read : 2,083
Writes : 3
Fetches: 44,488
Marks : 13
Enchanced Info:
+-------------------------------+-----------+-----------+-------------+---------+---------+---------+----------+----------+----------+
| Table Name | Records | Indexed | Non-Indexed | Updates | Deletes | Inserts | Backouts | Purges | Expunges |
| | Total | reads | reads | | | | | | |
+-------------------------------+-----------+-----------+-------------+---------+---------+---------+----------+----------+----------+
|CODERATES | 43591 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
|CODES | 18127 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
|CODEVALIDATIONS | 88777 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
|CODEVALRATES | 38319 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
|IMPROVEMENTHEADER | 74804 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
|INCOMEHEADER | 9842 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
|LOCATION_TABLEEXT | 2450 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
|MARKETLANDHEADER | 35886 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
|MUNICIPALITIES | 15 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
|PROPERTYHEADER | 46527 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
|TAXPASSOFF | 603366 | 78 | 0 | 4 | 0 | 0 | 0 | 1 | 0 |
+-------------------------------+-----------+-----------+-------------+---------+---------+---------+----------+----------+----------+
Query
------------------------------------------------
Plan
------------------------------------------------
Query Time
------------------------------------------------
Prepare : 156.00 ms
Execute : 16.00 ms
Avg fetch time: 16.00 ms
Memory
------------------------------------------------
Current: 9,821,456
Max : 9,951,376
Buffers: 75
Operations
------------------------------------------------
Read : 2,083
Writes : 3
Fetches: 44,488
Marks : 13
Enchanced Info:
+-------------------------------+-----------+-----------+-------------+---------+---------+---------+----------+----------+----------+
| Table Name | Records | Indexed | Non-Indexed | Updates | Deletes | Inserts | Backouts | Purges | Expunges |
| | Total | reads | reads | | | | | | |
+-------------------------------+-----------+-----------+-------------+---------+---------+---------+----------+----------+----------+
|CODERATES | 43591 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
|CODES | 18127 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
|CODEVALIDATIONS | 88777 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
|CODEVALRATES | 38319 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
|IMPROVEMENTHEADER | 74804 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
|INCOMEHEADER | 9842 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
|LOCATION_TABLEEXT | 2450 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
|MARKETLANDHEADER | 35886 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
|MUNICIPALITIES | 15 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
|PROPERTYHEADER | 46527 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
|TAXPASSOFF | 603366 | 78 | 0 | 4 | 0 | 0 | 0 | 1 | 0 |
+-------------------------------+-----------+-----------+-------------+---------+---------+---------+----------+----------+----------+