(Ged Mead) In an application where the same data is needed by multiple clients – Windows, Pages, etc. – it makes sense to have just one copy of the data and for all potential clients to use that. And taking this thought a step further, it’s also pretty obvious that constant reading and re-reading f
Other News
Native Memory Diagnostics in VS2015 Preview
(Adam Welch) In Visual Studio 2013 Update 2 and also in the earlier CTP releases of Visual Studio 2015, we released a memory diagnostic tool that allowed developers to take heap snapshots of their application and then examine the heap contents upon terminating their application.
Understanding Asynchronous Programming in Node.js
(Jesse Smith) This article discusses a fundamental concept in Node called asynchronous programming and how it differs from synchronous programming.
Tuning guidelines and principles to enhance database performance in WebSphere Commerce
(Noureddine Brahimi) You can modify the default WebSphere Commerce data model to maintain optimal system performance during periods of high user connectivity, such as peak shopping events. A heavy workload, simulating a peak shopping event on the original data model, is run and analyzed.
Returning Sorted Record Sets Using the ORDER BY Clause
(Greg Larsen) Having your data returned to you in some meaningful sorted order is important sometimes. If you don’t tell SQL Server you want to order the results of a SELECT statement then there is no guarantee that your result set will come back in a particular order.
Working with JSON
(Jinan Kordab) JSON data providers provide just that. There is no schema with that data. Why do we need schema, some might ask?
Adventures in RAC: gc buffer busy acquire and release
(Martin Bach) It seems that I’m getting more and more drawn into the world of performance analysis, and since I sometimes tend to forget things I need to write them down. I almost enjoy the “getting there” more than ultimately solving the problem. You pick up quite a few things on the way.
Oracle database operating system memory allocation management for PGA
(Frits Hoogland) This post is about memory management on the operating system level of an Oracle database. The first question that might pop in your head is: isn’t this a solved problem? The answer is: yes, if you use Oracle’s AMM (Automatic Memory Management) feature, which let’s you set a limit fo
ora:getAttachmentProperty: Failed to decode properties string
(Martien van den Akker) Last week I created a process that polls the usermessagingservice-email adapter to read emails and store the email with attachments as Oracle ACM case documents.
Analyzing Prepared Statement Performance With VividCortex
(John Potocny) Optimizing MySQL performance requires the ability to inspect production query traffic. If you’re not seeing your application’s production workload, you’re missing a vital part of the picture.