Performance issue with Long column

[Hakimca]

Hi All,

We are facing a performance problem concerning Long datatype via ODBC.
The table is not big(10000 records)and indexed. Each long column contains a text of 32K. Even if the query return few records it takes many seconds.With SQL*Plus it does not take long time.
PS. Our application does not support LOB datatypes. Any help.

Thanks in advance

[davey23uk]

trace the process, then use tkprof on the result.

but it does sound as if the database calls arent taking very long.

Myabe should look into what your application is doing

[Hakimca]

Dave it's a simple query (SELECT) on this table.

[stmontgo]

i thought I heard somewhere before that you can through NET configuration increase the size of packets that Oracle uses to communicate with the client the reducing the number of db calls,

I'm not sure if this relevant to your case or if it might help. Perhaps other members may elaborate on this

[Hakimca]

Thanks Steve, I will check