not for the moment, sorry
these kind of SQL queries could slow down too much the web site, you can add it by yourself in stapress.php file in the function luc_StatPressV_Vars
it’s for a widget, so it’s cached and only updated once a day.
i don’t like changing source in a plugin – next update will kill it and i have to reinsert it.
is it very hard for you to insert this query as new %var%? maybe as %toppost|numbers_to_show% or %toppage|5|categorie% ?
would be very very nice 🙂
No, the SQL queries of the widgets are update each call. So, the use of widgets is not recommended.
This SQL query is a join between two tables: StatPress and a table WordPress or require so a lot of work PHP to achieve this join. This will slow down the display of the web page.
ok – just wondering what widget-cache does then. i thought it’s the goal of that plugin to reduce queries like these.
i used statpress only because of the widget – there are smarter stats plugins with more options.
The number of SQL queries has already been greatly reduced in all pages of the plugin compared to all other derivatives StatPress. That makes StatPress Visitors the fastest StatPress.
Further reduce the query widgets is an enormous task of recoding the entire plugin because it requires as many counters as displayable variables.
I do not know the stats of other plugins, what those other plugins?
What are they doing more?
WP SlimStat / WP SlimStat Dashboard Widgets / WP SlimStat ShortCodes
for example.
i just need ONE plugin for visitor analysis and a widgets with visitory ever, page hits ever, top posts/pages per categorie.
and “hacking” plugins is a pain, when the next update comes.
a simple time()-call in a widget with widget-cache is cached and not executed – so i wonder why your widgets are updated/executed.
I do not know WP SlimStat, but from what you describe, the problem will be the same, all display of stats requires at least one SQL query through the entire database and thus slow down the page display. Whether done by SlimStat or other will not change anything.
Widgets are inherited from the Original StatPress. I personally never use them, i keep it like the original Statpress.
The problem of widgets stats, is that they slow down the display of web pages.
I do not know this technique od widgets-cache, it’s interesting, you have sources?
http://wordpress.org/extend/plugins/wp-widget-cache/
maybe the problems are the same – but i don’t use most widgets for realtime display – thanks cache.
i like on slimstat to use kind of sql-code in the widget, so it’s a bit more comfortable. in adminarea are some others features that you have – maybe have a look.
If you have any hacks to offer, please do, I will integrate the next version.
i think i just add the code for my sql-querys for the top posts/pages.
