Delay when invoking print preview with picker S’abonner

2
Avatar
USF_Frank

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!

2 commentaires

0
Avatar
Shotaro Ito
Modérateur

When number of rows in connected table are increased, the time to load the form takes longer.

If you can reduce the number of rows by using SQL view etc, that might helps.

The performance might be improved incoming service release.

0
Avatar
USF_Frank

Shotaro,

I connected to another table across the network that had 13000 rows and it came up in about 5 seconds. I provided a copy of the database to Tyler in support and he has your development looking at it. Thanks

Veuillez vous connecter pour laisser un commentaire.