On Wed, 2002-12-04 at 18:29, Dmitri Touretsky wrote:
> Good time of the day!
>
> >> But I have an extended question: is there a cost-effective (in terms
> >> of performance) way to add record to a large table? I don't need
> >> indexing or such - just to add some data, e.g., a log record. Currently
> >> I insert records into small table, than at night run a batch which is
> >> moving added records from small table to the large one. Trying to add
> >> records to large table "on the fly" causes noticable performance
> >> degradation, but would be desirable if it's possible...
>
> RJ> Slowdown when inserting into a high-tuple table vs. a low-tuple
> RJ> table?
>
> Yes. And the difference is pretty big... Or I misunderstood your
> question?
When the table had 1,000 rows in it, inserting was faster than now
that it has 20M records? Sounds like you understood me...
I've done the same thing and didn't notice all that much of a drop-
off in speed. (IDE drive using the EXT3 filesystem.)
--
+------------------------------------------------------------+
| Ron Johnson, Jr. mailto:ron.l.johnson@cox.net |
| Jefferson, LA USA http://members.cox.net/ron.l.johnson |
| |
| "they love our milk and honey, but preach about another |
| way of living" |
| Merle Haggard, "The Fighting Side Of Me" |
+------------------------------------------------------------+