File limit reached in Quick screen

Deskin, Bob Bob.Deskin@Cognos.COM
Fri, 5 Nov 2004 09:32:36 -0500


I have learned over the years that what is logically very simple is
often much more difficult. Not just in PowerHouse but other things. If
only it were as simple as increasing the single allocation. However,
there's a lot of clever code in PowerHouse because of the initial data
area limitations. We've certainly changed a lot of code over the years,
but the table structures have pretty much remained the same. That file
table entry also appears in many other related tables. It's basically a
big linked list.

Bob

-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Robert Edis
Sent: November 5, 2004 9:19 AM
To: PH List
Subject: RE: File limit reached in Quick screen


File limit reached in Quick screenWhy not just increase that 5 bit
allocationg to say 8?  Surely that would be an easy thing to do and have
virtually no impact on other logic other than extend the file limit.

HOWEVER, I have found that this limit helps to enforce better
logic/coding in quick screens.  In 10+ years of using PowerHouse I only
came across ONE instance why >31 files was ligigimate, and we found a
work-around for that.

Blue
  -----Original Message-----
  From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com]On Behalf Of Deskin, Bob
  Sent: Friday, November 05, 2004 5:44 AM
  To: powerh-l@lists.sowder.com
  Subject: RE: File limit reached in Quick screen


  The PowerHouse internal architecture is based on a large number of
tables that store information on things such as physical files, logical
files, items, fields, etc. These tables are all cross linked by a table
entry id. Guess what, the number of bits originally allocated for the
number of files in a screen was 5 bits giving 31 entries (2^5 - 1). Why
5 bits? Because in those days (late 70s) we were working on the HP3000
under MPE and there was a fixed data stack of 32K words (64K bytes).
Every bit/byte was precious. And we though that 31 was HUGE. And it was
for a while.

  The thing is that to restructure the tables and find all the
references (and cross references in other tables and their references)
is a major task. It's not necessarily difficult but it is picky,
time-consuming work. So it was always a trade-off between doing that one
thing versus many other things. Based on priorities, resources, and user
demand, the other things always won.
  Bob Deskin
  Senior Product Manager, Application Development Tools
  Cognos Inc. 3755 Riverside Drive, Ottawa ON K1G 4K9 CANADA
  bob.deskin@cognos.com (613) 738-1338 ext 7268

    -----Original Message-----
    From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com]On Behalf Of
Mikael.Olesen@qss-uk.com
    Sent: November 5, 2004 3:26 AM
    To: powerh-l@lists.sowder.com
    Subject: RE: File limit reached in Quick screen


    There are ways of working around the problem but I have always been
a bit annoyed

    about the 31 files limit. Why 31? and why don't Cognos change it?
Bob?



    Kind Regards

    Mikael Olesen





    r============================ DISCLAIMER
=============================
    This message is intended only for the use of the person(s)
    (\"Intended Recipient\") to whom it is addressed. It may contain
    information, which is privileged and confidential. Accordingly
    any dissemination, distribution, copying or other use of this
    message or any of its content by any person other than the Intended
    Recipient may constitute a breach of civil or criminal law and is
    strictly prohibited. If you are not the Intended Recipient, please
    contact the sender as soon as possible.

    Reed Business Information Ltd. and its subsidiary companies
    Tel: +44 (0)20 8652 3500

 
=======================================================================



         This message may contain privileged and/or confidential
information.  If you have received this e-mail in error or are not the
intended recipient, you may not use, copy, disseminate or distribute it;
do not open any attachments, delete it immediately from your system and
notify the sender promptly by e-mail that you have done so.  Thank you.


= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.