Oracle db versus COBOL indexed files 1

[philhickling]

Which would perform faster: an Oracle database or MicroFocus COBOL indexed files? Does anyone have experience of both and could make helpful coments as to whether we could improve performance by switching from indexed files to a relational database.

Database size is approx. 2 GB, running on Windows NT, with 100 plus users.

Many thanks.
Phil Hickling.

 

[jimbopalmer]

The Primary advantage speed wise of the Oracle database is the large RAM buffer of recently used data called the SGA (System Global Area) recently or frequently used data is cached there and so is retrieved at the speed of RAM not the speed of disks. Since it is global, any users retreival speed any users next retreival, they 'help' each other.

if your disk subsystem allows NVRAM cached writes, you can get performance which rarely slows to disk speeds.

more subtly, it is harder to corrupt the data in a database, so easier to write code that does not corrupt data. I tried to remain child-like, all I acheived was childish.