Performance issue with Oracle native driver for Powerbuilder 9.0.3

Why do we have a very long runtime for a "GET NUMBER OF COLUMNS
SELECTED" in pbtrace.log? Any explanations? The same code for
Powerbuilder 7 works properly, means the "GET NUMBER OF COLUMNS
SELECTED" uses about 0 milliseconds. Thanks.


e. g.


PREPARE WITH BIND VARIABLES:
(a5d008): SELECT ..................................................
(a5d008): DATETIME Length=0 ID=:1
(a5d008): VCHAR Length=10 ID=:2 *XXXXXXXXXX*
(a5d008): INT Length=0 ID=:3  (0.057 MilliSeconds)
(a5d008): GET AFFECTED ROWS: (0.004 MilliSeconds)
(a5d008): ^ 1 Rows Affected
(a5d008): GET NUMBER OF COLUMNS SELECTED: (14817.493 MilliSeconds)
(a5d008): ^ 1 Columns
(a5d008): DESCRIBE SELECT: (0.004 MilliSeconds)
(a5d008): 1 Bind Columns
(a5d008): DECIMAL Length=44
(a5d008): EXECUTE: (0.014 MilliSeconds)
(a5d008): BIND SELECT OUTPUT BUFFER (PowerScript): (0.028
MilliSeconds)
(a5d008): 1 Bind Columns
(a5d008): LONG Length=44
(a5d008): FETCH NEXT: (0.620 MilliSeconds)
(a5d008): 	COLUMN=0
(a5d008): GET AFFECTED ROWS: (0.003 MilliSeconds)
(a5d008): ^ 1 Rows Affected
(a5d008): FETCH NEXT: (0.010 MilliSeconds)
(a5d008):
 Error 1 (rc 100)
0
marcel
9/1/2008 3:22:02 PM
sybase.powerbuilder.database 9855 articles. 1 followers. Follow

1 Replies
545 Views

Similar Articles

[PageSpeed] 3

On Sep 1, 5:22=A0pm, marcel.rom...@googlemail.com wrote:
> Why do we have a very long runtime for a "GET NUMBER OF COLUMNS
> SELECTED" in pbtrace.log? Any explanations? The same code for
> Powerbuilder 7 works properly, means the "GET NUMBER OF COLUMNS
> SELECTED" uses about 0 milliseconds. Thanks.
>
> e. g.
>
> PREPARE WITH BIND VARIABLES:
> (a5d008): SELECT ..................................................
> (a5d008): DATETIME Length=3D0 ID=3D:1
> (a5d008): VCHAR Length=3D10 ID=3D:2 *XXXXXXXXXX*
> (a5d008): INT Length=3D0 ID=3D:3 =A0(0.057 MilliSeconds)
> (a5d008): GET AFFECTED ROWS: (0.004 MilliSeconds)
> (a5d008): ^ 1 Rows Affected
> (a5d008): GET NUMBER OF COLUMNS SELECTED: (14817.493 MilliSeconds)
> (a5d008): ^ 1 Columns
> (a5d008): DESCRIBE SELECT: (0.004 MilliSeconds)
> (a5d008): 1 Bind Columns
> (a5d008): DECIMAL Length=3D44
> (a5d008): EXECUTE: (0.014 MilliSeconds)
> (a5d008): BIND SELECT OUTPUT BUFFER (PowerScript): (0.028
> MilliSeconds)
> (a5d008): 1 Bind Columns
> (a5d008): LONG Length=3D44
> (a5d008): FETCH NEXT: (0.620 MilliSeconds)
> (a5d008): =A0 =A0 =A0 COLUMN=3D0
> (a5d008): GET AFFECTED ROWS: (0.003 MilliSeconds)
> (a5d008): ^ 1 Rows Affected
> (a5d008): FETCH NEXT: (0.010 MilliSeconds)
> (a5d008):
> =A0Error 1 (rc 100)

The answer is quite simple. Since PB9 all datetime attributes are
coverd as Oracle TimeStamp datatype. This is the reason why the
optimizer some indexes in the database with date datatype now
ingnored. To solve this issue und go back to the former compatibility
you have to use TimeStamp=3D0 in DBParm parameter for you Powerbuilder
database session object.
0
marcel
9/3/2008 9:06:20 AM
Reply:

Similar Artilces:

PowerBuilder 9.0.2 native Oracle driver for Oracle 10g database
We are migrating from Oracle 8i to 10g. The PowerBuilder 9.0.2 application is extremely slow using PowerBuilder Oracle 8.4 or 9.0 native driver to connect to Oracle 10g database, We had to use 7.3 driver. After using trace we found that the SQL scripts with index hint cause slow down, but they are working ok using Oracle 8.4 driver with Oracle 8i database. Any suggestion which is best way to connect from PowerBuilder 9.0.2 to Oracle 10g database? We have tried the Oracle 8.1.7 client and Oracle 9.0 client. I found a solved case on Sybase support web site, but we do not have support...

