Unconfigured Ad Widget

Collapse

Announcement

Collapse
No announcement yet.

Program database reads

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Program database reads

    Are there any SELECT or OMITs in the LFs? Dave

  • #2
    Program database reads

    The file hase 21 logicals (13 with select omit), another interesting fact is the application is in Advantage 2E (synon) and generated in CBL85, but thats a different issue...

    Comment


    • #3
      Program database reads

      The age old question... We have a file (or several) with a large amount of data (4.8 million records). The issue is over physical I/O vs logical I/O. One of the developers I work with thinks you can have 4 programs processing the same logical file, doing some data manipulation, and it will be just as fast as 4 program processing the same logical file all starting a unique start point and reading 1/4th of the records. I agree with him if the file is small enough to fit in memory, but, the physical file we are dealing with is 59,810,893,824 bites. Can someone help me with this??? I would like some kind of proof... Thanks, Bob

      Comment

      Working...
      X