Database Size: 4778 Records
Number of queries: 25
Note- Script sleeps for 20 seconds before running each set of benchmarks for a system
Note- You are only allowed to run this script once per 25 minutes ( to reduce stress on server ). So do not refresh; it will issue an error
| System |
Total Time |
Queries/Sec |
|
| > mySQL 4.0.15 |
0.4352 |
10980 |
|
| > PQL 1.0 |
10.9511 |
436 |
|
| > txtSQL 2.2 Final |
1.0548 |
4530 |
|
| > Txt-DB-Api 0.2.2 |
23.5676 |
203 |
|
| > textDB 4.3.4 |
8.1839 |
584 |
|
| > fSQL 1.1 |
7.9248 |
603 |
|
|
| 6 System(s) |
52.1172 Sec |
mySQL 4.0.15
Rep # Query Rows Returned Results (seconds)
1 Name LIKE '%KO%' 2 0.015552043914795
2 Name LIKE '%JR%' 1 0.014580011367798
3 Name LIKE '%YX%' 7 0.014410018920898
4 Name LIKE '%RH%' 90 0.016148090362549
5 Name LIKE '%OR%' 557 0.03453803062439
6 Name LIKE '%DH%' 4 0.014806032180786
7 Name LIKE '%VP%' 7 0.016335964202881
8 Name LIKE '%CC%' 28 0.024291038513184
9 Name LIKE '%WY%' 1 0.01472020149231
10 Name LIKE '%LT%' 202 0.019279003143311
11 Name LIKE '%GK%' 0 0.023627996444702
12 Name LIKE '%NR%' 2 0.015337944030762
13 Name LIKE '%BD%' 0 0.016033172607422
14 Name LIKE '%DV%' 14 0.016635894775391
15 Name LIKE '%YZ%' 14 0.015238046646118
16 Name LIKE '%QS%' 0 0.016412019729614
17 Name LIKE '%XA%' 160 0.017987012863159
18 Name LIKE '%WH%' 4 0.016855001449585
19 Name LIKE '%QC%' 0 0.014503002166748
20 Name LIKE '%FA%' 167 0.019057035446167
21 Name LIKE '%EJ%' 1 0.014982938766479
22 Name LIKE '%LW%' 4 0.016616106033325
23 Name LIKE '%CN%' 9 0.014742136001587
24 Name LIKE '%ZH%' 0 0.016443967819214
25 Name LIKE '%OW%' 39 0.01603102684021
PQL 1.0
Rep # Query Rows Returned Results (seconds)
1 {Name}**'KO' 2 0.94665312767029
2 {Name}**'JR' 1 0.3763861656189
3 {Name}**'YX' 7 0.39242005348206
4 {Name}**'RH' 90 0.41439390182495
5 {Name}**'OR' 557 0.42478895187378
6 {Name}**'DH' 4 0.42224311828613
7 {Name}**'VP' 7 0.41233801841736
8 {Name}**'CC' 28 0.41367483139038
9 {Name}**'WY' 1 0.39578104019165
10 {Name}**'LT' 202 0.38452100753784
11 {Name}**'GK' 0 0.38711094856262
12 {Name}**'NR' 2 0.38085198402405
13 {Name}**'BD' 0 0.38992500305176
14 {Name}**'DV' 14 0.37822604179382
15 {Name}**'YZ' 14 0.4025559425354
16 {Name}**'QS' 0 0.38082194328308
17 {Name}**'XA' 160 0.39020895957947
18 {Name}**'WH' 4 0.38575410842896
19 {Name}**'QC' 0 0.38909506797791
20 {Name}**'FA' 167 0.43391084671021
21 {Name}**'EJ' 1 0.39099812507629
22 {Name}**'LW' 4 0.40415096282959
23 {Name}**'CN' 9 0.40037798881531
24 {Name}**'ZH' 0 0.39851903915405
25 {Name}**'OW' 39 0.42025709152222
txtSQL 2.2 Final
Rep # Query Rows Returned Results (seconds)
1 Name ? 'KO' 2 0.091686010360718
2 Name ? 'JR' 1 0.03830885887146
3 Name ? 'YX' 7 0.059880971908569
4 Name ? 'RH' 90 0.06952691078186
5 Name ? 'OR' 557 0.045642852783203
6 Name ? 'DH' 4 0.037781000137329
7 Name ? 'VP' 7 0.039111852645874
8 Name ? 'CC' 28 0.035629987716675
9 Name ? 'WY' 1 0.046666145324707
10 Name ? 'LT' 202 0.039833068847656
11 Name ? 'GK' 0 0.037870168685913
12 Name ? 'NR' 2 0.038174867630005
13 Name ? 'BD' 0 0.035629987716675
14 Name ? 'DV' 14 0.033029079437256
15 Name ? 'YZ' 14 0.038583993911743
16 Name ? 'QS' 0 0.041514158248901
17 Name ? 'XA' 160 0.034693956375122
18 Name ? 'WH' 4 0.032270908355713
19 Name ? 'QC' 0 0.032571077346802
20 Name ? 'FA' 167 0.047415018081665
21 Name ? 'EJ' 1 0.034080982208252
22 Name ? 'LW' 4 0.031180143356323
23 Name ? 'CN' 9 0.031256914138794
24 Name ? 'ZH' 0 0.041984081268311
25 Name ? 'OW' 39 0.040441036224365
Txt-DB-Api 0.2.2
Rep # Query Rows Returned Results (seconds)
1 Name LIKE '%KO%' 2 0.69915699958801
2 Name LIKE '%JR%' 1 0.7234411239624
3 Name LIKE '%YX%' 7 0.81925201416016
4 Name LIKE '%RH%' 90 0.84526419639587
5 Name LIKE '%OR%' 557 0.92579889297485
6 Name LIKE '%DH%' 4 1.1467659473419
7 Name LIKE '%VP%' 7 0.96167802810669
8 Name LIKE '%CC%' 28 1.0071098804474
9 Name LIKE '%WY%' 1 1.1163878440857
10 Name LIKE '%LT%' 202 0.98884296417236
11 Name LIKE '%GK%' 0 1.2642068862915
12 Name LIKE '%NR%' 2 0.94354701042175
13 Name LIKE '%BD%' 0 1.0728170871735
14 Name LIKE '%DV%' 14 0.91037082672119
15 Name LIKE '%YZ%' 14 0.87669801712036
16 Name LIKE '%QS%' 0 0.89094614982605
17 Name LIKE '%XA%' 160 0.86499214172363
18 Name LIKE '%WH%' 4 1.0873141288757
19 Name LIKE '%QC%' 0 0.89105486869812
20 Name LIKE '%FA%' 167 0.85977792739868
21 Name LIKE '%EJ%' 1 1.0575459003448
22 Name LIKE '%LW%' 4 0.88284182548523
23 Name LIKE '%CN%' 9 0.94180107116699
24 Name LIKE '%ZH%' 0 0.87404012680054
25 Name LIKE '%OW%' 39 0.91590905189514
textDB 4.3.4
Rep # Query Rows Returned Results (seconds)
1 Name ? 'KO' 2 0.3270890712738
2 Name ? 'JR' 1 0.30967497825623
3 Name ? 'YX' 7 0.30110287666321
4 Name ? 'RH' 90 0.32258105278015
5 Name ? 'OR' 557 0.3959789276123
6 Name ? 'DH' 4 0.31038379669189
7 Name ? 'VP' 7 0.33324003219604
8 Name ? 'CC' 28 0.31930708885193
9 Name ? 'WY' 1 0.31201696395874
10 Name ? 'LT' 202 0.35310101509094
11 Name ? 'GK' 0 0.31288909912109
12 Name ? 'NR' 2 0.29835605621338
13 Name ? 'BD' 0 0.31894016265869
14 Name ? 'DV' 14 0.33137583732605
15 Name ? 'YZ' 14 0.33694982528687
16 Name ? 'QS' 0 0.34275484085083
17 Name ? 'XA' 160 0.33347797393799
18 Name ? 'WH' 4 0.33564686775208
19 Name ? 'QC' 0 0.31020998954773
20 Name ? 'FA' 167 0.36872005462646
21 Name ? 'EJ' 1 0.33881282806396
22 Name ? 'LW' 4 0.31453204154968
23 Name ? 'CN' 9 0.31948208808899
24 Name ? 'ZH' 0 0.31364703178406
25 Name ? 'OW' 39 0.3235809803009
fSQL 1.1
Rep # Query Rows Returned Results (seconds)
1 SEARCH Name FOR 'KO' 2 0.82319808006287
2 SEARCH Name FOR 'JR' 1 0.26595497131348
3 SEARCH Name FOR 'YX' 7 0.28362488746643
4 SEARCH Name FOR 'RH' 90 0.30069494247437
5 SEARCH Name FOR 'OR' 557 0.41420102119446
6 SEARCH Name FOR 'DH' 4 0.28771281242371
7 SEARCH Name FOR 'VP' 7 0.27794408798218
8 SEARCH Name FOR 'CC' 28 0.31852912902832
9 SEARCH Name FOR 'WY' 1 0.27489185333252
10 SEARCH Name FOR 'LT' 202 0.33404994010925
11 SEARCH Name FOR 'GK' 0 0.29196286201477
12 SEARCH Name FOR 'NR' 2 0.28283286094666
13 SEARCH Name FOR 'BD' 0 0.28558897972107
14 SEARCH Name FOR 'DV' 14 0.26808905601501
15 SEARCH Name FOR 'YZ' 14 0.28062105178833
16 SEARCH Name FOR 'QS' 0 0.27330207824707
17 SEARCH Name FOR 'XA' 160 0.39333295822144
18 SEARCH Name FOR 'WH' 4 0.27062201499939
19 SEARCH Name FOR 'QC' 0 0.27789998054504
20 SEARCH Name FOR 'FA' 167 0.31633806228638
21 SEARCH Name FOR 'EJ' 1 0.26616096496582
22 SEARCH Name FOR 'LW' 4 0.27882218360901
23 SEARCH Name FOR 'CN' 9 0.30082297325134
24 SEARCH Name FOR 'ZH' 0 0.28078293800354
25 SEARCH Name FOR 'OW' 39 0.27677702903748