Average results gained from three trials using the CodeBase Speed Demo
application (written in C++ and Visual Basic) to create different size database files.
| |
Visual Basic |
C++ |
| |
200,000 Records |
500,000 Records |
200,000 Records |
500,000 Records |
| Skip through Database in Natural Order |
0.078 Sec
2564103 Records/Sec |
0.218 Sec
2293578 Records/Sec |
0.078 Sec
2564103 Records/Sec |
0.218 Sec
2293578 Records/Sec |
| Skip through Database using an Index file |
0.14 Sec
1428571 Records/Sec |
0.344 Sec
1453488 Records/Sec |
0.125 Sec
1600000 Records/Sec |
0.328 Sec
1524390 Records/Sec |
| Create Index on a Character Field |
0.328 Sec
609756 Records/Sec |
0.875 Sec
571429 Records/Sec |
0.328 Sec
609756 Records/Sec |
0.852 Sec
587199 Records/Sec |
| Create Index on a Numeric Field |
0.459 Sec
435350 Records/Sec |
1.175 Sec
425532 Records/Sec |
0.450 Sec
4444444 Records/Sec |
1.156 Sec
432451 Records/Sec |
| Append Records into Database |
0.422 Sec
473934 Records/Sec |
1.078 Sec
463822 Records/Sec |
0.250 Sec
800000 Records/Sec |
0.640 Sec
781250 Records/Sec |
