| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
| Global cache and design question |
« View previous topic :: View next topic » |
| Author |
Message
|
| nelson |
 Posted: Thu Jul 09, 2015 7:57 am Post subject: |
 |
|
Partisan
Joined: 02 Oct 2012
Posts: 313
|
| chris boehnke wrote: |
We are using WMB V8.0.0.2.
Looks like global cache is available from V8. I will do a POC with single broker first.
I was thinking of ESQL cache also.
We will first read the file and cache the data to shared variables. Then move the data to ESQL variable and run a select query against this variable. This way the performance might not get impacted much.
Suggestions pls.
Also I want to know if caching 1MB impacts the broker performance ? |
As shared in a link in another post:
| Quote: |
| ESQL is an extension of SQL defined by WebSphere® Message Broker and IBM® Integration Bus to define and manipulate data within a message flow. ESQL shared variables are often used to cache the contents of database tables, with the shared variable cache implemented as an array containing the result of a SELECT operation, and searches conducted by issuing a SELECT against that array. The problem with this approach is that ESQL SELECT operations perform a sequential search, so as the cache grows, searches become slower. Most users have found that when cache sizes exceed a few thousand rows, it is faster to access the database than to use a cache. This article shows you a new way to structure the cache that scales well, and remains faster than accessing the database even when exceeding 10,000 rows |
You can find more information here
I suggest you to do a benchmark... |
|
| Back to top |
|
 |
| chris boehnke |
| Posted: Fri Jul 10, 2015 12:28 pm Post subject: |
|
|
Partisan
Joined: 25 Jul 2006
Posts: 369
|
Thanks @nelson.
Our organization doesnt allow us to directly interact with the database. So, the database content are placed in properties file.
The data is around 400 rows and 24 columns. I am wondering how I can use esql cache here. |
|
| Back to top |
|
|
| nelson |
| Posted: Fri Jul 10, 2015 1:39 pm Post subject: |
|
|
Partisan
Joined: 02 Oct 2012
Posts: 313
|
| Quote: |
| This article shows you a new way to structure the cache that scales well, and remains faster than accessing the database even when exceeding 10,000 rows |
The article mentions a way to improve the performance when using shared variables to cache data, not a database...  |
|
| Back to top |
|
|
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
