Button 0Button 1Button 2Button 3Button 4Button 5

Performance

Mac used for testing: PowerBook Aluminum 15", 1GHz, 1GB RAM
Mac OS X version: 10.3.5
QuickLite version: 1.5 Beta 1

Indexing turned OFF

Number of Records Time to INSERT

(in sec.)

 Total Throughput

(rec./sec.)

 Mirror Table

(in sec.)

 File Size

(in KB)

 Join 'Last'

with 'k'

 Total Throughput

(rec./sec.)

1000

0.42

2360.76

0.06

104

0.02

63516.80

5000

1.26

3958.13

0.20

502

0.08

65729.45

10000

2.21

4530.56

0.35

1010

0.33

30678.92

25000

4.90

5106.45

1.10

2504

1.15

21798.54

50000

9.70

5155.87

1.93

4996

7.18

6960.93


Indexing turned ON
Number of Records Time to INSERT

(in sec.)

 Total Throughput

(rec./sec.)

 Time to Index

(in sec.)

 Total Throughput

(rec./sec.)

 Mirror Table

(in sec.)

 File Size

(in KB)

 Join 'Last'

with 'k'

 Total Throughput

(rec./sec.)

1000

0.40

2515.42

0.17

5789.73

0.24

274

0.00

479331.91

5000

1.29

3861.16

0.67

7433.32

0.85

1330

0.00

1204161.15

10000

2.20

4538.20

1.16

8587.05

1.55

2616

0.00

1997437.43

25000

5.05

4951.74

3.63

68889.33

4.74

6582

0.01

1997437.43

50000

9.75

5126.99

6.96

7188.08

9.30

13128

0.03

1891770.73


© 2004 Tito Ciuro. All Rights Reserved.