Performance = Information When You Need It
EntelliCache excels in high volume, ad hoc query environments. It has been our experience
that as query response times improve, acceptance and use of your business intelligence
solution by your user community increases.
EntelliCache's Heritage in the Department of Defense
For several years, Teksouth, the developers of EntelliCache, have been providing
high end data services to the Department of Defense. In one of the large DoD implmentations,
83% of the 737,344 March 2007 queries returned in 10 seconds or less.
|
Query time |
Query Count |
% of Queries |
|
< 1 second |
4,202 |
.57 % |
|
1-3 seconds |
468,322 |
63.51% |
|
4-10 seconds |
145,281 |
19.70% |
|
11-30 seconds |
60,680 |
8.23% |
|
> 30 seconds |
58,859 |
7.99% |
Tune For the Masses
Enabling your users to make quick, informed business decisions is a key component
to success. In order for your business to stay ahead of the competition, information
needs to be analyzed and acted upon within minutes or hours and not days, weeks
or months.
Traditionally, systems have been tuned for the handful of key reports that are run
on a weekly or monthly basis and ad hoc query capability has been limited to a few
power users.
EntelliCache will enable your enterprise to tune for the masses without jeopardizing
business transactions or ETL performance. This will put the power of information
into the hands of your front line workers who are making these crucial business
decisions throughout the day.
Benchmarks
The following benchmark tests were performed in the Teksouth labs January 2006.
Using the TPC-H database on SQL Server 2005, EntelliCache produced very impressive
results. The database hardware was very modest, four Pentium 700MHz processors with
3.5GB of ram. The queries were launched using Cognos 8 (Query Studio) running on
Windows 2003, it was running dual Pentium 2GHz processors with 1GB ram.
|