Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Opening the SQL of a DW is very slow if table has triggers

12 posts in DataWindow Last posting was on 2009-08-28 16:11:24.0Z
Antonio Arena Posted on 2009-08-25 09:02:29.0Z
From: "Antonio Arena" <antonio.arena@bluserena.it>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Opening the SQL of a DW is very slow if table has triggers
Lines: 17
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a93a8a5$1@forums-1-dub>
Date: 25 Aug 2009 02:02:29 -0700
X-Trace: forums-1-dub 1251190949 10.22.241.152 (25 Aug 2009 02:02:29 -0700)
X-Original-Trace: 25 Aug 2009 02:02:29 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89815
Article PK: 419002

Hi to all,

we are axperiencing a strange behavour with PB11.5.1.4011: if a DW is based
on a table with triggers (for insert, update and delete), opening the SQL of
the DW requires up to 2 minutes (120 seconds). If I drop the three triggers,
opening the SQL of the DW is immediate. The table has 176 columns and each
trigger has about 1500 lines of code.
I also tried using an empty DB (only with the structure reloaded) but the
behavour doesn't change, so I suppose it's not a matter of number of rows in
the table.
Did anyone have the same problem? Is there a way to fix this?

TIA

Antonio


Chris Pollach Posted on 2009-08-25 12:47:52.0Z
From: "Chris Pollach" <cpollach@travel-net.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4a93a8a5$1@forums-1-dub>
Subject: Re: Opening the SQL of a DW is very slow if table has triggers
Lines: 33
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a93dd78@forums-1-dub>
Date: 25 Aug 2009 05:47:52 -0700
X-Trace: forums-1-dub 1251204472 10.22.241.152 (25 Aug 2009 05:47:52 -0700)
X-Original-Trace: 25 Aug 2009 05:47:52 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89816
Article PK: 419007

Hi Antonio;

We have the same DB structure and no delays are being observed (Oracle).

Since PB has no idea about the presence or non-presence of a Trigger - I
would say that your problem in DBMS related.

--
Regards ... Chris
ISUG - NA RUG Director
http://chrispollach.pbdjmagazine.com

"Antonio Arena" <antonio.arena@bluserena.it> wrote in message
news:4a93a8a5$1@forums-1-dub...
> Hi to all,
>
> we are axperiencing a strange behavour with PB11.5.1.4011: if a DW is
> based on a table with triggers (for insert, update and delete), opening
> the SQL of the DW requires up to 2 minutes (120 seconds). If I drop the
> three triggers, opening the SQL of the DW is immediate. The table has 176
> columns and each trigger has about 1500 lines of code.
> I also tried using an empty DB (only with the structure reloaded) but the
> behavour doesn't change, so I suppose it's not a matter of number of rows
> in the table.
> Did anyone have the same problem? Is there a way to fix this?
>
> TIA
>
> Antonio
>


Antonio Arena Posted on 2009-08-25 14:51:10.0Z
From: "Antonio Arena" <antonio.arena@bluserena.it>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4a93a8a5$1@forums-1-dub> <4a93dd78@forums-1-dub>
Subject: Re: Opening the SQL of a DW is very slow if table has triggers
Lines: 50
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a93fa5e$1@forums-1-dub>
Date: 25 Aug 2009 07:51:10 -0700
X-Trace: forums-1-dub 1251211870 10.22.241.152 (25 Aug 2009 07:51:10 -0700)
X-Original-Trace: 25 Aug 2009 07:51:10 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89819
Article PK: 419004

Hi Chris,

Our DBMS is SQL Anywhere 10.0.1.3831. Also to me It seemed very strange that
removing the triggers from the table solved the problem. It seems that when
PB open the SQL of a DW, if the system tables of the DB contains something
"heavy" (the 1500 lines triggers), the construction of the SQL becomes very
slow. For now, our workaround is to have a development DB without the
triggers.
Thank you for your reply

Antonio

"Chris Pollach" <cpollach@travel-net.com> ha scritto nel messaggio
news:4a93dd78@forums-1-dub...

