Table: faqsearches

You have a suggestion for a future version of phpMyFAQ? Then post it here!

Moderator: Thorsten

Post Reply
pmfuser
Posts: 106
Joined: Tue Apr 01, 2014 7:00 am

Table: faqsearches

Post by pmfuser » Wed Apr 09, 2014 6:18 pm

I see that this particular table lists search terms individually, meaning, same terms that get searched more than once take up another row within the table.

I don't know why is this, but wonder if it would be easier for the system to have terms written into the table only once, and then simply increase the count whenever the particular term is searched again with same attributes (language, exact characters). Then, have the admin system pull the data for Search Statistic simply by reading a single row, rather than going through the whole table to count how many times a particular term is there.

This means there would be a column in addition to the existing ones, i.e. called Count, and that one would correspond to the Count in admin panel.

Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests