You might want to make sure your developer is hip to Access' "pass-through"
queries & is thinking straight about when it makes sense to do calculations
in Access, as opposed to having them done on the server.
Cheers,
-Roy
Roy Pardee
Programmer/Analyst
SWFPAC Lockheed Martin IT
Extension 8487
-----Original Message-----
Sent: Thursday, February 21, 2002 5:53 AM
To: Multiple recipients of list ORACLE-L
Sean -
I think that Access tends to be a wonderfully cheap and easy Oracle
front-end for exactly the situation you described. Naturally, if your site
has standardized on a different tool, then it isn't good, or if the staff is
highly competent in another tool.
I think the developer's concern is an excellent opportunity for you
to introduce the subject of scalability. Think about it. The scalability
problem in this situation isn't in Access, but in the Oracle data model and
in the SQL statements that Access issues (okay technically that part is in
Access). If the data model is well-designed and the SQL statements aren't
doing something like full-table scans, then it should scale well. Okay, the
other gotcha might be if the size of the data you are extracting from Oracle
will eventually overwhelm Access.
If someone else on the list knows any other Access points of
concern, perhaps they will share them.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message-----
Sent: Thursday, February 21, 2002 6:48 AM
To: Multiple recipients of list ORACLE-L
A developer here has put together a reporting package which uses ODBC to
interface to an 8.1.7 DB on W2K server and utilises MS-Access on client to
extract data and generate nice GUI final presentation of data. The data
extracted has various computations performed. The developer has asked what
other Oracle or 3rd party options might be used to realise the same end
results perhaps in a more efficient manner. Their concern is that as data
volumes grow the performance will degredate substantially. Anyone any
ideas?.
-------------------------
Seán O' Neill
Organon (Ireland) Ltd.
[subscribed: digest mode]
--------------------------------------------------------------------
This message, including attached files, may contain confidential
information and is intended only for the use by the individual
and/or the entity to which it is addressed. Any unauthorized use,
dissemination of, or copying of the information contained herein is
not allowed and may lead to irreparable harm and damage for which
you may be held liable. If you receive this message in error or if
it is intended for someone else please notify the sender by
returning this e-mail immediately and delete the message.
--------------------------------------------------------------------
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: O'Neill, Sean
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Pardee, Roy E
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
