Re: Online Performance Degradation

andrew.shaw says: > Elapsed minutes: 1 2 3 ... 10 ... 35 ... 50 > # of transaction: 220 210 200 150 100 50 > > If you plot the number of transactions possible against elapsed time you get > what looks like a log N graph, ie plotted on log paper you get a downward > sloping straight line. I should point out that since we are doing adds, > the elapsed time reflects the database getting continuously larger, albeit > at a slowing rate. You are doing adds. It's pretty safe to assume that you have indexes on the table you are adding to. Informix must rebuild the indexes after each add to ensure that each index is in order. The larger the table, the longer it takes to rebuild an index because there are more entries that must be searched for the spot to insert the new row. I'm sure a more technical answer will arrive if you need it... -- Bryan Klopfenstein try: bryan@cinnet.com CARS Information Systems, Inc. or: ..uunet!uceng!cinnet!carsinfo!bryan Cincinnati, OH better: usr10300@tso.uc.edu Standard Disclaimers Apply