pokka_chi wrote:

>> What you are seeing is not a direct dependency on the Windows cache
>>
> but
>
>> rather the cost of loading the database schema details to
>> prepare/optimize the query.
>>
>>
>
> The cause may be the loading of the db schema details but the symptom
> is that the Windows cache makes a big difference to the speed. If it
> is really the loading of the db schema, it'll be more puzzling. My
> test db contains just a simple one table with 5 fields and a few
> indices:
>

Let me ask the obvious first...

What is the filename you are using ?

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br