I have a large Oracle database with 100,000+ records in several tables.
Currently, I have to use a very complex view in order to pull information
from all of the tables that I need a one time but the performance is much
less than desired. I have created individual queries to each table which
gives me a good performance increase but adds a lot of additional code in
some areas. Now, finally to my question. I have an equipment table that
stores all of the information including a user number about each piece. In
several cases I need to only pull the acctid (i.e. SMITHJD) from the user
table for several pieces of equipment in a list and I don't want to perform
additional queries. The user list is updated overnight and doesn't change
during the day so I could either create a two column array in the domain
scope or write an XML file with user numbers and acctids. I would somehow
like create a lookup into the array or file to show the acctid as I list
each piece of equipment that would give me the best performance. Very wordy
I know, just looking for some ideas.
Current
<@ROWS>
<TR>
<TD>
<@COLUMN MAMS_VIEW_WEB_DEVICE_300.ECN>
</TD>
<TD>
<@COLUMN MAMS_VIEW_WEB_DEVICE_300.BLDG>
</TD>
<TD>
<@COLUMN MAMS_VIEW_WEB_DEVICE_300.ROOM>
</TD>
<TD>
<@COLUMN MAMS_VIEW_WEB_DEVICE_300.ACCTID>
</TD>
</TR>
</@ROWS>
What I would like to have is something like this
<@ROWS>
<TR>
<TD>
<@COLUMN EQUIPMENT.ECN>
</TD>
<TD>
<@COLUMN EQUIPMENT.BLDG>
</TD>
<TD>
<@COLUMN EQUIPMENT.ROOM>
</TD>
<TD>
------------ I would like to put either a custom tag or maybe a call to a
class file or something that would pull the acctid from the array or a
lookup in the XML file.-----------
</TD>
</TR>
</@ROWS>
Any new approaches or thoughts would be appreciated.
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
