philhickling
Programmer
What are the relative advantages and disadvantages of an sql database system as compared with COBOL indexed files?
I have a client using a networked system for 100+ users, developed using MicroFocus NetExpress, accessing a database of 30 indexed files, 3 Gb in total size, 1Gb largest file (plus 5 Gb archived data), about 10 million live records. About 80% of users connect via the local NT4 LAN, the remainder via a WAN using Citrix WinFrame. It all works OK,
but we face a possible 10 times expansion, and are concerned that performance may disintegrate.
Would an sql database system such as Oracle, Sybase, etc. be better than indexed files? Are there other options for improving performance? Can COBOL systems and indexed files cope with 1000+ users, and 30Gb databases?
I have a client using a networked system for 100+ users, developed using MicroFocus NetExpress, accessing a database of 30 indexed files, 3 Gb in total size, 1Gb largest file (plus 5 Gb archived data), about 10 million live records. About 80% of users connect via the local NT4 LAN, the remainder via a WAN using Citrix WinFrame. It all works OK,
but we face a possible 10 times expansion, and are concerned that performance may disintegrate.
Would an sql database system such as Oracle, Sybase, etc. be better than indexed files? Are there other options for improving performance? Can COBOL systems and indexed files cope with 1000+ users, and 30Gb databases?