Subject Re: [firebird-support] update take manu time
Author Alexandre Benson Smith
Hi Luiz,

Luiz Rafael Culik Guimaraes wrote:
> Dear Friend
> I have an simple update with only one field and this update command is
> taking too much time (0.2800) on an windows 98 server with classic server
> running on an 256Mb Flash Drive
> the query is
> i have na index on ID_TERMINAL Field

How much records are updated by this query ?

If you have a million records with ID_TERMINAL = 8 I think it's quite
fast :-) I wont call W98 a server :-)

Why run classic on it ? Is it a SMP machine ? I suppose if you run it on
W98 it is a very small database with few users, so I would choose SS
> any idea to speed up this query?

So far CS has a separated cache for each connection it will do more
physical reads than SS, I don't know how performant is an USB Falsh
drive in Win 98 (does it support USB 2.0 ?)

But I think the main concern should be how much records are filtered by
your WHERE clause.

> Regards
> Luiz Rafael

see you !

Alexandre Benson Smith
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil