Solved

Slowness in  Btrieve After Inserting  200000 Rows in a Table

Posted on 2012-04-11
2
499 Views
Last Modified: 2013-12-25
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
Comment
Question by:orcun_turkec
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 28

Accepted Solution

by:
Bill Bach earned 500 total points
ID: 37836511
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
 
LVL 28

Expert Comment

by:Bill Bach
ID: 37871434
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Recently, Microsoft released a best-practice guide for securing Active Directory. It's a whopping 300+ pages long. Those of us tasked with securing our company’s databases and systems would, ideally, have time to devote to learning the ins and outs…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question