In progress
Thai Wikipedia, a medium sized wiki, was the second wiki to have both lazy loaded references and images enabled. It was deployed on 12th July 2016 at 4.14pm PST.
Sanity checking
editTo get a general sense of impact on performance after 19 days of the change being live we took a look at NavigationTiming results. Using the following SQL query, it was possible to take a database dump of all NavigationTiming events logged for 19 days preceding the change (from 23rd June) with 19 days following the change (until 1st August)
select * from NavigationTiming_15485142 where wiki = 'thwiki' and event_mobileMode = 'stable' and timestamp > 20160623001400 and timestamp < 20160801001400
This SQL query gave a sample of 32533 rows of data. With the result of the following query, using a Python script the following command was run
python navtimingcsv.py thwiki.tsv 20160712001400 19
Fully loaded
edit| Label | Sample Size | 95th percentile | median |
|---|---|---|---|
| Before change | 11340 | 22091.45 | 4939.0 |
| After change | 11252 | 18461.1 | 4390.5 |
| Before change (anons) | 11330 | 22135.95 | 4940.0 |
| After change (anons) | 11244 | 18444.0 | 4389.5 |
| Before change (http2) | 7904 | 16494.75 | 4246.0 |
| After change (http2) | 7980 | 14324.15 | 3882.0 |
| Before change (http1) | 3436 | 32467.0 | 7527.5 |
| After change (http1) | 3272 | 26368.4 | 6521.5 |
First paint
edit| Label | Sample Size | 95th percentile | median |
|---|---|---|---|
| Before change | 5782 | 7513.95 | 2158.0 |
| After change | 5817 | 7221.2 | 2029.0 |
DomInteractive
edit| Label | Sample Size | 95th percentile | median |
|---|---|---|---|
| Before change | 11340 | 8024.35 | 1971.0 |
| After change | 11252 | 7272.85 | 1842.5 |