Right. Which is why I suggested a view, so that the quantity of data
being returned is reduced and the resulting response time reduced. The
'(and security)' is a whole other concern that can be/is only
incidentally enhanced - not related to the speed issue at all, but by
limiting the view to tables or rows needed, information in tables or
rows that are not needed is shielded - and by not returning that data
the volume of information being returned can be reduced and response
time improved.

The suggestion assumes the DBA has some idea of what information is
being needed, so the view can be created and the returned information is
efficiently filtered to only allow the desired data be returned.

Walt



Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.


From: Michael Porter
[mailto:oracledba-ezmlmshield-x44461856.[Email address protected]
Sent: Tuesday, March 06, 2007 09:23
To: LazyDBA Discussion
Subject: RE: ODBC too Slow

Its not the access, its the volume of data being **returned**. ODBC is
notoriously SLOW. Security is a whole other deal...

M

>>> "Walter Hunnel "
<oracledba-ezmlmshield-x310088.[Email address protected] 3/6/2007
9:21:09 AM >>> A thought...

Instead of giving acces to the entire database, create a view of just
what is needed, and give access to just that view to the ODBC user.
That
should increase speed (and security).

Walt



Confidentiality Notice: This e-mail message, including any attachments,
is for the sole use of the intended recipient(s) and may contain
confidential and privileged information. Any unauthorized review, use,
disclosure or distribution is prohibited. If you are not the intended
recipient, please contact the sender by reply e-mail and destroy all
copies of the original message.


From: Henrique da Hora
[mailto:oracledba-ezmlmshield-x15413608.[Email address protected]
Sent: Tuesday, March 06, 2007 05:47
To: LazyDBA Discussion
Subject: ODBC too Slow

Hi Gurus,



We have an Oracle 9i instaled in AIX 4.0 (IBM RISC).



The application is normal, but when whe need to use data with
MS-WORD (with ODBC driver configured), the task takes too long time.



Any ideas?



Thanks

Henrique da Hora


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com

To unsubscribe: http://www.lazydba.com/unsubscribe.html


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

Oracle LazyDBA home page