I have a table with 37 fields and about 300,000 rows
when I run a SELECT DISTINCT statement the first time it is very
slow, if I run it again it speeds up.
Is there some caching that firebird is doing?
Is there something that I can do to make it perform fast the first
time everytime?
f_company is VARCHAR(50)
I am using version 1.5.0.4306 of firebird.
I am using the .NET Provider version 1.5.1410.16587 maybe that is
what is makeing it slow?
Here is some logging that I do when run the statement.
Memory Load Time is the time it is taking to execute the query.

SELECT DISTINCT fd.f_company FROM t_framesdata fd
00:00:00.0156245 Add Range Time
Load Combo List Available Manufacturers - Entries = 184
16.140 Total Load Time
15.937 Memory Load Time
0.203 ListView Load Time
SELECT DISTINCT fd.f_company FROM t_framesdata fd
00:00:00 Add Range Time
Load Combo List Available Manufacturers - Entries = 184
7.812 Total Load Time
7.797 Memory Load Time
0.016 ListView Load Time
SELECT DISTINCT fd.f_company FROM t_framesdata fd
00:00:00.0156245 Add Range Time
Load Combo List Available Manufacturers - Entries = 184
2.906 Total Load Time
2.875 Memory Load Time
0.031 ListView Load Time
SELECT DISTINCT fd.f_company FROM t_framesdata fd
00:00:00.0156245 Add Range Time
Load Combo List Available Manufacturers - Entries = 184
2.875 Total Load Time
2.844 Memory Load Time
0.031 ListView Load Time