info
Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
PB Catalog tables
89 views
Skip to first unread message
Yuri
Dec 21, 2005, 3:02:58 PM12/21/05
to
Is there a way to disable SQL requests for PB catalog tables?
We are using PB10 with Oracle 8i,9i and10g.
Please advise.
thanks,
Yuri
We are using PB10 with Oracle 8i,9i and10g.
Please advise.
thanks,
Yuri
![Jim O'Neil [Sybase]'s profile photo](https://lh3.googleusercontent.com/a/default-user=s40-c)
Jim O'Neil [Sybase]
Dec 21, 2005, 6:29:11 PM12/21/05
to
At runtime or during development? In the database painter, you can
specify whether or not to use the PowerBuilder Repository tables via
the Design->Options dialog. At runtime, you can't disable their use
(they are used for SyntaxFromSql calls, for instance), but if the
tables don't exist, the operation will just quietly continue.
specify whether or not to use the PowerBuilder Repository tables via
the Design->Options dialog. At runtime, you can't disable their use
(they are used for SyntaxFromSql calls, for instance), but if the
tables don't exist, the operation will just quietly continue.
Yuri
Dec 21, 2005, 6:56:21 PM12/21/05
to
Jim,
It happens at runtime. Creating PB catalog tables is not an option for us.
You're right saying that PB is trying access catalog tables when calling
SyntaxFromSql.
Unlike PB8, for some reason PB10 SyntaxFromSql is extremely slow with Oracle
.
It works fine with SQL Server though.
Could absence of catalog tables be the reason of slow performance ?
How to make SyntaxFromSql on Oracle faster?
thanks,
Yuri
It happens at runtime. Creating PB catalog tables is not an option for us.
You're right saying that PB is trying access catalog tables when calling
SyntaxFromSql.
Unlike PB8, for some reason PB10 SyntaxFromSql is extremely slow with Oracle
.
It works fine with SQL Server though.
Could absence of catalog tables be the reason of slow performance ?
How to make SyntaxFromSql on Oracle faster?
thanks,
Yuri
"Jim O'Neil [Sybase]" <joneil_at_sybase_dot_com> wrote in message
news:5lojq1pis2m0ea06p...@4ax.com...
Sanjiv Das [TeamSybase]
Dec 23, 2005, 9:42:26 PM12/23/05
to
To troubleshoot performance of database queries, you could start by
generating a trace of the sql that PB sends to the database. You can look at
the timings in the pb logs and then run that sql directly through a native
database tool. If performance is still slow you can check what the database
is doing in terms of issues such as query optimization, etc.
generating a trace of the sql that PB sends to the database. You can look at
the timings in the pb logs and then run that sql directly through a native
database tool. If performance is still slow you can check what the database
is doing in terms of issues such as query optimization, etc.
Sanjiv.
"Yuri" <yde...@yahoo.com> wrote in message news:43a9eba5$1@forums-1-dub...
Damir Grbic
Jan 30, 2006, 11:33:26 AM1/30/06
to
Hi,
Each access to non existing power builder catalog tables requires server
round trip with error message as response (quietly, which is not presented
to powerbuilder client app).
Powerbuilder is collecting column datatype and precision from
ALL_TAB_COLUMNS which is not a small table. There is also binding of
variables with unicode strings.
You could cache syntax at client or server side...
Regards, Damir
Each access to non existing power builder catalog tables requires server
round trip with error message as response (quietly, which is not presented
to powerbuilder client app).
Powerbuilder is collecting column datatype and precision from
ALL_TAB_COLUMNS which is not a small table. There is also binding of
variables with unicode strings.
You could cache syntax at client or server side...
Regards, Damir
"Sanjiv Das [TeamSybase]" <No-Spam-SDa...@HotMail.Com> schrieb im
Newsbeitrag news:43acb592$1@forums-1-dub...
0 new messages