Gerhardus Geldenhuis wrote:

>
> Hi
> Btw
> Even after deactivating the indexes performance is still very bad.
> I dont even get a 20% usage out of the service and it is the only real
> service running. Could it perhaps have something to do with the size of the
> database. It is now around 1.4gig It is a single file.
>

What are you doing in addition to adding records?
What txn isolation mode are you using?

Paul
--

Paul Reeves
http://www.ibphoenix.com
taking InterBase further