** Note: it is now possible to set the SQL limit from the GoldMine UI – just go to Tools > Configure > System Settings > Display **

When you write a SQL query in GoldMine you are, by default, limited to 10,000 results.
You can break through this barrier though by using a setting in gm.ini:


sqlquerylimit=10000


Instead of 10,000, just use whatever number you need.

If the sqlquerylimit line doesn’t already exist, then simply add in the [goldmine] section.