Title: Database size
Last modified: September 11, 2023

---

# Database size

 *  Resolved [davidki](https://wordpress.org/support/users/davidki/)
 * (@davidki)
 * [2 years, 9 months ago](https://wordpress.org/support/topic/database-size-10/)
 * Hello,
 * can you tell approximately how the database size will change, lets say, after
   100,000 visitors are recorded?
 * How many rows are created and how much will the database increase in kilobits?
 * Thank you,
 * david

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Plugin Support [Torsten Landsiedel](https://wordpress.org/support/users/zodiac1978/)
 * (@zodiac1978)
 * [2 years, 9 months ago](https://wordpress.org/support/topic/database-size-10/#post-17040738)
 * Hi [@davidki](https://wordpress.org/support/users/davidki/)
 * we are not counting visitors, but views. Each view results in one database entry.
   Not easy to say how this sums up, as the referrer and target used will differ.
 * But we are working on a data aggregation feature, which will remove the single
   entries and just saves the sum for a period of time.
 * See [GitHub](https://github.com/pluginkollektiv/statify/issues/194) for more 
   details.
 * Hope this helps!
 * All the best
   Torsten
 *  Plugin Support [Stefan Kalscheuer](https://wordpress.org/support/users/stklcode/)
 * (@stklcode)
 * [2 years, 9 months ago](https://wordpress.org/support/topic/database-size-10/#post-17042216)
 * The answers strongly depend on some factors.
 * Every visit has an ID (8 Byte) and a date (3 Byte).
   Plus referrer URL and request
   path which can vary from 0 to 255 characters (i.e. each 1020 Byte worst case)
 * Plus DB index overhead.
   Minus potential optimization from the DB backend, both
   paths and referrers are often duplicated.
 * From a real-world site I have 4000 visits in a database with a total of 560 KiB
   storage (224 KiB data, 336 KIb index). So roughly 150 KiB per 1000 visits, maybe
   200-250 should be a fair estimate.
 * (if aggregation will be there anytime in the future, the reduced size will also
   depend on the distribution of targets and referrers)

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Database size’ is closed to new replies.

 * ![](https://ps.w.org/statify/assets/icon-256x256.png?rev=2355063)
 * [Statify](https://wordpress.org/plugins/statify/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/statify/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/statify/)
 * [Active Topics](https://wordpress.org/support/plugin/statify/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/statify/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/statify/reviews/)

 * 2 replies
 * 3 participants
 * Last reply from: [Stefan Kalscheuer](https://wordpress.org/support/users/stklcode/)
 * Last activity: [2 years, 9 months ago](https://wordpress.org/support/topic/database-size-10/#post-17042216)
 * Status: resolved