We recently converted our app from Powerbuilder 5.0 to PB 7.0 -- the app in
PB 7.0 definitely runs slower on the client PC's than it did in PB 5.0.

Now we are migrating the database from MS SQL 6.5 to 7.0 SP2.  We
successfully converted the databases in a testing environment, but now the
app runs terribly slow!  I don't think it's a hardware issue -- the test box
is a Compaq 8500 quad Xeon 500 w/1GB Ram.  We experimented running the app
as a PB 5.0 app against MS SQL 7.0 and the problem is the same.  When we
execute SQL directly against the DB outside of PB, we see no performance
issues.

Is there some kind of issue between PB and MS SQL 7.0?
Has anyone successfully converted to MS SQL 7.0 using a PB app?

thanks,
-- Geoff
g1langos@gte.net or geoffrey.p.langos@bellatlantic.com

Geoff,

I have several PB applications that run aganst a SQL Server 7 database, and
have not noticed any major performance issues.

Are you using the native drivers, or going through ODBC ?

Have you tried tracing the SQL generated by the PB application at runtime,
and checked the performance of that both in the PB database administrator as
well as in MS  Query Analyzer ?

To trace the SQL being generated by your PB app at runtime, add 'Trace '
before the DBMS name in the transaction object when you are connecting.

HTH

Sanjiv Das [TeamSybase]



"Geoff Langos" <geoffrey.p.langos@bellatlantic.com> wrote in message
news:ogpwsyGr$GA.271@forums.sybase.com...
> We recently converted our app from Powerbuilder 5.0 to PB 7.0 -- the app
in
> PB 7.0 definitely runs slower on the client PC's than it did in PB 5.0.
>
> Now we are migrating the database from MS SQL 6.5 to 7.0 SP2.  We
> successfully converted the databases in a testing environment, but now the
> app runs terribly slow!  I don't think it's a hardware issue -- the test
box
> is a Compaq 8500 quad Xeon 500 w/1GB Ram.  We experimented running the app
> as a PB 5.0 app against MS SQL 7.0 and the problem is the same.  When we
> execute SQL directly against the DB outside of PB, we see no performance
> issues.
>
> Is there some kind of issue between PB and MS SQL 7.0?
> Has anyone successfully converted to MS SQL 7.0 using a PB app?
>
> thanks,
> -- Geoff
> g1langos@gte.net or geoffrey.p.langos@bellatlantic.com
>
>
>
>

I have numerous PB 7 applications running against MSSQL7 SP2.  DB
performance is great, much better than MSSQL 6.5.  About the same as PB
6.5.1

    MSS is much faster than ODBC ( 3X in some cases, also block=n causes
very long hangs on the client waiting on data )

    OLE_DB is only about 20% slower than MSS but has issues with datetime
data type drops time portion and connection (if not using .udl file) takes
an extra 3 seconds.  Also differences in padding and trim of trailing
spaces.


"Sanjiv Das [TeamSybase]" <No-Spam-SDas@CompuServe.Com> wrote in message
news:5vwg15Kr$GA.271@forums.sybase.com...
> Geoff,
>
> I have several PB applications that run aganst a SQL Server 7 database,
and
> have not noticed any major performance issues.
>
> Are you using the native drivers, or going through ODBC ?
>
> Have you tried tracing the SQL generated by the PB application at runtime,
> and checked the performance of that both in the PB database administrator
as
> well as in MS  Query Analyzer ?
>
> To trace the SQL being generated by your PB app at runtime, add 'Trace '
> before the DBMS name in the transaction object when you are connecting.
>
> HTH
>
> Sanjiv Das [TeamSybase]
>
>
>
> "Geoff Langos" <geoffrey.p.langos@bellatlantic.com> wrote in message
> news:ogpwsyGr$GA.271@forums.sybase.com...
> > We recently converted our app from Powerbuilder 5.0 to PB 7.0 -- the app
> in
> > PB 7.0 definitely runs slower on the client PC's than it did in PB 5.0.
> >
> > Now we are migrating the database from MS SQL 6.5 to 7.0 SP2.  We
> > successfully converted the databases in a testing environment, but now
the
> > app runs terribly slow!  I don't think it's a hardware issue -- the test
> box
> > is a Compaq 8500 quad Xeon 500 w/1GB Ram.  We experimented running the
app
> > as a PB 5.0 app against MS SQL 7.0 and the problem is the same.  When we
> > execute SQL directly against the DB outside of PB, we see no performance
> > issues.
> >
> > Is there some kind of issue between PB and MS SQL 7.0?
> > Has anyone successfully converted to MS SQL 7.0 using a PB app?
> >
> > thanks,
> > -- Geoff
> > g1langos@gte.net or geoffrey.p.langos@bellatlantic.com
> >
> >
> >
> >
>
>

