Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Access and Oracle
Hi
Thanks for your reply and information. My code is VB and ODBC. I read record from Access DB and Insert the record to Oracle DB. It is more slow than SQLPlus.
What is the ddl for the table and its related indices? I don't know
What does sql trace show? what do you mean?
Please advise
Thanks
"Jim Kennedy" <kennedy-down_with_spammers_at_no_spam.comcast.net> wrote in message news:<RZdgb.509586$cF.181282_at_rwcrnsc53>...
> 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 Tue Oct 07 2003 - 12:06:32 CDT