# CMS Performance

**URL:** <https://discuss.httparchive.org/t/cms-performance/1468>\
**Category:** Analysis\
**Created:** [September 11, 2018, 10:20am UTC](https://discuss.httparchive.org/t/cms-performance/1468 "2018-09-11T10:20:15Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![rviscomi](https://yyz1.discourse-cdn.com/flex035/user_avatar/discuss.httparchive.org/rviscomi/32/835_2.png) [@rviscomi](https://discuss.httparchive.org/u/rviscomi)\
**Post date:** [September 11, 2018, 10:52am UTC](https://discuss.httparchive.org/t/cms-performance/1468/3 "2018-09-11T10:52:23Z")

</div>

> [@eva2000](#):
>
> Interesting stats. Wonder how that breaks down by mobile vs desktop ? 🙂

Yeah, it’s easy to add the form factor dimension:

```sql
SELECT
  app,
  COUNT(DISTINCT origin) AS freq,
  IF(form_factor.name = 'desktop', 'desktop', 'mobile') AS form_factor,
  ROUND(SUM(IF(bin.start < 1000, bin.density, 0)) / SUM(bin.density), 4) AS fast,
  ROUND(SUM(IF(bin.start >= 1000 AND bin.start < 3000, bin.density, 0)) / SUM(bin.density), 4) AS avg,
  ROUND(SUM(IF(bin.start >= 3000, bin.density, 0)) / SUM(bin.density), 4) AS slow
FROM
  `chrome-ux-report.all.201808`,
  UNNEST(first_contentful_paint.histogram.bin) AS bin
JOIN (
  SELECT
    url,
    app
  FROM
    `httparchive.technologies.2018_08_15_desktop`
  WHERE
    category = 'CMS'
  GROUP BY
    url,
    app)
ON CONCAT(origin, '/') = url
GROUP BY
  app,
  form_factor
ORDER BY
  freq DESC

```

 ![image](https://canada1.discourse-cdn.com/flex035/uploads/httparchive/original/2X/8/8b79f722ada5a9c083414920f3a9cd5f7f971d3a.png)

 ![image](https://canada1.discourse-cdn.com/flex035/uploads/httparchive/original/2X/1/1e03b0d02ad0bc4294648572dd54e72fde7ac60d.png)

[Explore the raw data](https://docs.google.com/spreadsheets/d/1lBQ0T1VBlBrpkv5Q1vQJkU8hnya_5tRczf9c5TfIgnQ/edit?usp=sharing)

---

_[View the full topic](https://discuss.httparchive.org/t/cms-performance/1468)._