>
> Let me ask the obvious first...
>
> What is the filename you are using ?
>

The filename is test.fdb. So, it shouldn't be the gdb issue.

By the way, I used FlameRobin to collect some statistics.

For the 1st SQL after starting FB, the statistics is as follows:

Starting transaction...
Preparing query: select * from doc where doc_id=1000 order by doc_id
Prepare time: 00:00:05.
Field #01: DOC.DOC_ID Alias:DOC_ID Type:INTEGER
Field #02: DOC.DOC_TYPE Alias:DOC_TYPE Type:INTEGER
Field #03: DOC.DOC_SUBTYPE Alias:DOC_SUBTYPE Type:INTEGER
Field #04: DOC.DOC_DATE Alias:DOC_DATE Type:DATE
Field #05: DOC.DOC_XML Alias:DOC_XML Type:BLOB SUB_TYPE 1
PLAN (DOC ORDER PK_DOC INDEX (PK_DOC))


Executing...
Done.
4959 fetches, 4 marks, 332 reads, 4 writes.
0 inserts, 0 updates, 0 deletes, 234 index, 1870 seq.
Delta memory: 50672 bytes.
Execute time: 00:00:05.

For subsequent SQLs, the statistics is as follows:

Starting transaction...
Preparing query: select * from doc where doc_id = 1000 order by doc_id
Prepare time: 00:00:05.
Field #01: DOC.DOC_ID Alias:DOC_ID Type:INTEGER
Field #02: DOC.DOC_TYPE Alias:DOC_TYPE Type:INTEGER
Field #03: DOC.DOC_SUBTYPE Alias:DOC_SUBTYPE Type:INTEGER
Field #04: DOC.DOC_DATE Alias:DOC_DATE Type:DATE
Field #05: DOC.DOC_XML Alias:DOC_XML Type:BLOB SUB_TYPE 1
PLAN (DOC ORDER PK_DOC INDEX (PK_DOC))


Executing...
Done.
295 fetches, 0 marks, 270 reads, 0 writes.
0 inserts, 0 updates, 0 deletes, 9 index, 0 seq.
Delta memory: 10400 bytes.
Execute time: 00:00:05.