Goldstar Logo
Your Source for Actian Zen and PSQL Database Products, Services and Training Since 1997 EMail: 
Phone: 1-708-647-7665 
Web Site Login 
Free PSQL Support
Quick Links
Database Engines
 Version Quick-Reference Chart
+ Actian Zen v15
+ Actian Zen v14
+ Actian Zen/PSQL v13
+ Actian PSQL v12
+ Actian PSQL v11
+ Pervasive PSQL v10
+ Pervasive PSQL v9
+ Pervasive.SQL V8
+ Pervasive.SQL 2000i
+ Pervasive.SQL 7
+ Btrieve 12
+ Btrieve 6.15
+ Actian Vector

+ Protecting Your Data

+ Goldstar Services

+ Goldstar Tools

+ Developer Resources

+ Other Solutions

Using AMS? Status 7224 Fix My PSQL License Report Engine Crash Repair PSQL Files Get Support Now Join Our Mailing List

Navigation Background

  Utilities Quick Links
Complete Tools List
DXUtil Page
GSSync Page
KeyCheck Page
LogSplitter Page
PSConfig Page
SQLExec Page
Data File Recovery Toolkit
ViewUNF Page

Goldstar Software Utilities: BtrvLoad

Multi-Threaded, Command-Line Database Pre-Load Tool
License Type
Price (USD)
Single User
Buy Now
Site License
Buy Now
30-Day Trial
Try Now

With the increase in use of 64-bit database engines and servers with LOTS of memory, another bottleneck has started to be noticed by users all over the globe. When a large Pervasive PSQL 64-bit system is running normally, performance is great. However, when the server has to be rebooted due to operating system or database engine patches, the database cache is flushed, and performance falls noticeably as the data must be reloaded from the disk on each database call.

BtrvLoad is a multi-threaded, command-line application that allows database administrators the ability to pre-load data into the database cache immediately after an engine restart. It issues special database calls to the engine to force the engine to access every single data page in a file, causing these pages to be loaded into the database cache, so that when the users start to access the system, they see only fast response times.

BtrvLoad supports the use of simple wildcards to specify database files (including *.*), but it can also be used with file lists (similar to that used by Continuous Operations Mode and our HoldOpen tool) for more fine-grained control. You can configure the number of threads used, which can help control the amount of load it places on the system, and it is perfectly safe to use on a production system with users accessing it simultaneously.

BtrvLoad can be purchased as a single-user license or as a LAN site license. We can also provide licensing information for developers if you are interested in including BtrvLoad within your application for use for initializing databases or performing other maintenance tasks. Click the links above, or contact us for more details!

  Copyright © 1997-2024, Goldstar Software Inc., All rights reserved. PRODUCTS | SERVICES | TRAINING | SUPPORT | DOWNLOADS | ABOUT US  
Goldstar Software Inc. | 1945 Maplewood Ln | Munster IN 46321 Legal Statements | EULAs | Uninstall | Privacy Statements | Contact Us