Generated 01.07.2022 10:49
Tested: FB40. Build: 4.0.2.2796; SS: 01.07.22 08:43:02 - 01.07.22 09:44:23; CS: 01.07.22 09:46:24 - 01.07.22 10:47:49;
OS and hardware info: Windows 10 10.0.19041 ; logical CPUs: 8 ; total memory: 31.7 Gb
NN | Test name | mode | 4.0.2.2796 2022-07-01 |
4.0.2.2794 2022-06-30 |
4.0.2.2793 2022-06-29 |
4.0.2.2792 2022-06-28 |
4.0.2.2789 2022-06-26 |
4.0.2.2787 2022-06-24 |
4.0.2.2780 2022-06-17 |
4.0.2.2779 2022-06-15 |
4.0.2.2776 2022-06-10 |
4.0.2.2775 2022-06-09 |
4.0.2.2774 2022-06-08 |
4.0.2.2772 2022-06-03 |
4.0.2.2771 2022-06-01 |
4.0.2.2770 2022-05-25 |
4.0.2.2768 2022-05-24 |
4.0.2.2767 2022-05-20 |
4.0.2.2766 2022-05-19 |
4.0.2.2764 2022-05-12 |
4.0.2.2763 2022-05-06 |
4.0.2.2762 2022-05-01 |
4.0.2.2761 2022-04-24 |
4.0.2.2758 2022-04-12 |
4.0.2.2757 2022-04-10 |
4.0.2.2750 2022-04-07 |
4.0.2.2746 2022-04-04 |
4.0.2.2745 2022-03-27 |
4.0.2.2744 2022-03-24 |
4.0.2.2739 2022-03-11 |
4.0.2.2738 2022-03-09 |
4.0.2.2737 2022-03-08 |
Test TITLE |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | SS | F | P | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | 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 | 4.0.2.2796 2022-07-01 |
4.0.2.2794 2022-06-30 |
4.0.2.2793 2022-06-29 |
4.0.2.2792 2022-06-28 |
4.0.2.2789 2022-06-26 |
4.0.2.2787 2022-06-24 |
4.0.2.2780 2022-06-17 |
4.0.2.2779 2022-06-15 |
4.0.2.2776 2022-06-10 |
4.0.2.2775 2022-06-09 |
4.0.2.2774 2022-06-08 |
4.0.2.2772 2022-06-03 |
4.0.2.2771 2022-06-01 |
4.0.2.2770 2022-05-25 |
4.0.2.2768 2022-05-24 |
4.0.2.2767 2022-05-20 |
4.0.2.2766 2022-05-19 |
4.0.2.2764 2022-05-12 |
4.0.2.2763 2022-05-06 |
4.0.2.2762 2022-05-01 |
4.0.2.2761 2022-04-24 |
4.0.2.2758 2022-04-12 |
4.0.2.2757 2022-04-10 |
4.0.2.2750 2022-04-07 |
4.0.2.2746 2022-04-04 |
4.0.2.2745 2022-03-27 |
4.0.2.2744 2022-03-24 |
4.0.2.2739 2022-03-11 |
4.0.2.2738 2022-03-09 |
4.0.2.2737 2022-03-08 |
Test TITLE |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | SS | 16270 | 5200 | 5100 | 5160 | 5110 | 5190 | 5090 | 16290 | 16240 | 16270 | 16270 | 16290 | 16350 | 16440 | 16290 | 16120 | 16270 | 16270 | 16420 | 18530 | 16530 | 15080 | 16320 | 16380 | 16530 | 16200 | 16320 | 16310 | 16380 | 16230 | 16210 | SIMILAR TO is substantially (500-700x) slower than LIKE on trivial pattern matches with VARCHAR data. |