Real-time Deep Learning at Bug Future Show conference
On Thursday, February 2, 2023, the tenth Bug Future Show will be held, which for the first time will introduce a third parallel track called “.debug Future Show” intended primarily for IT people, where, among other things, you can find my lecture titled called “Real-time Deep Learning” starting at 11:15. This is a short […]
How to speedup pooling queries from the Oracle database
This post is a kind of extension of my previous post named “How to index only rows of interest” which can be found on the following link: https://www.josip-pojatina.com/en/how-to-index-only-rows-of-interest/ Having issues with pooling queries are very common in old, SOA based architectural style, where ESB (Enterprise Service Bus) are throwing the same query again and […]
How to get 100% cache hit rate by using Change Data Capture & Redis
In this blog I’ll explain how to get 100% cache hit rate by using CDC (Change Data Capture) technology and Redis cache. There are multiple benefits of having caching layer in front of back-end database system. By fetching data from the cache instead of back-end we are actually free up valuable database resources for […]
Redis performance tuning – Top 10 mistakes
Redis is the most popular Key-value data store and one of the most popular database systems overall. According to Db-engine ranking: https://db-engines.com/en/ranking/key-value+store (You can check the picture below), Redis is on the top position by large margin among Key-values data stores. Amazon DynamoDb on the second place, lags behind Redis more than a twice. […]
Apache Ignite – distributed In-memory SQL database
Apache Ignite is one of the very few In-memory SQL compliant distributed databases/data grid among open-source projects. It’s often called “Redis done right” or “Redis on steroid”, because Redis looks primitive and limited when compared with Apache Ignite. Ignite offers great flexibility and lot of features that can easily fit to many use cases. Instead […]
Hybernate FetchType Eager performance issue
Quite recently I had one interesting case related to the quality of code generated by the Hybernate, in which I developed code which runs 25 thousand times faster than the code generated by the framework. It’s well known when you decide to use any framework to speed up code development process, you silently agree […]
Tuning Connection pool in modern Microservice architecture
Connection pool has always been a great way to ensure a low latency when establishing connection with a database, while at the same time keeping the number of open sessions under control. It’s one of the best ways to balance speed with resource consumption. With connection pool in place, connection is already established and ready […]
Perfect case for NoSQL database
On many sites where I’ve been involved in troubleshooting and performance tuning, I can find usage of wrong technology for a wrong use case. Usually client technology experts are keen with some new features of some technology and want to solve all kind of problems by using it. In practice, new features are added to […]
How to setup Adobe Flash Support in Browser for Linux
Some vendors still relies on Adobe Flash for rich web contents. One such example is Oracle, where you can find that all tuning reports are generated by using Flash. Even Oracle Enterprise Manager Grid, main Oracle monitoring tool still uses Adobe Flash to generate its content. If you are on Windows, you can use Internet […]
Customer experience on Oracle Db – One metric to rule them all
Over the years I’ve found that almost every enterprise monitoring software I’ve been working with so far (and there are a few dozen of them), put extensive load on targets under the monitoring. While one monitoring tool brings extensive hard parsing on its targets, another one calculates free space for each tablespace in a very […]