> Hi Antonio;
>
> We have the same DB structure and no delays are being observed
> (Oracle).
>
> Since PB has no idea about the presence or non-presence of a Trigger - I
> would say that your problem in DBMS related.
>
> --
> Regards ... Chris
> ISUG - NA RUG Director
> http://chrispollach.pbdjmagazine.com
>
>
> "Antonio Arena" <antonio.arena@bluserena.it> wrote in message
> news:4a93a8a5$1@forums-1-dub...
>> Hi to all,
>>
>> we are axperiencing a strange behavour with PB11.5.1.4011: if a DW is
>> based on a table with triggers (for insert, update and delete), opening
>> the SQL of the DW requires up to 2 minutes (120 seconds). If I drop the
>> three triggers, opening the SQL of the DW is immediate. The table has 176
>> columns and each trigger has about 1500 lines of code.
>> I also tried using an empty DB (only with the structure reloaded) but the
>> behavour doesn't change, so I suppose it's not a matter of number of rows
>> in the table.
>> Did anyone have the same problem? Is there a way to fix this?
>>
>> TIA
>>
>> Antonio
>>
>
>


Chris Pollach Posted on 2009-08-25 15:06:38.0Z
From: "Chris Pollach" <cpollach@travel-net.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4a93a8a5$1@forums-1-dub> <4a93dd78@forums-1-dub> <4a93fa5e$1@forums-1-dub>
Subject: Re: Opening the SQL of a DW is very slow if table has triggers
Lines: 63
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a93fdfe@forums-1-dub>
Date: 25 Aug 2009 08:06:38 -0700
X-Trace: forums-1-dub 1251212798 10.22.241.152 (25 Aug 2009 08:06:38 -0700)
X-Original-Trace: 25 Aug 2009 08:06:38 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89820
Article PK: 419005

I also have systems in SA 10 and SA 11 with triggers and have not
noticed any such degradation like you have. PB and the DWO do NOT access any
system tables at run time - only during development. The only exception to
this is dynamic DW's which can use the system tables on the SyntaxFromSQL
( ) command. Might this be your case?

"Antonio Arena" <antonio.arena@bluserena.it> wrote in message
news:4a93fa5e$1@forums-1-dub...
> Hi Chris,
>
> Our DBMS is SQL Anywhere 10.0.1.3831. Also to me It seemed very strange
> that removing the triggers from the table solved the problem. It seems
> that when PB open the SQL of a DW, if the system tables of the DB contains
> something "heavy" (the 1500 lines triggers), the construction of the SQL
> becomes very slow. For now, our workaround is to have a development DB
> without the triggers.
> Thank you for your reply
>
> Antonio
>
> "Chris Pollach" <cpollach@travel-net.com> ha scritto nel messaggio
> news:4a93dd78@forums-1-dub...
>> Hi Antonio;
>>
>> We have the same DB structure and no delays are being observed
>> (Oracle).
>>
>> Since PB has no idea about the presence or non-presence of a Trigger - I
>> would say that your problem in DBMS related.
>>
>> --
>> Regards ... Chris
>> ISUG - NA RUG Director
>> http://chrispollach.pbdjmagazine.com
>>
>>
>> "Antonio Arena" <antonio.arena@bluserena.it> wrote in message
>> news:4a93a8a5$1@forums-1-dub...
>>> Hi to all,
>>>
>>> we are axperiencing a strange behavour with PB11.5.1.4011: if a DW is
>>> based on a table with triggers (for insert, update and delete), opening
>>> the SQL of the DW requires up to 2 minutes (120 seconds). If I drop the
>>> three triggers, opening the SQL of the DW is immediate. The table has
>>> 176 columns and each trigger has about 1500 lines of code.
>>> I also tried using an empty DB (only with the structure reloaded) but
>>> the behavour doesn't change, so I suppose it's not a matter of number of
>>> rows in the table.
>>> Did anyone have the same problem? Is there a way to fix this?
>>>
>>> TIA
>>>
>>> Antonio
>>>
>>
>>
>
>


Antonio Arena Posted on 2009-08-26 13:24:22.0Z
From: "Antonio Arena" <antonio.arena@bluserena.it>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4a93a8a5$1@forums-1-dub> <4a93dd78@forums-1-dub> <4a93fa5e$1@forums-1-dub> <4a93fdfe@forums-1-dub>
Subject: Re: Opening the SQL of a DW is very slow if table has triggers
Lines: 74
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a953786@forums-1-dub>
Date: 26 Aug 2009 06:24:22 -0700
X-Trace: forums-1-dub 1251293062 10.22.241.152 (26 Aug 2009 06:24:22 -0700)
X-Original-Trace: 26 Aug 2009 06:24:22 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89828
Article PK: 419016

Hi Chris,

the problem I am talking about is not at run time, but at design time. The
slowness occurs when we try to modify the SQL in the datawindow painter..

Antonio

"Chris Pollach" <cpollach@travel-net.com> ha scritto nel messaggio
news:4a93fdfe@forums-1-dub...

