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 edit
To 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 |