I am having problems getting decent performance in a Windows application I am
developing that uses Novell's Btrieve (Version 5.1). This application has
an import function which initially populates the database. This involves
inserting approximately 90,000 records into several Btrieve
files, the largest of which contains about 60,000 records. On a 486-66Mhz
machine this takes over 10 hours. Unfortunately, the target platform for this
application does not include the 32-bit file access that is available on
Windows for Workgroups, NT or (I assuming) on Win 95, which cuts down the
time considerably to about 1 hour. I have tried optimizing the page sizes of
the Btrieve files to their smallest possible size and have also tried using
the Extended Insert operations of Btrieve. They have reduced time, but not
If anyone out there has some insight on this I would greatly appreciate it.
In particular, if anyone knows a way in Btrieve to insert a certain amount
of records without it having to update the indexes with each insert; Or knows
in general how massive inserts are usually dealt with in Btrieve.
Thanks in advance,