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

Oracle LazyDBA home page