Web Site Login
^ September: Data Protection! ^
August Results: No Survey
[See All Surveys]
|
|
 |
Performance Optimization Services
OK, so you have the database running now, but is it running at
it's fastest rate possible?
The Btrieve database engine can support many users with many concurrent transactions. Many application developers
avoid Btrieve transactions because they impose some programming overhead & slow the system down. At least one
company, MACESS Corporation, has overcome these limitations with special-purpose programming to handle the
details correctly. Under peak loads, we have seen the NetWare server engine handle in excess of 950 users concurrently,
all heavily using Btrieve-level transactions.
The database engine on NetWare can also handle tremendous throughput volume. One site in Illinois habitually runs
over 3000 Btrieve requests per second (BRPS) through a dual-processor NetWare server with only 128MB of cache memory.
We have seen peak volume in this environment of over 5000 BRPS. Most Windows NT servers are not running at very
peak load, but we have seen WinNT servers handling in excess of 2000 BRPS.
Can Btrieve handle the size of your database? The largest single-server databases (that we have seen) run well
into the 35-50GB range. The largest multi-server (single) database spans 6 servers and encompases over 60GB of
data.
When you talk of sites running databases of this size successfully, you must also realize that they have specially
tuned the hardware and software configurations to maximize throughput. Some of these sites have also required software
modifications -- changes to the application design itself -- to maintain the high levels of activity. In any event,
it DOES work! Goldstar Software can work with you to analyze the existing performance levels and determine where
strides can be made to improve speed or reliability. |
|
|