>
> I also have systems in SA 10 and SA 11 with triggers and have not
> noticed any such degradation like you have. PB and the DWO do NOT access
> any system tables at run time - only during development. The only
> exception to this is dynamic DW's which can use the system tables on the
> SyntaxFromSQL ( ) command. Might this be your case?
>
>
>
> "Antonio Arena" <antonio.arena@bluserena.it> wrote in message
> news:4a93fa5e$1@forums-1-dub...
>> Hi Chris,
>>
>> Our DBMS is SQL Anywhere 10.0.1.3831. Also to me It seemed very strange
>> that removing the triggers from the table solved the problem. It seems
>> that when PB open the SQL of a DW, if the system tables of the DB
>> contains something "heavy" (the 1500 lines triggers), the construction of
>> the SQL becomes very slow. For now, our workaround is to have a
>> development DB without the triggers.
>> Thank you for your reply
>>
>> Antonio
>>
>> "Chris Pollach" <cpollach@travel-net.com> ha scritto nel messaggio
>> news:4a93dd78@forums-1-dub...
>>> Hi Antonio;
>>>
>>> We have the same DB structure and no delays are being observed
>>> (Oracle).
>>>
>>> Since PB has no idea about the presence or non-presence of a Trigger - I
>>> would say that your problem in DBMS related.
>>>
>>> --
>>> Regards ... Chris
>>> ISUG - NA RUG Director
>>> http://chrispollach.pbdjmagazine.com
>>>
>>>
>>> "Antonio Arena" <antonio.arena@bluserena.it> wrote in message
>>> news:4a93a8a5$1@forums-1-dub...
>>>> Hi to all,
>>>>
>>>> we are axperiencing a strange behavour with PB11.5.1.4011: if a DW is
>>>> based on a table with triggers (for insert, update and delete), opening
>>>> the SQL of the DW requires up to 2 minutes (120 seconds). If I drop the
>>>> three triggers, opening the SQL of the DW is immediate. The table has
>>>> 176 columns and each trigger has about 1500 lines of code.
>>>> I also tried using an empty DB (only with the structure reloaded) but
>>>> the behavour doesn't change, so I suppose it's not a matter of number
>>>> of rows in the table.
>>>> Did anyone have the same problem? Is there a way to fix this?
>>>>
>>>> TIA
>>>>
>>>> Antonio
>>>>
>>>
>>>
>>
>>
>
>


Chris Pollach Posted on 2009-08-26 13:58:37.0Z
From: "Chris Pollach" <cpollach@travel-net.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4a93a8a5$1@forums-1-dub> <4a93dd78@forums-1-dub> <4a93fa5e$1@forums-1-dub> <4a93fdfe@forums-1-dub> <4a953786@forums-1-dub>
Subject: Re: Opening the SQL of a DW is very slow if table has triggers
Lines: 83
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a953f8d$1@forums-1-dub>
Date: 26 Aug 2009 06:58:37 -0700
X-Trace: forums-1-dub 1251295117 10.22.241.152 (26 Aug 2009 06:58:37 -0700)
X-Original-Trace: 26 Aug 2009 06:58:37 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89829
Article PK: 419017

Ahh ... very strange - I have never encountered that one!

