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
> UPDATE "TBL_TERMINAIS" SET "APOSTA" = 10 WHERE "ID_TERMINAL" = 8
> 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
instead.

> 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
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br