Tables in WP database

Hi there!

The first table stores the “All-time” data, while the other one stores the rest of the time ranges data (last 24 hours, last 7 days, and so on).

Amazing! After your almost immediate reply I understand why the plugin is so successful. Many thanks, the info is very helpful for adjustments. All good wishes for your work.

Mind that the popularpostsdata table might be gone in a future release, I haven’t decided that yet.

The reason I’m telling you this is that I’ve been thinking of migrating the data stored there into wp_postmeta -which could lead to new features in the future- and WPP wouldn’t need the popularpostsdata table anymore. That’d be one less table on your database ??

However, as I said, I haven’t made the decision yet. So be careful if you’re planning to query these tables directly for whatever reason as they might change or be gone in the future.

Thanks! But it would be possible to use the actual version without updating. I am absolutely satisfied with the given features. It’s a great work. Simple and very effective for the design of the site.

Many thanks for your fast and competent support. After everything works fine, I have one final question. WP gives us the possibility to show the most recent posts on the index page of the main url. Since this page is probably the most frequented one, it would be useful to show these calls too. Is there any possibility with the plugin? Kind Regards.

I’m sorry, I got a bit lost here:

Since this page is probably the most frequented one, it would be useful to show these calls too.

Are you referring to the home page? If so: a long time ago I decided to filter out visits to the home page and archive pages (such as categories and tags) mainly for the following reasons:

• The home page would always be at the top of the popular listing since it’s the most visited page of your site. It didn’t feel right nor useful to me to show visitors the home page or the archive pages on the list (and users would flood this forum with questions like “Why is the home page being listed? I don’t want it, how do I remove it? / Please remove it”.
• Writing to the database each and every time someone visits your home page to keep count of its page views will surely have a noticeable impact on your server’s performance – specially if yours is a high traffic site.

If this is not what you meant, please clarify.

Many thanks for your reply. Yes, indeed, this would be something like a counter for the main url. I have spent some time to further investigate and it seems to be difficult, since the front page has no special post ID, if you choose to display the most recent posts on it. I would be very grateful if you have a workaround, but just forget about it, if it’s too time-consuming for you.

Ah, there was that too: the home page doesn’t necessarily have an associated ID. Some sites use a front page, and some don’t. This was also one of the reasons why I excluded it from the tracking.

Do you want to list your home page on the widget? If this is not the case (eg. you simply want to know how many people reach it) then I could come up with something.

To list the home page on the widget would be the target solution. The info about the visitors I get from the stats in the cpanel. But once again, I really don’t want to waste your time. It’s not essential, I am already very satisfied with the plugin.