Delay when invoking print preview with picker Follow
I am new to BT and created a form with a picker referencing a SQLExpress DB (2 tables, inner join, 10,000 rows total in DB). Upon invoking print preview, BT hangs for a few minutes and eventually paints the form with the picker. At that point operations for filtering and selecting text are nearly instantaneous. I have attempted to create a custom SQL to reduce the fields in the select to only what I need as well as removing description fields to see if that would improve performance thinking it might be creating some 'work table' based on the picker I built, but to no avail. I have plenty of available memory on the box (core i5 - nothing special) and SQL is running well below the Express 1GB limit - in fact the entire DB could load into memory (less than 10MB) with lots of room to spare. The delay is very consistent in time and behavior -- am I missing something in the way things are set up? I have seen some similar posts here, but not quite exactly the same, so I thought I would put this out there. Thanks in advance for any suggestions!
Please sign in to leave a comment.