> My question is any reason why the database responding (select /inserts) becomes slower as the database usage becomes more.
If you can observe the performance impact in a reliable and reproducible fashion, you could try: 1) Set up the fast-responding behavior 2) Capture runtime statistics from several well-performing statements 3) Set up the poor-performing behavior 4) Capture runtime statistics from the same statements Then we could compare the output and look at the differences to understand the performance degradation in more detail. thanks, bryan