PowerBuilder 9.0.1: Connect to Oracle Using the PowerBuilder Native Driver
Could anyone please email me this Solved Cases? It may be related to our production issue. http://info.sybase.com/resolution/detail.stm?id_number=11000397 http://info.sybase.com/resolution/detail.stm?id_number=11008896 Thanks in advance, John johnshi@yahoo.com The first one only affects the development environment, and the second one is only applicable to datawindows build with the old PBDBMS method. What problems are you having? On 12 Oct 2004 08:56:32 -0700, John Shi wrote: >Could anyone please email me this Solved Cases? It may be >related to our production i...

Powerbuilder 9.0 Migration from powerbuilder 7.0.3 problem
Hi all, i was trying an migrate an powerbuilder 7.0.3 application to powerbuilder 9.0(PFC BASED APPLICATION (PFC objects version PB 6.5) ) during migration i am getting this error. tcmborrower.pbl(w_cursor_check).w_cursor_check.open.2: Error C0163: The definition of referenced global variable sqlca was improperly compiled in object trcomps Did anybody faced this kind of error? Thx Ashok JPMORGAN ---== Posted via the PFCGuide Web Newsreader ==--- http://www.pfcguide.com/_newsgroups/group_list.asp First error message which i got during the migration is : tcmappl.pb...

PowerBuilder 9.0 and PowerBuilder 10.0
Hello NG ,,, I have a strange problem , installed both versions of PowerBuilder on the same machine having Windows XP. under Program files\Sybase9 - > PB9.0 was installed . under Program files\Sybase10- > PB10.0 was installed, I was working on XML workspace in PB9.0 where in the library list PBDOM90.PBD was included. By mistake , I opened the same workspace in PB10.0 and the application was migrated completed. Later coming back to PB9.0 and opening the same workspace , found that , in the system tree PDB files has zero object, It is not showing anything and the appl...

