Oracle Select slow between 85 and 95 columns

General discussion forum about all databases other than SqlBase.
Bonus83

Oracle Select slow between 85 and 95 columns

Post by Bonus83 » 05 Nov 2014, 11:15

Hi,

I am using an Oracle 10g and have a problem when selecting a specified amount of columns. I have a Table called customer and want to read the ID (primary key, indexed aso.)
This happens only in the application and with sqltalk. Not with sqlplus or toad.
So I assume this has something to do with TD or with any setting within the runtime.

The problem occurs when selecting 86-95 columns from this table. The select lasts over 8 seconds. If i use more or less columns the selects returns within 0.03 seconds. To exclude any problems with clobs, long strings aso. I used the same column 90 times.

The select looks like:
SELECT customer_id, customer_id, customer_id, customer_id, customer_id, customer_id ... (90 times)
FROM Customer
WHERE Customer_id = 1;

If I use the customer_id 85 times in my SELECT its fast. If I use it 96 times ist fast. If I use any amount from 86 to 95 its slow.

So my Question is if there is any setting which leads to this sorcery? And why the hell it occors between 86 and 95 and not after 85 at all.

Thank you in advance.

ianrudge

Re: Oracle Select slow between 85 and 95 columns

Post by ianrudge » 11 Nov 2014, 12:21

Can't answer why it would do that but I wondered why you would need to do that?

Bonus83

Re: Oracle Select slow between 85 and 95 columns

Post by Bonus83 » 17 Nov 2014, 11:42

ianrudge wrote:Can't answer why it would do that but I wondered why you would need to do that?
You wonder why I have to select 90 columns out of a table?

ianrudge

Re: Oracle Select slow between 85 and 95 columns

Post by ianrudge » 01 Dec 2014, 12:56

Not 90 columns just 90 of the same columns.

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 1 guest