Subject Optimisation Query
Author Maya Opperman

I am trying to speed up a refresh query, and have stripped away
everything but the straight "select fields from table where id = :id",
but that alone it still taking 0.8 seconds to complete.

The results from IBExpert are as follows:



Adapted Plan


------ Performance info ------

Prepare time = 16ms

Execute time = 875ms

Avg fetch time = 875.00 ms

Current memory = 17,947,188

Max memory = 24,463,068

Memory buffers = 2,048

Reads from disk to cache = 0

Writes from cache to disk = 0

Fetches from cache = 6 (Can I reduce this?)

Are there any changes I can make to the database settings, which will
reduce that time, or is 0.8 as good as I can expect?

(There are currently 18 000 records in the table, Firebird 2.1.3, and
there are a couple of large varchars. One varchar(1000) and another
varchar(300), which I should probably try convert to blobs..?)

Thanks in advance!


[Non-text portions of this message have been removed]