Access Performance issue

Insertion of 1,000,000 objects in a persisted TreeMap, average duration ( total insert time divide by number of objects )

Search of all object in 1,000,000 objects persisted TreeMap , average duration ( total search time divide by number of objects ).

first test made on PC: 2Gbytes ram DR2 400 MHz, Athlon Xp 2600+ 1.5 GHZ, hard disk ide ultra dma 2

second test made on PC: 2Gbytes ram DR2 800 MHz, Intel dual core 2.66 GHZ, hard disk sata

JOAFIP configured for use 250 pages of 8Kbytes

First test insertion

x-coordinate / abscissa : number of insertion from 1 thru 1000000
y-coordinate / ordinate : averrage duration ( total search time divide by number of objects )

max=1.5022362 mS

min=0.234 mS

First test search

x-coordinate / abscissa : number of search from 1 thru 1000000
y-coordinate / ordinate : average duration ( total search time divide by number of objects )

max=2.547 mS

min=0.9571746 mS

Second test insertion

x-coordinate / abscissa : number of insertion from 1 thru 1000000
y-coordinate / ordinate : average duration ( total search time divide by number of objects )

max=0.5812898 mS

min=0.046 mS

Second test search

x-coordinate / abscissa : number of search from 1 thru 1000000
y-coordinate / ordinate : average duration ( total search time divide by number of objects )

max=0.485 mS

min=0.34228516 mS