Re: In the TOILET past 10 M rows?

Hi Jeff,

running Oracle on IBM RS6000 for several years i cannot believe that. I have linear performance degradation according to the size of the tables.

Can not believe that HPUX is much different to AIX implementation.

I see -no- performance degradation -inserting- data into tables.

Deleting from a table is dog slow anyway.

Would be intereseted in more details.

Using > 10 mio rows is a problem anyway: Cost <-> rule based optimizer, using views for 1:N:M relation is practical not possible etc.

Best regards,

Toni

+--------------------------------------------------------------------+


| Anton Dischner, DBA and system-programmer    Phone: +49 89 70953202|

| Institut fuer Klinische Chemie               Fax  : +49 89 70958888|

| Klinikum Grosshadern                         Home : +49 89 6254060 |

| Ludwig Maximilians Universitaet Muenchen     Handy: +49 172 8388880|

| 81366 Muenchen                                                     |

| Marchioninistr. 15                                                 |


| Germany                          Mail: dischner_at_med.uni-muenchen.de|


 +--------------------------------------------------------------------+