db space performance analytics improvement suggestion
-
I am interested in integrating the plugin into my clients websites, so I was doing some performance testing.
Test:
I added 10k dummy mouse_clicks rows.Results:
wp_ha_user_event size grew by 2.5MB.Improvement:
The description column can be derived from other columns.
10k rows without the description column will cost 1.5MB instead of 2.5MB.script:
DELIMITER $$ DROP PROCEDURE IF EXISTS test$$ CREATE PROCEDURE test() BEGIN DECLARE count INT DEFAULT 0; WHILE count < 10000 DO INSERT INTO <code>wp_ha_user_event</code>(<code>user_id</code>, <code>user_env_id</code>, <code>event_type</code>, <code>url</code>, <code>x_coord</code>, <code>y_coord</code>, <code>page_width</code>, <code>record_date</code>, <code>data</code>, <code>description</code>, <code>last_updt_date</code>) VALUES (3,3,'mouse_click','https://168.1.27.228/sites/testhotspot/',985-count,15+count,1349,'2015-03-10 19:35:53','', 'A mouse click was made at x = 985 and y = 15.','2015-03-10 19:35:53'); SET count = count + 1; END WHILE; END$$ DELIMITER ; call test();
Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
- The topic ‘db space performance analytics improvement suggestion’ is closed to new replies.