"Antonio Arena" <antonio.arena@bluserena.it> wrote in message
news:4a953786@forums-1-dub...
> Hi Chris,
>
> the problem I am talking about is not at run time, but at design time. The
> slowness occurs when we try to modify the SQL in the datawindow painter..
>
> Antonio
>
> "Chris Pollach" <cpollach@travel-net.com> ha scritto nel messaggio
> news:4a93fdfe@forums-1-dub...
>>
>> I also have systems in SA 10 and SA 11 with triggers and have not
>> noticed any such degradation like you have. PB and the DWO do NOT access
>> any system tables at run time - only during development. The only
>> exception to this is dynamic DW's which can use the system tables on the
>> SyntaxFromSQL ( ) command. Might this be your case?
>>
>>
>>
>> "Antonio Arena" <antonio.arena@bluserena.it> wrote in message
>> news:4a93fa5e$1@forums-1-dub...
>>> Hi Chris,
>>>
>>> Our DBMS is SQL Anywhere 10.0.1.3831. Also to me It seemed very strange
>>> that removing the triggers from the table solved the problem. It seems
>>> that when PB open the SQL of a DW, if the system tables of the DB
>>> contains something "heavy" (the 1500 lines triggers), the construction
>>> of the SQL becomes very slow. For now, our workaround is to have a
>>> development DB without the triggers.
>>> Thank you for your reply
>>>
>>> Antonio
>>>
>>> "Chris Pollach" <cpollach@travel-net.com> ha scritto nel messaggio
>>> news:4a93dd78@forums-1-dub...
>>>> Hi Antonio;
>>>>
>>>> We have the same DB structure and no delays are being observed
>>>> (Oracle).
>>>>
>>>> Since PB has no idea about the presence or non-presence of a Trigger -
>>>> I would say that your problem in DBMS related.
>>>>
>>>> --
>>>> Regards ... Chris
>>>> ISUG - NA RUG Director
>>>> http://chrispollach.pbdjmagazine.com
>>>>
>>>>
>>>> "Antonio Arena" <antonio.arena@bluserena.it> wrote in message
>>>> news:4a93a8a5$1@forums-1-dub...
>>>>> Hi to all,
>>>>>
>>>>> we are axperiencing a strange behavour with PB11.5.1.4011: if a DW is
>>>>> based on a table with triggers (for insert, update and delete),
>>>>> opening the SQL of the DW requires up to 2 minutes (120 seconds). If I
>>>>> drop the three triggers, opening the SQL of the DW is immediate. The
>>>>> table has 176 columns and each trigger has about 1500 lines of code.
>>>>> I also tried using an empty DB (only with the structure reloaded) but
>>>>> the behavour doesn't change, so I suppose it's not a matter of number
>>>>> of rows in the table.
>>>>> Did anyone have the same problem? Is there a way to fix this?
>>>>>
>>>>> TIA
>>>>>
>>>>> Antonio
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>


Chis Keating (Sybase iAnywhere) Posted on 2009-08-27 19:43:19.0Z
From: "Chis Keating (Sybase iAnywhere)" <keating_nospam@sybase.com>
User-Agent: Thunderbird 2.0.0.21 (Windows/20090302)
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Opening the SQL of a DW is very slow if table has triggers
References: <4a93a8a5$1@forums-1-dub> <4a93dd78@forums-1-dub> <4a93fa5e$1@forums-1-dub> <4a93fdfe@forums-1-dub> <4a953786@forums-1-dub>
In-Reply-To: <4a953786@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a96e1d7$1@forums-1-dub>
Date: 27 Aug 2009 12:43:19 -0700
X-Trace: forums-1-dub 1251402199 10.22.241.152 (27 Aug 2009 12:43:19 -0700)
X-Original-Trace: 27 Aug 2009 12:43:19 -0700, vip152.sybase.com
Lines: 81
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89845
Article PK: 419033

You might need to work with support to identify the cause here. I cannot
imagine why triggers on a table would degrade performance of the
datawindow painter. It is certainly not the result of trigger actions
since the only action occurring initially on load is a SELECT, if enabled.

Perhaps you can look at a request level log (-zr sql , see the SA10 docs
on how you can enable this only via a sp call if you what to enable this
logging after the engine is started) to see what the dw is doing.

Antonio Arena wrote:
> Hi Chris,
>
> the problem I am talking about is not at run time, but at design time. The
> slowness occurs when we try to modify the SQL in the datawindow painter..
>
> Antonio
>
> "Chris Pollach" <cpollach@travel-net.com> ha scritto nel messaggio
> news:4a93fdfe@forums-1-dub...
>> I also have systems in SA 10 and SA 11 with triggers and have not
>> noticed any such degradation like you have. PB and the DWO do NOT access
>> any system tables at run time - only during development. The only
>> exception to this is dynamic DW's which can use the system tables on the
>> SyntaxFromSQL ( ) command. Might this be your case?
>>
>>
>>
>> "Antonio Arena" <antonio.arena@bluserena.it> wrote in message
>> news:4a93fa5e$1@forums-1-dub...
>>> Hi Chris,
>>>
>>> Our DBMS is SQL Anywhere 10.0.1.3831. Also to me It seemed very strange
>>> that removing the triggers from the table solved the problem. It seems
>>> that when PB open the SQL of a DW, if the system tables of the DB
>>> contains something "heavy" (the 1500 lines triggers), the construction of
>>> the SQL becomes very slow. For now, our workaround is to have a
>>> development DB without the triggers.
>>> Thank you for your reply
>>>
>>> Antonio
>>>
>>> "Chris Pollach" <cpollach@travel-net.com> ha scritto nel messaggio
>>> news:4a93dd78@forums-1-dub...
>>>> Hi Antonio;
>>>>
>>>> We have the same DB structure and no delays are being observed
>>>> (Oracle).
>>>>
>>>> Since PB has no idea about the presence or non-presence of a Trigger - I
>>>> would say that your problem in DBMS related.
>>>>
>>>> --
>>>> Regards ... Chris
>>>> ISUG - NA RUG Director
>>>> http://chrispollach.pbdjmagazine.com
>>>>
>>>>
>>>> "Antonio Arena" <antonio.arena@bluserena.it> wrote in message
>>>> news:4a93a8a5$1@forums-1-dub...
>>>>> Hi to all,
>>>>>
>>>>> we are axperiencing a strange behavour with PB11.5.1.4011: if a DW is
>>>>> based on a table with triggers (for insert, update and delete), opening
>>>>> the SQL of the DW requires up to 2 minutes (120 seconds). If I drop the
>>>>> three triggers, opening the SQL of the DW is immediate. The table has
>>>>> 176 columns and each trigger has about 1500 lines of code.
>>>>> I also tried using an empty DB (only with the structure reloaded) but
>>>>> the behavour doesn't change, so I suppose it's not a matter of number
>>>>> of rows in the table.
>>>>> Did anyone have the same problem? Is there a way to fix this?
>>>>>
>>>>> TIA
>>>>>
>>>>> Antonio
>>>>>
>>>>
>>>
>>
>
>


