[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference orarep::nomahs::rdb_60

Title:Oracle Rdb - Still a strategic database for DEC on Alpha AXP!
Notice:RDB_60 is archived, please use RDB_70..
Moderator:NOVA::SMITHISON
Created:Fri Mar 18 1994
Last Modified:Fri May 30 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:5118
Total number of notes:28246

4877.0. "Performances..." by CHSR36::LCONS () Fri Jan 03 1997 12:00

T.RTitleUserPersonal
Name
DateLines
4877.1NOVA::SMITHIDon't understate or underestimate Rdb!Fri Jan 03 1997 12:5016
4877.2Maybe it is the insert that is quicker?10245::COBROWNColin from DanmarkMon Jan 06 1997 08:175
4877.3ORAREP::HERON::GODFRINDOracle Rdb EngineeringMon Jan 06 1997 09:4812
4877.4ITVMS1::GTACCHINGiovanni TacchiniThu Jan 09 1997 08:5812
4877.4I'm backCHSR36::LCONSThu Jan 16 1997 11:4331
4877.5Bug ?CHSR36::LCONSThu Jan 23 1997 05:293
4877.6ORAREP::HERON::GODFRINDOracle Rdb EngineeringSun Jan 26 1997 16:014
Well, if you have a reproduceable case that clearly exhibits a problem, 
then I suppose, yes, open a bug.

/albert
4877.7NOVA::SMITHIDon't understate or underestimate Rdb!Sun Jan 26 1997 16:4311
~insert into test_lc1 select * from test_lc;
~insert into test_lc1 select * from test_lc order by col1;

why not run your test with the query order reversed.

insert into test_lc1 select * from test_lc order by col1;
insert into test_lc1 select * from test_lc;

Does that make a difference?

ian
4877.8CHSR36::LCONSMon Jan 27 1997 05:357
I've not execute the query one time.
I've ran it many times, order first, order second, and i've always the same
result.
On my station the factor is only 0.5 beetween the twoo queries.
On the customer site the factor is 16...

Louis
4877.9What else is different...BOUVS::OAKEYI'll take Clueless for $500, AlexMon Jan 27 1997 10:498
�                      <<< Note 4877.8 by CHSR36::LCONS >>>

�On my station the factor is only 0.5 beetween the twoo queries.
�On the customer site the factor is 16...

Sounds like time to start figuring out what else is different between your 
environment and the customer's :)