SLOW FORM LOAD IN PRINT STATION Seguir

0
Avatar
Erik Nordström

Hi!

We have a form that loads about 3-400 records from an IBM DB2 database on form load. in print station. This load can sometimes take up to 30-40 seconds (even longer). When refreshing the data once the form is loaded this is done in less than 2s.

So, I am looking for ways to optimize my form load, but I cannot determine (this is not network related; those tests have been done) where to begin? Sorry if I am posting this in the wrong forum, but I am thinking this is somehow related to the database connection/print station.

 

Thanks for your input

3 comentarios

0
Avatar
Pete Thane
Acciones de comentarios Permalink

Hi Erik,

Is the delay just in Print Station or do you get the same issue in Designer too?

 

0
Avatar
Erik Nordström
Acciones de comentarios Permalink

Hi Peter!

This delay only occurs (or the significant delay) in print station. The sql query being used only pulls about 800 rows and is not complex.

 

Any thoughts? settings that can be manipulated?

 

0
Avatar
Pete Thane
Acciones de comentarios Permalink

I just encountered something similar with a multitable Access database but that was down to the network itself (two sites and one slower than the other).

If it is a viable option, you could enable the Repeat data entry until cancelled option in the label format (open the label in Designer and from the Print Screen click on the Options tab to access this then save the label afterwards). Make sure to add your database lookup/query/filter to a field on the Data Entry Form. With this ticked after they print a label run, Print Station will reopen at the Data Entry screen again rather than having the users to open the label from scratch.

This improved the overall performance  with my customer as they were printing some print runs from a few hundred upwards labels and so BT was ready to go again by the time the batch was finished.

Iniciar sesión para dejar un comentario.