|
Hardware Configuration :
PC1: GA-7VRXP VIA333, AMD Athlon 2000+, 512Mb DDR333, Maxtor 40G 7200, Win2000 SP1, ActiveState Perl 5.6.1
PC2: Intel Celeron 333, 256Mb, Fujitsu 15G, Win2000 SP1, ActiveState Perl 5.6.1
Databases: (one table in each)
DB1:
Number of fields: 2
Number of records: 1,000
DB2:
Number of fields: 2
Number of records: 10,000
DB3:
Number of fields: 10
Number of records: 1,000
DB4:
Number of fields: 2
Number of records: 20,000
|
First two fields of every DB filled as:
| Field1 |
Field2 |
| 0 |
10,000 |
| 1 |
9,999 |
| 2 |
9,998 |
| .. |
.. |
| 9,999 |
1 |
| 10,000 |
0 |
Other fields filled with random strings , length = 10 symbols:
|
TEST1: Walk thougth database:
( stand on each record and read every field data )
| |
DB1 |
DB2 |
DB3 |
DB4 |
| PC1 |
0,094 s. |
1,0 s. |
0,421 s. |
2,31 s. |
| PC2 |
0,762 s. |
7,431 s. |
3,144 s. |
14,821 s. |
|
TEST2: Simple SELECT query:
( select * from tbl_1 where f1 like '%00%' and f2 >= '1500' )
| |
DB1 |
DB2 |
DB3 |
DB4 |
| PC1 |
0,203 s. |
2,078 s. |
0,531 s. |
4,234 s. |
| PC2 |
1,522 s. |
15,2 s. |
3,806 s. |
30,223 s. |
|
|
|
