Powerbuilder application with MS SQL Server DB performance
Nasir
I am using PowerBuilder 7 and MS SQL Server 2000, Oracle 9i
as back end.
I have comlaints from my clients who are using MS SQL
Server that application hangs or slow down when other user
gets reports.
Any help in this regard will be apprieciated.
Have a nice day!
thanks
Nasir
Bruce Armstrong [TeamSybase]
doesn't place shared lock on queries by default, so it's not quite as
susceptible. You might look at the Lock attribute for the connection
and/or issuing commits after your retrieves to clear the locks.
Bruce Armstrong [TeamSybase]
http://www.teamsybase.com
Two new books on developing with PowerBuilder
http://www.pb9books.com?source=newsgroups
Need code sample? Check out CodeXchange:
http://www.codexchange.sybase.com
ISUG Enhancement Requests
http://www.isug.com/cgi-bin/ISUG2/submit_enhancement
Preach the gospel at all times. If necessary, use words. - Francis of Assisi
http://www.needhim.org
stevekatz
set to FALSE, then for MSS your selects are executed within
a transaction, which may be causing shared read locks. You
may want to opt to set AC = TRUE and just change to FALSE to
begin a transaction when you need one, then set back to TRUE
after issuing your commit/rollback.
I believe the AC setting does not affect Oracle connections
at all, but I'm not 100% sure.
BTW, you should have your (their?) DBA's monitor the
database to see what sort of locks are generated at the time
the users are running their reports. It could be that row
locks are being promoted to page locks and then to table
locks depending upon how many rows are being accessed in the
tables during the report generation. That will definitely
put a damper on things.
steve
[TeamSybase]
Bruce Armstrong [TeamSybase]
>I believe the AC setting does not affect Oracle connections
>at all, but I'm not 100% sure.
That is correct. Oracle says "AutoCommit? I don't need no stinking
AutoCommit!" <grin>
Bruce Armstrong [TeamSybase]
http://www.teamsybase.com
Two new books on developing with PowerBuilder
http://www.pb9books.com?source=newsgroups
Need code sample? Check out CodeXchange:
http://www.codexchange.sybase.com
ISUG Enhancement Requests
http://www.isug.com/cgi-bin/ISUG2/submit_enhancement
Preach the gospel at all times. If necessary, use words. - Francis of Assisi
http://www.needhim.org
---------------------------------------------------------------------
DISCLAIMER:
This newsgroup message is only intended for the recipient. Given that it
is a posting to a public newsgroup, that means if you can read this
message then you are the recipient. This message may contain information
that is confidential and protected from disclosure. And then again,
it may not.
Given that TeamSybase members are not employees of Sybase, the contents
of this message do not necessarily represent the views or policies of
Sybase. Given that TeamSybase is a diverse group of users of Sybase
products, the contents of this message do not necessarily represent the
views of a significant number of the members of TeamSybase. Given that the
author has mutliple personalities and hears voices in his head, the contents
of this message do not necessarily represent his own views.
JMR
my problem.
hth,
JMR