• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 508
  • Last Modified:

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 ...
0
orcun_turkec
Asked:
orcun_turkec
  • 2
1 Solution
 
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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now