Hi Pete,

> My post commands are very slow.

Do you mean <somedelphicomponent>.Post or do you mean an
actual INSERT INTO statement?

> I am selecting records "where status=1", dealing with them, then
> changing Status to 2. Status is not an indexed field. The SELECT

Does the table have a primary key?

> command is more complex, there are other "wheres", but no other fields
> are being changed.
>
> Since status has low selectivity - there are about 6 choices, over about
> 5 million records - then I can guess why there might be a problem
> (index? record moving out of "where" condition?). But I have no idea
> what to do about it...

You shouldn't index that field - it's no use.


With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."