I am using SQLOLEDB to connect PB7 to MSSQL7.

When I tried to create SP based dw using sp in Northwind
and pubs. PB7 returned error msg(sth like syntax error).
But it is fine when I used the MSS drive to connect db.
Do you know how to fix this problem.
TIA
"Tyler Cruse" <tcruse@trlx.com> wrote in message
news:u6LMIjmr$GA.204@forums.sybase.com...
> I have numerous PB 7 applications running against MSSQL7 SP2.  DB
> performance is great, much better than MSSQL 6.5.  About the same as PB
> 6.5.1
>
>     MSS is much faster than ODBC ( 3X in some cases, also block=n causes
> very long hangs on the client waiting on data )
>
>     OLE_DB is only about 20% slower than MSS but has issues with datetime
> data type drops time portion and connection (if not using .udl file) takes
> an extra 3 seconds.  Also differences in padding and trim of trailing
> spaces.
>
>
> "Sanjiv Das [TeamSybase]" <No-Spam-SDas@CompuServe.Com> wrote in message
> news:5vwg15Kr$GA.271@forums.sybase.com...
> > Geoff,
> >
> > I have several PB applications that run aganst a SQL Server 7 database,
> and
> > have not noticed any major performance issues.
> >
> > Are you using the native drivers, or going through ODBC ?
> >
> > Have you tried tracing the SQL generated by the PB application at
runtime,
> > and checked the performance of that both in the PB database
administrator
> as
> > well as in MS  Query Analyzer ?
> >
> > To trace the SQL being generated by your PB app at runtime, add 'Trace '
> > before the DBMS name in the transaction object when you are connecting.
> >
> > HTH
> >
> > Sanjiv Das [TeamSybase]
> >
> >
> >
> > "Geoff Langos" <geoffrey.p.langos@bellatlantic.com> wrote in message
> > news:ogpwsyGr$GA.271@forums.sybase.com...
> > > We recently converted our app from Powerbuilder 5.0 to PB 7.0 -- the
app
> > in
> > > PB 7.0 definitely runs slower on the client PC's than it did in PB
5.0.
> > >
> > > Now we are migrating the database from MS SQL 6.5 to 7.0 SP2.  We
> > > successfully converted the databases in a testing environment, but now
> the
> > > app runs terribly slow!  I don't think it's a hardware issue -- the
test
> > box
> > > is a Compaq 8500 quad Xeon 500 w/1GB Ram.  We experimented running the
> app
> > > as a PB 5.0 app against MS SQL 7.0 and the problem is the same.  When
we
> > > execute SQL directly against the DB outside of PB, we see no
performance
> > > issues.
> > >
> > > Is there some kind of issue between PB and MS SQL 7.0?
> > > Has anyone successfully converted to MS SQL 7.0 using a PB app?
> > >
> > > thanks,
> > > -- Geoff
> > > g1langos@gte.net or geoffrey.p.langos@bellatlantic.com
> > >
> > >
> > >
> > >
> >
> >
>
>

Dear Geoff,

we have also migrating the database from MS SQL 6.5 to 7.0 SP2 with PB 6.5 and
nativ MSS60 Driver. Our application runs Very slow, too! In other words 2 times
slower!

Did you found a solution of this problem?


TIA
Michael Theis
UBITAS GmbH


Geoff Langos schrieb:

> We recently converted our app from Powerbuilder 5.0 to PB 7.0 -- the app in
> PB 7.0 definitely runs slower on the client PC's than it did in PB 5.0.
>
> Now we are migrating the database from MS SQL 6.5 to 7.0 SP2.  We
> successfully converted the databases in a testing environment, but now the
> app runs terribly slow!  I don't think it's a hardware issue -- the test box
> is a Compaq 8500 quad Xeon 500 w/1GB Ram.  We experimented running the app
> as a PB 5.0 app against MS SQL 7.0 and the problem is the same.  When we
> execute SQL directly against the DB outside of PB, we see no performance
> issues.
>
> Is there some kind of issue between PB and MS SQL 7.0?
> Has anyone successfully converted to MS SQL 7.0 using a PB app?
>
> thanks,
> -- Geoff
> g1langos@gte.net or geoffrey.p.langos@bellatlantic.com