We just recently went through this and determined that a major contributing factor for poor performance when running extended processing was the DISABLEBIND=1 setting. This is part of the ConnectString parameter in the IDE Database Painter Profiles, in the ODBC connection DNS entries, and in any Java connectionstring you create.

With the value set to 1 any error message includes the value of the variables. Performeance in our case was 5x slower with this setting.
With the value set to 0 any error message includes the variable placeholders (i.e. :1, :2, :3) instead of the variable values.

You might want to check your connection parameters.

Later -

Olan

Please give more detail on what 'scanning process' is. Otherwise we are just making wild guesses.

Thanks Olan. I will check on your suggestion nd let you know what I find. Also do we have any compile option available to capture  detailed log . ?

Thanks

Ramesh G

Basically we have a warehouse , using the scan gun they scan the barcode and capture the items. PB code is designed to capture the UPC values and quantities and have some other functionalities.  They used to scan  60/70 items per minute. But now it takes 7 seconds to process each item. Hope this helps.

In the compile option I see enable debug symbol. what's the use of it ? Can I check the log anywhere ?

Thanks

Ramesh G

Hi Ramesh;

  Please try this ...

• Close your PB App EXE
• Create a "custom" PB.ini file in notepad.
• Add the following sections to the PB.ini file, as follows...

[Data Window]
Accessibility=0

[DataStore Behavior]
UseHwnd=no

• Save the new PB.ini file & then copy this file to the App EXE's deployment folder
• Restart your PB App EXE & try your scan again.

HTH

Regards ... Chris

That's a very good question. But they verified the scanners , everything looks good. 

Actually they could scan continuously with out any lag but after scanning multiple items it takes so many minutes to process all the scanned items.  

We have 10 warehouses and they scan pretty fast , now this is a big production issue.

As you suggested , I Already checked the  DISABLEBIND setting. I didn't find anything

Thanks

Ramesh G

disable your antivirus to see if that makes things faster

Thanks. Will try.

Ramesh G

Thank you so much. I will try this option.

Ramesh G

Hi Ramesh,

can you reproduce the performance issue when running the application from Powerbuilder? If so, you might be able to use the internal tracing tools to pinpoint what is causing the issue. Go to tools -> System Options and open the "Profiling" tab. Make sure the "Enable Tracing" checkbox is active and choose a trace file name. Then run the application from PB, do a scan and close the app. Then go to File->New->"Tool" tab and select "Profiling Trace View". You will be asked for a pbt file, select the one you just ran. Then go looking for function or event calls with long execution times and dig deeper.

Ramesh,

What would I do in these scenario
1.  Create a standalone app, with a window and datawindow to check whether there is any lag in scanning.  No other fields, no other validatations.
2.  If the performance is ok, then the issue is not at scan time.  
3.  Then add up, a couple of important validations and / or database lookups.

With these steps we will know where the issue could be.   
We following the above steps to identify a similar issue and we optimized the code.

HTH

Happiness Always
BKR Sivaprakash