> Test was run on Windows 2003, P4 2.8GHz, FirebirdSql 1.5RC7
> Database contains 20,283 rows
>
> Query Time
> ------------------------------------------------
> Prepare : 15
> Execute : 172
> Avg fetch time: 172.00 ms
>
> Memory
> ------------------------------------------------
> Current: 1,099,248
> Max : 1,196,224
> Buffers: 2,048
>
> Operations
> ------------------------------------------------
> Read : 7,313
> Writes : 4
> Fetches: 136,397
>
> Plan:
> ------------------------------------------------
> PLAN (ABNTRADEDATA NATURAL)
> PLAN (ABNTRADEDATA NATURAL)
> PLAN (ABNTRADEDATA NATURAL)
> PLAN (RDB$DATABASE NATURAL)
>
> Enchanced Info:
> +--------------------------+-------+-----------+---------+--------
> -+----------+
> | Table Name | Index | Non-Index | Updated | Deleted |
> Inserted |
> | | reads | reads | | |
> |
> +--------------------------+-------+-----------+---------+--------
> -+----------+
> | RDB$FIELDS| 13 | 0 | 0 | 0 |
> 0 |
> | RDB$INDEX_SEGMENTS| 1 | 0 | 0 | 0 |
> 0 |
> | RDB$RELATION_FIELDS| 13 | 0 | 0 | 0 |
> 0 |
> | RDB$RELATIONS| 2 | 0 | 0 | 0 |
> 0 |
> | RDB$RELATION_CONSTRAINTS| 1 | 0 | 0 | 0 |
> 0 |
> | RDB$DATABASE| 0 | 1 | 0 | 0 |
> 0 |
> | ABNTRADEDATA| 0 | 60,849 | 0 | 0 |
> 0 |
> +--------------------------+-------+-----------+---------+--------
> -+----------+
>
>
>
>
>
> Query Time
> ------------------------------------------------
> Prepare : 15
> Execute : 94
> Avg fetch time: 94.00 ms
>
> Memory
> ------------------------------------------------
> Current: 1,065,624
> Max : 1,196,224
> Buffers: 2,048
>
> Operations
> ------------------------------------------------
> Read : 4,865
> Writes : 4
> Fetches: 90,887
>
> Plan:
> ------------------------------------------------