Re: IDS 9.30 consumes too much temp dbspace

Check UC7 as there has been many fixes. On Thu, 2004-05-06 at 12:13, Ben Thompson wrote: > There is a bug in 9.30.UC3 where the temporary dbspace on the secondary > server in a HDR pair is not released after use. Can be worked around by > bouncing the secondary. I believe this is fixed, certainly in 9.40.UC3. > > Crystal Reports can also be very inefficient as many if not all of your > selection criteria are applied by Crystal itself and not by using SQL. > Thus queries can involve processing a lot of data by the DBMS and thus > can use a lot of temporary space. We have worked around this "feature" > of Crystal by selecting our data from a view which means that the view > definition can exclude data we're not interested in and the DBMS does > not have to work so hard. > > Ben. > sending to informix-list