How can I control how the Frequent Items database works?

The features described in this page require Quick Access Popup v9.2 or more recent.

Setting up the Frequent Items database

The first time QAP is launched, it installs the SQLite files required to collect data about your Windows and QAP usage. These files are saved in the same folder where are installed Quick Access Popup executable file.

A database named QAP_Frequent.DB is then created in the QAP working directory. Periodically (by default every minute), QAP stores in this database the Recent Items collected from Windows since the last update. This very light background process is unnoticeable from a performance point of view.

QAP also logs in this database your QAP menu usage. It allows to track recent folders open in QAP that would not be added to the Windows Recent Items. In a future release, it will also allows to produce some stats on your QAP usage (strictly for your personal use).

For more curious and technical users wishing to browse this database, I recommend the use of the free app SQLite Browser (this tool is not be required for normal users).

Configuring the Frequent Items database

You can set the parameters of the Frequent Items database in Options. Under the More tab, click the Quick Access Popup Database button. In this window, you can enable or disable the database. If is is disabled, the Frequent Folders and Frequent Files menus will be empty (use the Settings to remove them if you do not use them).

 

When enabled, the database is refreshed by default every 60 seconds. You can change this under Collection interval (seconds).

You can also set the period considered when building the Frequent Items menus. For example, if you would like to see your most used items in the last week, set the Number of days to take into account in Frequent Items menus to 7. By default, the period is of 30 days. You can also increase it if you prefer to see your long term most used items.

By default the database size is limited to 3 MB. This should be enough for 30 days of normal use of QAP. But if you are an intensive user or if you wish to keep a longer period, increase this size. There is no limit to the number of days or size of the database. When the size limit is exceeded, oldest items are removed until the maximal size is respected.

Introduced in v9.4.1.6, the checkbox Retrieve icon when refreshing Frequent folders and Frequent files menus (avoid if you often have offline files) tells QAP to retrieve file or folder icons when refreshing the Frequent Folders and Frequent Files menus. If you sometimes have offline network files in your Recent Items Windows folder (for example, if your portable computer is attached to network drives at work but not when you are outside office), you should avoid enabling this option (the QAP menu would get longer and longer to show up when you invoke it). This option is disabled by default. If you do not work with files on network servers or if these servers are always connected to your PC, you can enable this option to retrieve custom folder icons and more file icons.

If you would like to see the ranking of items in the Frequent menus, enable the Show frequency index in Settings and menus. This will show that value for each item in the menus and also in the Settings window for item found in the database.

Finally, if for privacy or any other reason, you want to delete the database content, click the Flush Frequent Items database button . This will delete all items from the database. After you restart QAP, the Frequent and Recent items menus will be empty. If you keep the database enabled, these menus will be repopulated as new contents from the Windows Recent Items will be added, starting at the time of the last collection.

What if the Recent menus remains empty?

The Recent Folders and Recent Files menus are populated from the Windows Recent Items folder. Check if you have recent folders and files in this system folder:

C:\Users\Username\AppData\Roaming\Microsoft\Windows\Recent
(replace "Username" with your own user name)
or enter
%APPDATA%\Microsoft\Windows\Recent Items

If this folder is empty (or outdated), enable it in Window control panel. See instructions on one of these pages: for Windows 10 or Windows 7.

Please use the new QAP Support Forum to ask questions or post comments.