Re: Modernizing applications (was: Explaining single level store to non ipeople)

On Wed, Aug 19, 2009 at 23:22, Nathan Andelin<nandelin@xxxxxxxxx> wrote:

use full commitment control and journalling for everything

It would really surprise me if SAP's benchmarks included journaling.

They do. tlogs aren't optional in other RDBMS. Except in MySQL with
MyISAM tables, which is a special case.

But my order entry applications follow a traditional header-line model, where the order is entered, then a series of line items are entered. ÂEach entry adds or changes a record on the server, immediately.

And there is never ever any need in your application to change more
than one row at a time?

Under my header-line model, there's no need for commitment control. ÂBut RPG-based commitment control doesn't add much overhead, if or when needed.

Well, i don't see ACID in a business critical application as "optional".

Well, I subscribe to the old adage - make everything as simple as possible. ÂIn this case, the IBM i HTTP server forwards browser requests to an RPG-based server which natively interfaces with the database, then returns an HTML/JavaScript response.

Yep, but "Notepad is faster than Word" is hardly news. Even if the
machine running notepad is slower.