Skip to main content



Label printing with custom SQL and multiple parameters is painfully slow



  • Avatar
    Xabier Clemente

    Hi Dan,

    Welcome to the BarTender Community Forums!

    What kind of delay are we talking about? Even if the queries were executed after all parameters have been set, processing these (no matter in which location these might be) should have a negligible delay. This process should be almost instant.

    Could you tell us what BarTender version, edition, and service release are you currently on? You can find this information under the "Help > About" menu in BarTender Designer. If you find the service release is a previous version to the most up to date release we have available for download, we would recommend downloading and installing our latest service release for the BarTender version you are using; as it patches a number of bugs, offers quality of live improvements to the software, etc. Please refer to our article on Updating BarTender's Service Release if you are to update the software.

    Thank you.

  • Avatar
    Dan Voss

    Xabier Clemente I am running Bartender 2021 R6. 

    When I preview the version of this label that uses a custom SQL with query prompts, I experience the following performance characteristics.  From the time that the dataform displays for entry of the query prompts, I have to wait ~6 seconds before the first prompt field is enabled so I can select a value for the prompt.  After I select that prompt is answered, I have to wait ~10 seconds before the second prompt field is enabled so I can select a value.  After I select a value for the second prompt field, there is ~8 seconds delay before the quantity field becomes enabled on the dataform.   

    For comparison, when I use the version of this label that uses a database connection that is configured through the wizard, I am able to move from one prompt field to the next with no delay.  There is about a 2 delay after both filter parameters are set before the quantity field enables.


Please sign in to leave a comment.