Subject Re: [firebird-support] Re: Performance
Author Hannes Streicher
Guten Tag pokka_chi,

> --- In, 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@...