Slowness in Btrieve After Inserting 200000 Rows in a Table

Hi,

I inserted  200000  rows in a btrieve table  .

Now,  the btrieve  database is opening very slowly.

How can we solve this slowness problem ?  


Thanks ...
orcun_turkecAsked:
Who is Participating?
 
Bill BachPresidentCommented:
If you inserted in a single transaction, there may be a lot of free space in the file right now. Try rebuilding the file to compact it with the Rebuild Utility.
0
 
Bill BachPresidentCommented:
Did the rebuild help?  If not, can you be more specific about how long it takes to open the file?  If you are running on a server (across the network) and are familiar with Wireshark, then you can install this and get a network capture of the Open operation, and you should see EXACTLY how long it takes.  Having more data may yield more clues as to what is going on.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.