![]() 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.ītrvLoad can be purchased as a single-user license or as a LAN site license. 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.ītrvLoad 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. 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.ītrvLoad 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. When a large Pervasive PSQL 64-bit system is running normally, performance is great. ![]() 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |