** Note: The number of previously-viewed items can now be set in Tools > Options > System **

If you use PE you’ll have noticed that it keeps track of the last 50 records you’ve viewed. This is great, but a list that long can slow GoldMine down as well as being less than useful – you’re probably not going to scroll down a list that long to find a record you looked at last week.

You can trim the length of the list to be something more helpful by executing a SQL query. All the usual caveats apply: do a backup first, get an adult to help you when using scissors, etc etc.

In Query Editor (SQL 2000) or Management Studio (SQL 2005) enter the following:


use your_database_name
update history
set cnt=10


Of course, instead of 10 you can use any number you like.

The query will set the number for all users; if you want to limit it to an individual user, amend it to read:


use your_database_name
update history
set cnt=10 where userid=goldmine_user_name