RE: HELP CRYSTAL/ORACLE FIGHTING APPROACH CUT DOWN REPORTS

From: <Paula_Stankus_at_doh.state.fl.us>
Date: Tue, 13 Aug 2002 06:18:33 -0800
Message-ID: <F001.004B2A6B.20020813061833@fatcity.com>

Guys,

User apparently can only execute one stored proc. from a Crystal Reports. There are lots of different types of queries and he would like to cut-down on the number of Crystal Reports he would need. He wishes to create a table with session i.d. as primary key that will be used to insert aggregate records (rolling averages, etc.) so that he doesn't have to do this. I am concerned about even just 12 concurrent users (maybe?), 67 rows, primary key and index inserts and deletes are unnecessarily incurring I/O. I am suggesting using DBMS_SQL but don't know if there are limitations to the type of SQL you can write - we have inline views/hints/etc.? I just think it would be a more efficient way to do the same thing. He is saying he has been burned before by code generators. I am trying to say that this is a supplied package and not really a code generator and in my experience quite flexible. Help!!!! Am I making too much of this? What about metadata tables? In otherwords, keep report name, columns involved or even store query and view name then query actually based on the metadata. Probably what the ad hoc query tools do anyway.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: Paula_Stankus_at_doh.state.fl.us

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Aug 13 2002 - 09:18:33 CDT