Scott Morris Posted on 2009-08-27 20:20:04.0Z
From: "Scott Morris" <bogus@bogus.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4a93a8a5$1@forums-1-dub> <4a93dd78@forums-1-dub> <4a93fa5e$1@forums-1-dub> <4a93fdfe@forums-1-dub> <4a953786@forums-1-dub>
Subject: Re: Opening the SQL of a DW is very slow if table has triggers
Lines: 22
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a96ea74@forums-1-dub>
Date: 27 Aug 2009 13:20:04 -0700
X-Trace: forums-1-dub 1251404404 10.22.241.152 (27 Aug 2009 13:20:04 -0700)
X-Original-Trace: 27 Aug 2009 13:20:04 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89846
Article PK: 419034


"Antonio Arena" <antonio.arena@bluserena.it> wrote in message
news:4a953786@forums-1-dub...
> Hi Chris,
>
> the problem I am talking about is not at run time, but at design time. The
> slowness occurs when we try to modify the SQL in the datawindow painter..

Perhaps there is a fix in the latest EBF. Below appears related

17123 579422 Customer is in Infomaker 11.5. He has datawindows
(reports) that now take a very long time to open
the SQL Painter (Clicking DataSource). Some
reports take minutes before the SQL appears. In
PB 9.0.3 it displays the SQL very quickly
connected to the exact same database and opening
the same report. Why is this taking so long now?
Can something be fixed in 11.5 to make this
quicker? The database is SQL Anywhere 11 and ODBC
is used to connect. July 17, 2009: Verified fixed
in PB 11.5.1 build 4556 and after.


Chris Pollach Posted on 2009-08-28 13:55:34.0Z
From: "Chris Pollach" <cpollach@travel-net.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4a93a8a5$1@forums-1-dub> <4a93dd78@forums-1-dub> <4a93fa5e$1@forums-1-dub> <4a93fdfe@forums-1-dub> <4a953786@forums-1-dub> <4a96ea74@forums-1-dub>
Subject: Re: Opening the SQL of a DW is very slow if table has triggers
Lines: 42
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a97e1d6@forums-1-dub>
Date: 28 Aug 2009 06:55:34 -0700
X-Trace: forums-1-dub 1251467734 10.22.241.152 (28 Aug 2009 06:55:34 -0700)
X-Original-Trace: 28 Aug 2009 06:55:34 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89852
Article PK: 419040

Hey Scott .. can you try something for me when the triggers are enabled ...

1) Open DataBase Painter
2) Go to the menu "Design => Options".
3) In the Options dialog - uncheck the "Use Extended Attributes" checkbox.
4) Reconnect to the SA database

Does the performance problem still exist?

--
Regards ... Chris
ISUG - NA RUG Director
http://chrispollach.pbdjmagazine.com

