Generated 25.05.2022 10:52
Tested: FB50. Build: 5.0.0.501; SS: 25.05.22 06:02:36 - 25.05.22 08:28:20; CS: 25.05.22 08:31:17 - 25.05.22 10:49:39;
OS and hardware info: Windows 2008ServerR2 6.1.7601 ; logical CPUs: 4 ; total memory: 8.0 Gb
NN | Test name | mode | 5.0.0.501 2022-05-25 |
5.0.0.499 2022-05-24 |
5.0.0.498 2022-05-21 |
5.0.0.497 2022-05-20 |
5.0.0.496 2022-05-19 |
5.0.0.494 2022-05-14 |
5.0.0.493 2022-05-12 |
5.0.0.492 2022-05-07 |
5.0.0.491 2022-05-06 |
5.0.0.489 2022-05-01 |
5.0.0.488 2022-04-25 |
5.0.0.487 2022-04-24 |
5.0.0.482 2022-04-23 |
5.0.0.475 2022-04-16 |
5.0.0.472 2022-04-12 |
5.0.0.471 2022-04-10 |
5.0.0.469 2022-04-08 |
5.0.0.467 2022-04-07 |
5.0.0.459 2022-04-06 |
5.0.0.457 2022-04-04 |
5.0.0.455 2022-04-03 |
5.0.0.451 2022-04-02 |
5.0.0.448 2022-04-01 |
5.0.0.445 2022-03-31 |
5.0.0.442 2022-03-30 |
5.0.0.440 2022-03-28 |
5.0.0.439 2022-03-25 |
5.0.0.437 2022-03-24 |
5.0.0.426 2022-03-11 |
5.0.0.425 2022-03-08 |
Test TITLE |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | CS | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | F | P | P | P | P | P | P | P | P | P | P | SIMILAR TO is substantially (500-700x) slower than LIKE on trivial pattern matches with VARCHAR data. |
NN | Test name | mode | median_ms | 5.0.0.501 2022-05-25 |
5.0.0.499 2022-05-24 |
5.0.0.498 2022-05-21 |
5.0.0.497 2022-05-20 |
5.0.0.496 2022-05-19 |
5.0.0.494 2022-05-14 |
5.0.0.493 2022-05-12 |
5.0.0.492 2022-05-07 |
5.0.0.491 2022-05-06 |
5.0.0.489 2022-05-01 |
5.0.0.488 2022-04-25 |
5.0.0.487 2022-04-24 |
5.0.0.482 2022-04-23 |
5.0.0.475 2022-04-16 |
5.0.0.472 2022-04-12 |
5.0.0.471 2022-04-10 |
5.0.0.469 2022-04-08 |
5.0.0.467 2022-04-07 |
5.0.0.459 2022-04-06 |
5.0.0.457 2022-04-04 |
5.0.0.455 2022-04-03 |
5.0.0.451 2022-04-02 |
5.0.0.448 2022-04-01 |
5.0.0.445 2022-03-31 |
5.0.0.442 2022-03-30 |
5.0.0.440 2022-03-28 |
5.0.0.439 2022-03-25 |
5.0.0.437 2022-03-24 |
5.0.0.426 2022-03-11 |
5.0.0.425 2022-03-08 |
Test TITLE |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | CS | 15825 | 15950 | 15660 | 15800 | 15850 | 15690 | 15710 | 15720 | 15870 | 15770 | 16130 | 15830 | 14740 | 16490 | 15830 | 15680 | 15580 | 15630 | 15740 | 15650 | 16000 | 16280 | 15000 | 15840 | 15860 | 15820 | 25070 | 15730 | 15930 | 15900 | 15830 | SIMILAR TO is substantially (500-700x) slower than LIKE on trivial pattern matches with VARCHAR data. |