Speed of reading decreases in time
I have a procedure that simulates some objects and for each simulated object it does a lot of reading from two memory tables with 40-50 mln records in each.
Number of reads from that tables for each simulated object is about 50.
The issue is that when I start simulating some number of objects, simulation speed of first object is about 0.25 sec/object. But the speed decreases in time - after simulated 2,000 objects the speed is about 10 sec/object, after 5,000 objects - 70 sec/object.
And the slowest queries are reads from these two memory tables.
Memory limits should be okay:
max_heap_table_size = 20G
tmp_table_size = 2G
P.S. I do only reads - no inserts or updates.
Subject
Views
Written By
Posted
Speed of reading decreases in time
7250
May 23, 2011 04:58AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.