hints expression oracle 9.0 in Powerbuilder 9.0
Hello cheers to all. I got this sql from Orable 9.0, we need to put a hint expression in this sql to improve the performance on the execution of the sql, well i dont know if this run fine in sql embeded, because this expression use /* */ operator, like the following example. In powerbuilde these operators are used to put comments in the script.. SELECT /* + INDEX ("CB_MOV_PAG" "CB_MOV_PAG1") */ sum ("CB_MOV_DET"."MON_PAG") FROM "CB_MOV_DET", "CB_MOV_PAG" WHERE ( "CB_MOV_DET"."COD_CIA"...

Where can I get native PB drivers for ( Oracle Version 8.0.0.5) with Oracle Net Client Version 7.3.3
( Oracle Version 8.0.0.5) with Oracle Net Client Version 7.3.3 with SQL *Net version 2.x , 32 bit implementation. All versions of PB Enterprise (5,6,7) have the native O73 driver. If you have PB Professional, you can only use ODBC to connect to Oracle. -- Terry Dykstra (TeamSybase) Canadian Forest Oil Ltd. Check out Sybase Developer's Network: http://www.sybase.com/sdn Veena Madhavi <bveenamadhavi@hotmail.com> wrote in message news:38A8FD91.6218D227@hotmail.com... > ( Oracle Version 8.0.0.5) with Oracle Net Client Version 7.3.3 with SQL > *Net version 2...

Powerbuilder 8.0.3 AND Oracle 9
We're migrating existing Powerbuilder 6.5 apps to Powerbuilder 8.0.3. What kind of databases are supported by PB 8.0.3? We would like to use an Oracle 9 database. Can we connect to an Oracle 9 database using PB 8.0.3??? Thanks for your help!!! See: http://www.sybase.com/detail/1,6904,1011566,00.html -- Andr� <MattC> wrote in message news:9C45782D7D3A127000524BA985256D1E.00524BFC85256D1E@webforums... > We're migrating existing Powerbuilder 6.5 apps to Powerbuilder 8.0.3. What > kind of databases are supported by PB 8.0.3? We would like to use an ...

Powerbuilder 9.0 vs. Powerbuilder 8.0
What is the difference in Powerbilder 9.0 and 8.0? I would like to point out that the Appeon newsgroup is monitored by Sybase and Appeon engineering staff who are very knowledgeable about Appeon issues. Question that are purely PowerBuilder-related are best answered by the staff and users of the PowerBuilder newsgroup: sybase.public.powerbuilder.XXXX. Please post to the appropriate newsgroup so you receive the help you desire. Thanks, Julie Jiang Appeon Corporation <dburris@onesolution.com> wrote in message news:40589011.2717.846930886@sybase.com... > What is the diffe...

PowerBuilder Oracle Driver for Oracle 8.0.4 and 8.0.5
You may now register for the beta program for the PowerBuilder O84 native driver at the following URL http://www.sybase.com/products/powerbuilder/oracle/oracle_reg.html Has anyone been using this? Any comments? On Mon, 14 Dec 1998 11:32:31 -0500, in powersoft.public.powerbuilder.database Dan Skibba <skibba@sybase.com> wrote: >You may now register for the beta program for the PowerBuilder O84 native >driver at the following URL >http://www.sybase.com/products/powerbuilder/oracle/oracle_reg.html > > One of the things you do when you sign up for a beta ...

Powerbuilder 10.0 Microsoft Native Database Driver...
I installed Powerbuilder 10.0 but couldn't find Microsoft Native Database Driver for SQL Server...I tried even Custom option but still didn't see anywhere... Am I missing something or is it in different place ?? Not supported. Native for MS SQL Server is OLE_DB(MSSQLDB) or ADO.NET PB's MSS driver is based on db-lib. MS has announced that it will no longer provide db-lib on future SQL server releases. MS has recommended other driver options for several years, namely ole-db and ado.net db-lib was not Unicode compliant "Verticent" <support@verticent...

Issues with Powerbuilder 8.0.3 and Oracle 8i
We have application on powerbuilder 8.0. We have applied 8.0.3 patch since then we are getting problem with computed columns in datawindow. On computed columns with alias name and there is no space between name and '' then pb gives ora-00904 invalid column name error. Powerbuilder is putting "" quotes around the computed column with oracle. Same datawindow works fine with SQL Server 2000 and sybase databases. It used to work fine with PB8.0. In tace fine we saw the column is like this "''address_title". We add space between column alias name ''...

Powerbuilder 6.0
I am looking for oracle 8i native (NOT ODBC) driver for powerbuilder 6.0. Can some one point me to the right place or provide me information on this. Thank you! ---== Posted via the PFCGuide Web Newsreader ==--- http://www.pfcguide.com/_newsgroups/group_list.asp There is no native 8i driver in PB6 which has been end of lifed since Sept 2001. Oracle 8i support was introduced in PB7. You can however, use the Oracle native driver for 8.0.4 for connectivity but you will not have access to 8i features. /ck "Giri Vidapanakal" <srvidapanakal@icpmech.navy.mil> wrote in m...

Strange Oracle Issue with 9.2.0.2 and 9.2.0.3
I wonder if anyone has seen this issue ... We have a successfully compiled DBD 1.12 and 1.14 running on a RedHat 7.2 server -- when setting RowCacheSize to a number more that 1000 we garbled data -- Also using the -1000 value does the same. I have seen a few tidbits of data on the net and Oracle's Metalink talking about a possible bug with >= 9.2.0.2 Oracle but to patches and no bugs reported. The problem disappears with setting RowCacheSize to something small like 100 or 0. Also the problem is not seen <= 9.2.0.1 Oracle Client. I am about to write up a TAR on this with Ora...

PowerBuilder 9.0.3 and Oracle 10 64bit client
Hello. We are trying to connect PowerBuilder 9.0.3 app to Oracle 10 64bit client on terminal server. Are there any known issues? When app launches, error appears saying OCI cannot be loaded. Installing 32bit oracle client works fine. Tnx. Does Oracle support this? It would require them to have a 'thunking' layer to handle the 32-bit to 64-bit translation. Presuming Oracle can make the 64-bit client behave in a 32-bit mode, I would think you'd be ok, but this is definitely not a configuration that we test with PowerBuilder. On 9 Oct 2006 05:58:27 -0700, Uro...

Web resources about - Performance issue with Oracle native driver for Powerbuilder 9.0.3 - sybase.powerbuilder.database

PowerBuilder - Wikipedia, the free encyclopedia
PowerBuilder is an integrated development environment owned by Sybase , a division of SAP . It has been in use since 1991, peaking around 1998 ...

Sybase PowerBuilder tool readied for Microsoft's .Net
... Win32 or newer style .Net development After several years of work, Sybase is ready to deliver on the final step in its plan to move PowerBuilder ...

Jim O'Neil (@jimoneil) on Twitter
Sign in Sign up To bring you Twitter, we and our partners use cookies on our and other websites. Cookies help personalize Twitter content, tailor ...

Open Directory - Computers: Programming: Languages
about dmoz - dmoz blog - report abuse/spam - help the entire directory only in Programming/Languages Description Top : Computers : Programming ...

The HP Booth Staff (Goons) Owe Me an Apology
... when you might need to use it. For instance, when I was in the WinRunner world there were plugins for driving terminal emulators and powerbuilder ...

Contact Us - Sybase Inc
Thanks for visiting the 主页 section of Sybase.com. Here you will find information about Contact Us. For more information about Business Intelligence, ...

热门搜索 - 我的异常网
... 我的异常网 » 热门搜索 sdpnet2 移动【A111】其它用户原因鉴权失败,是什么意思啊 http:// 192.168.1.102:22578 本网站服务器位于美国,受美国法律保护 MiniUI js 破解 http://192.168.1.103:8080/ powerbuilder ...

Mobile app security: Always keep the back door locked
The best way to keep mobile apps safe is to secure the services they connect to.

10 Tech Skills That Will Instantly Net You A $100,000+ Salary
... that let's developers run Java applications. Java is highly popular language for writing web apps and custom enterprise apps. No. 8: PowerBuilder ...

Top Ranked Articles
Top Ranked Articles - Free source code and tutorials for Software developers and Architects.; Updated: 23 Feb 2013

Resources last updated: 1/18/2016 1:49:53 AM