Title: Plugin performance with DB writes
Last modified: August 20, 2016

---

# Plugin performance with DB writes

 *  [traderstuart](https://wordpress.org/support/users/traderstuart/)
 * (@traderstuart)
 * [13 years, 7 months ago](https://wordpress.org/support/topic/plugin-performance-with-db-writes/)
 * I have written a plugin that stores a new record in a DB table every time a user
   clicks on a page.
 * Also when a page is loaded a new record is written to another DB table storing
   the browser window size, scrolling on the same page will then cause this record
   to be updated with a new window depth value. In order to make this more efficient
   I have a one second timeout and check if the new maximum depth is greater than
   the previous depth before deciding whether to update the record.
 * All this is being done using jQuery with Ajax calls back to PHP code.
 * My question is what sort of performance can I expect from WP/MySQL? In particular
   are there:
    * limits as to how many Ajax calls site wide can be made at any one
   time * limits as to how many database writes site wide can be made at any one
   time * size “limits” on the DB tables at which point performance starts to deteriorate
   due to writes and updates taking longer * any other considerations I have not
   thought of
 * I need to know if there are limits around which WP stability can be guaranteed.
   I can’t afford the situation where the plugin causes a site to “crash” because
   a large number of visitors is generating more DB interaction than WP/Ajax/MySQL
   can cope with. I realize that the type of web hosting could affect the answers
   but it would be great if I could say the plugin can support up to X concurrent
   users, Y database records etc.

The topic ‘Plugin performance with DB writes’ is closed to new replies.

## Tags

 * [ajax](https://wordpress.org/support/topic-tag/ajax/)
 * [jquery](https://wordpress.org/support/topic-tag/jquery/)

 * 0 replies
 * 1 participant
 * Last reply from: [traderstuart](https://wordpress.org/support/users/traderstuart/)
 * Last activity: [13 years, 7 months ago](https://wordpress.org/support/topic/plugin-performance-with-db-writes/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics