search

shariffff / dash-todo

A Todo management plugin for WordPress site admin. Stay consistent and never forget anything.
https://wordpress.org/plugins/dash-todo/
0 stars 0 forks source link

Loading Speed of Widget & List #9

Closed KevinOlive2023 closed 1 year ago

KevinOlive2023 commented 1 year ago

My list 10 items takes a few seconds (5 or so) to load the list items. I'm not sure if there is a way to speed this up?

KevinOlive2023 commented 1 year ago

image

shariffff commented 1 year ago

Sorry for the delayed response. The plugin depends on WordPress REST API. If the REST response is slow, the lists will be loading slowly. I'll check if there is a way to improve the performance.

KevinOlive2023 commented 1 year ago

ok thanks, been using it a bit more and I don't add that many at a time and working fine: image

I use it mainly via the Woo App on iPhone and is so handy to be able to capture a new task that can be seen by all on logging into the system or App

KevinOlive2023 commented 1 year ago

Hi I have managed to speed up my loading by adding the following index:

ALTER TABLE olivewdn_wp537.wpnb_posts DROP INDEX ToDoListIndex, ADD INDEX ToDoListIndex (post_type) USING BTREE;