REALLY strange bug.

[Deane Venske]

Just another update. Running the sqlExecute("REINDEX DATABASE") manually  
every 200 transactions fixed the problem.

Deane

> Hi Ruslan,
>
> I found the problem by starting from scratch with a new DB and RB app.
> I've attached it. If the userID file is set to be indexed the problem
> happens, without indexing it's fine. The RB app will insert data and
> delete data and revert to the backup DB if needed. If you change between
> indexed and not indexed fields you will see the differences. Hope this
> helps find the problem.
>
> I will use your suggestion about using "userID in (...)" it will speed up
> the process greatly.
>
> Deane



-- 
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/