Slow log preview

Hi everyone,

Are there any tips out there for how I can speed up a borehole log preview? I've used several different libraries and I understand that more complex logs take longer. I'm trying to weed out IIf>Hasdata functions and all the other n00b code :)

Does anyone have other suggestions?

info: using component tables, using AGS (modified) database structure

Thanks!

PS

Occasionally, when I try to make a change to a field in Report Design > Logs, after I make the changes and click "ok" I get some text box that says something like "Entity = 0 not saved" and my edit disappears. Anyone else have this problem? I never get this error more than once, but it usually occurs after the first change I try to make. So I just redo what I had done and it goes away. Bizarre.

  • Optimize where ever you can.

    You indicated that you are already cleaning up expressions, but there really isn't much (noticeable) speed to be gained by removing such expressions as IIf(HasData) combinations. Cleaning those up does make for cleaner expressions and is always suggested, so the effort is worthwile.

    Do you have any expressions that are used numerous times on a given report? If so, have you converted any of those to User Report Variables? Each User Report Variable is evaluated once per report output and on complex reports this could result in some noticeable time savings, especially if your expressions result in complex SQL expressions with a large database. And, it sounds like your database might be a bit large since you are using a modified AGS database structure.

    Any files stored on a network drive will also slow down report previews. Moving the files off a network drive is usually not an option, though.

    And, of course, a faster computer ALWAYS helps. <G>