Alec Swan schrieb am 01.06.2012 um 11:55 (-0600): > Our customers complain that Firebird creates 6GB temporary sort file > and we need to address this asap. Can anyone suggest a solution?
That does sound unhealthy. Have you figured out what query or queries are causing these exorbitant temporary sort files? There might be ways of tailoring them such that the sort needed to produce the result is reduced to a more manageable size. Michael
