Subject Re: Performance
Author pokka_chi
--- In, Helen Borrie <helebor@...>
> 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.