That is really not very much information. Try setting the _run_faster=true
in the ODBC.ini file. How fast is the same operation in SQLPlus? Is it
fast or slow? How fast or slow is it? What is the code? Are you using
bind variables (Bet you are not.)? What is the explain plan? What is the
ddl for the table and its related indices? What does sql trace show?
Jim
"Mohammad" <mhakimjavadi_at_hotmail.com> wrote in message
news:cc59b627.0310060501.61f69086_at_posting.google.com...
> Hi
>
> I have to read information from Access DB and insert
> record to Oracle9i table. I used VB and ODBC for Access
> and Oracle and I did that. It is working find but it is
> working very very slow!!!!!
>
> Could you please tell me any other way to do that job and
> faster or maybe I missed same setting for ODBC.
>
> Thanks for your help.
Received on Mon Oct 06 2003 - 08:19:45 CDT