"Scott Morris" <bogus@bogus.com> wrote in message
news:4a96ea74@forums-1-dub...
> "Antonio Arena" <antonio.arena@bluserena.it> wrote in message
> news:4a953786@forums-1-dub...
>> Hi Chris,
>>
>> the problem I am talking about is not at run time, but at design time.
>> The slowness occurs when we try to modify the SQL in the datawindow
>> painter..
>
> Perhaps there is a fix in the latest EBF. Below appears related
>
> 17123 579422 Customer is in Infomaker 11.5. He has datawindows
> (reports) that now take a very long time to open
> the SQL Painter (Clicking DataSource). Some
> reports take minutes before the SQL appears. In
> PB 9.0.3 it displays the SQL very quickly
> connected to the exact same database and opening
> the same report. Why is this taking so long now?
> Can something be fixed in 11.5 to make this
> quicker? The database is SQL Anywhere 11 and ODBC
> is used to connect. July 17, 2009: Verified fixed
> in PB 11.5.1 build 4556 and after.
>
>


Scott Morris Posted on 2009-08-28 14:13:10.0Z
From: "Scott Morris" <bogus@bogus.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4a93a8a5$1@forums-1-dub> <4a93dd78@forums-1-dub> <4a93fa5e$1@forums-1-dub> <4a93fdfe@forums-1-dub> <4a953786@forums-1-dub> <4a96ea74@forums-1-dub> <4a97e1d6@forums-1-dub>
Subject: Re: Opening the SQL of a DW is very slow if table has triggers
Lines: 5
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a97e5f6$1@forums-1-dub>
Date: 28 Aug 2009 07:13:10 -0700
X-Trace: forums-1-dub 1251468790 10.22.241.152 (28 Aug 2009 07:13:10 -0700)
X-Original-Trace: 28 Aug 2009 07:13:10 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89853
Article PK: 419041

I'm not the one with the problem - but I have no issues using 11.2 8407. I
was simply reading the release notes and happened to notice/recognize the
problem.


Chris Pollach Posted on 2009-08-28 14:23:38.0Z
From: "Chris Pollach" <cpollach@travel-net.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4a93a8a5$1@forums-1-dub> <4a93dd78@forums-1-dub> <4a93fa5e$1@forums-1-dub> <4a93fdfe@forums-1-dub> <4a953786@forums-1-dub> <4a96ea74@forums-1-dub> <4a97e1d6@forums-1-dub> <4a97e5f6$1@forums-1-dub>
Subject: Re: Opening the SQL of a DW is very slow if table has triggers
Lines: 12
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a97e86a$1@forums-1-dub>
Date: 28 Aug 2009 07:23:38 -0700
X-Trace: forums-1-dub 1251469418 10.22.241.152 (28 Aug 2009 07:23:38 -0700)
X-Original-Trace: 28 Aug 2009 07:23:38 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89854
Article PK: 419042

Sorry .. I meant to post that to Antonio.

"Scott Morris" <bogus@bogus.com> wrote in message
news:4a97e5f6$1@forums-1-dub...
> I'm not the one with the problem - but I have no issues using 11.2 8407.
> I was simply reading the release notes and happened to notice/recognize
> the problem.
>


Antonio Arena Posted on 2009-08-28 16:11:24.0Z
From: "Antonio Arena" <antonio.arena@bluserena.it>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4a93a8a5$1@forums-1-dub> <4a93dd78@forums-1-dub> <4a93fa5e$1@forums-1-dub> <4a93fdfe@forums-1-dub> <4a953786@forums-1-dub> <4a96ea74@forums-1-dub> <4a97e1d6@forums-1-dub> <4a97e5f6$1@forums-1-dub> <4a97e86a$1@forums-1-dub>
Subject: Re: Opening the SQL of a DW is very slow if table has triggers
Lines: 25
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a9801ac@forums-1-dub>
Date: 28 Aug 2009 09:11:24 -0700
X-Trace: forums-1-dub 1251475884 10.22.241.152 (28 Aug 2009 09:11:24 -0700)
X-Original-Trace: 28 Aug 2009 09:11:24 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89855
Article PK: 419043

Hi Chris,

I tried your suggestion but didn't solve the problem. But installing the EBF
that Scott suggested really did. Now opening the SQL of the DW is immediate.

Thank you very much to everyone for your percious support.

Antonio

"Chris Pollach" <cpollach@travel-net.com> ha scritto nel messaggio
news:4a97e86a$1@forums-1-dub...

>
> Sorry .. I meant to post that to Antonio.
>
>
> "Scott Morris" <bogus@bogus.com> wrote in message
> news:4a97e5f6$1@forums-1-dub...
>> I'm not the one with the problem - but I have no issues using 11.2 8407.
>> I was simply reading the release notes and happened to notice/recognize
>> the problem.
>>
>
>