Guten Tag pokka_chi,

> --- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...>
> wrote:
>>
>> Remind us: what version of Windows do you use and what is the name
>> of your database file?
>>

> I'm running WinXP SP2, Core2Duo 1.66GHz, 1GB Ram. The name of db is
> test.gdb. I have AVG anti-virus turned on.

>> Also: how do you know it is sluggish? I mean, tell us what is your
>> first encounter with the database after the machine has been
>> cold-started. What is it meant to do, and what does it do instead?
>>

> I do a simple select * from my_table where primary_key = 1. There's
> only one record returned. I used IBOConsole to do it. The plan used
> is correct (i.e. using the primary key). I expect this to be instant
> but there is a lot of disk io instead.

your filename is the problem,
change it from *.gdb to *.fdb this will solve it

gdb is an fileextension which windows XP fileprotection keeps on copying
everytime the file is accessed

--
Mit freundlichen Grüssen
Hannes Streicher mailto:HStreicher@...