Title: Database size and cache
Last modified: March 14, 2024

---

# Database size and cache

 *  Resolved [davidki](https://wordpress.org/support/users/davidki/)
 * (@davidki)
 * [2 years, 2 months ago](https://wordpress.org/support/topic/database-size-and-cache/)
 * Hello,
 * I have a few questions:
 * 1.
   Can you tell approximately how the database size will change, lets say, after
   1000 visitors are recorded?
 * How many rows are created by your plugin and how much will the database increase
   in kilobits?
 * 2.
   Your plugin use serverside tracking.Is it possible to use caching plugin like
   Fastest cache or similar?
 * Thank you,
 * david

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

 *  Plugin Author [Stefan Klaes](https://wordpress.org/support/users/codenlassen/)
 * (@codenlassen)
 * [2 years, 1 month ago](https://wordpress.org/support/topic/database-size-and-cache/#post-17549225)
 * Hello and thank you for your message. Sorry for my late reply (have to set up
   notifications for this forum)
 * 1.
 * here you can see the rows that are created in the table: [https://github.com/stefan-klaes/simplest-analytics-wordpress-plugin/blob/main/simplest-analytics/includes/class-activator.php](https://github.com/stefan-klaes/simplest-analytics-wordpress-plugin/blob/main/simplest-analytics/includes/class-activator.php)
 * Every page load will save one row in the database. E.g. 1 user visits 100 pages
   = 100 rows or 50 users with 2 avg page views = 100 rows. If you use also click
   tracking it will also create one row per measured click on defined elements.
 * calculating the kilobytes is not that easy. I would guess 1000 rows will be around
   400 kilobytes.
 * my plugin provides an easy solution to delete old rows in case you want to keep
   it small. If you have a website with high traffic it could make sense to calculate
   it more in detail. For super high traffic it could male sense to use external
   services. For smaller/normal websites this should not be a lot of data.
 * 2.
 * Yes, you can use caching plugins. In case you use my plugins click/event tracking
   it could make sense to clear the cache after adding a new tracking because it
   will add javascript to the code. Just to make sure there is no old version cached.
 * If you have further questions please let me know.
 *  Plugin Author [Stefan Klaes](https://wordpress.org/support/users/codenlassen/)
 * (@codenlassen)
 * [2 years ago](https://wordpress.org/support/topic/database-size-and-cache/#post-17729762)
 * I marked this as resolved. In case you have further questions feel free to ask.

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

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

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

 * 2 replies
 * 2 participants
 * Last reply from: [Stefan Klaes](https://wordpress.org/support/users/codenlassen/)
 * Last activity: [2 years ago](https://wordpress.org/support/topic/database-size-and-cache/#post-17729762)
 * Status: resolved