Follow our news:

Follow canonburysvcs on Twitter Follow Canonbury Services on Facebook Follow Canonbury Services' news by RSS Follow Canonbury Services' news by Atom Follow Canonbury Services' news by email


Beating the 10,000 record SQL limit in GM

23/06/2011 – in SQL queries

** 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:


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.