I'm using indexes and have tried all the advice given to me to speed up the update. In the end it was concluded that the slow update time is because of the Pervasive Engine. So I thought, why not install MSDE for the clients who doesn't have MS Sql Server, and only Pervasive, and then do the above procedure. I know this is almost like a "hack", but I'm completely frustrated with Pervasive at the moment, and with so little documentation on it, it feels like I'm fighting a losing battle. My only source of good info comes from guys like you, thanks.