Reduce browscap table size

Created on 21 January 2015, about 10 years ago
Updated 26 November 2024, 2 months ago

As of Browscap data version 5308, the browscap table consumes about 170MB for MySQL InnoDB and 80MB for MySQL MyISAM. However, the source Browscap INI file is only about 12MB, so the tables are not as small as they could be. It is believed the increase in size is due to the inheritance of properties per user agent prior to inserting them into the database.

Would like to explore whether it is possible to reduce the size of these tables without hurting performance. The large table sizes can be problematic in some installations.

✨ Feature request
Status

Closed: outdated

Version

2.0

Component

Code

Created by

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

  • πŸ‡ΊπŸ‡¦Ukraine AstonVictor

    I'm closing it because the issue was created a long time ago without any further steps.

    if you still need it then raise a new one.
    thanks

Production build 0.71.5 2024