Re: Access and Oracle

ODBC is always going to be slower than SqlPlus ( which uses a Native connection) -how were you doing this in SqlPLus anyway?

To get the ddl, while in SqlPLus enter:

desc <table_name>

mhakimjavadi_at_hotmail.com (Mohammad) wrote:

>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:12:01 CDT