Re: Database Size Vs System Performance -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

Let me try that question a slightly different way. Currently the DB ismaintaining 344 PFs and 750 LFs. If we double those numbers, whataffect will it have on performance? I would have to believe that if theDB has to 'watch' over twice as many PFs and LFs, it would have to takesome sort of toll on the system. I am just looking for some roughestimate on how much, if any. I do understand what you are sayingthough. And it makes sense. Just trying to cover my a** with thepowers that be at work.


Thanks,
  Scott

Wilt, Charles wrote:

 The number of objects really doesn't matter as there is really
 nothing to "maintain" unless the object is being used in some manner.


 So it doesn't matter if you have 5 people using 10 out of 100 objects
 or 5 people using 10 out of 1000 objects

 The system performance will be basically the same.


 Having said that, it looks like you'll want to watch your DASD usage
 when you create the new libraries. The changes in the amount of DASD
 usage is the only real performance impact.


 HTH,

 Charles Wilt -- iSeries Systems Administrator / Developer Mitsubishi
 Electric Automotive America ph: 513-573-4343 fax: 513-398-1121

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.