Re: rdo performance with sql 2000
- From: "William \(Bill\) Vaughn" <billvaRemoveThis@xxxxxxxxxx>
- Date: Fri, 27 May 2005 09:03:12 -0700
I suspect that the SQL Server you're executing against does not have the
same indexes as the server with better performance.
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
<MThomas@xxxxxxxxxxxxxx> wrote in message
news:1117206938.659977.285290@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hello!
I am looking into an issue with a stand alone VB6 application and would
really appreciate some help. At some of our sites the application runs
with SQL Server 6.5 as the back end and all is well. Other sites,
however, have upgraded to SQL Server 2000 (and the stored procs has
been modified to accomodate this).
There is one stored proc that is executed from the VB application and
runs painfully slow with the 2000 back-end. If you run the same proc in
query analyzer it is really fast, but from the app it slows to a crawl.
This only happens with the 2000 back-end, not 6.5. No data is
returned, the proc is simply executed. There are no cursors or
anything funky in the proc, it just selects, updates, and deletes from
a bunch of tables. Does anyone have any theories about what in the
application could be causing this? Heres a code snippett (... referrs
to code omitted):
IN A MODULE:
-------------
Public fClient As rdoEnvironment
Public fConnection as New rdoConnection
Public Function basLoginSQL(...params...) as Boolean
...
Set fClient = rdoEngine.rdoCreateEnvironment(sEnvName, _
GenericUID, _
GenericPWD)
fClient .LoginTimeout = 0
fClient.CursorDriver = rdUseIfNeeded
Set fConnection= greFharm.OpenConnection(FharmDSN, _
rdDriverNoPrompt, _
False)
...
End Function
IN THE FORM:
-------------
Private Sub Delete()
...
SQL = "DELETE_Stored_Procedure " & _
Param1 & ", " & _
Param2
fConnection.Execute SQL, rdExecDirect
...
End Sub
Thank you in advance for your help!
Michelle
.
- References:
- rdo performance with sql 2000
- From: MThomas
- rdo performance with sql 2000
- Prev by Date: rdo performance with sql 2000
- Next by Date: Does stored procedure exist
- Previous by thread: rdo performance with sql 2000
- Next by thread: Does stored procedure exist
- Index(es):
Relevant Pages
|
