December 25, 2009 at 3:47 pm
Hi all
I am develop an application with vb6 that work with sql2005 express.
when the application work with the sqlExp ,I get bad performance.
when i open the studio-Exp2005 and open new query page, and work with the application
i have good performance
any idea??
jaco
Jaco.R
December 26, 2009 at 4:43 am
I would suspect your connection isolation level to be more intrusive than the one SSMSexp uses (read committed).
What isolation level are you using ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
December 26, 2009 at 6:51 am
hi
this is my connection string
connSTR="Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=MYDB;Data Source=zibra1\SQLDB;user=xx;pasword=yy"
Jaco.R
December 26, 2009 at 9:01 am
yacov-1006505
Please check the database properties, using SSMS, and see if the Auto Close open is set to "YES" or "No".
Do you measure performance in SSMS when you click the Execute command, and measure that against when your VB6 application has a command button clicked? Remember when using SSMS you have opened a connection to the server/db, and if your Auto Close option is set to "Yes" than your VB 6 application has to open the connection as well as execute the procedure and that alone could account for the difference in performance that you are reporting.
December 27, 2009 at 4:28 am
hi
Auto close is ture.
when i work with the vb6 application and ssms-->new query on the db
is open ,with out any commant in the query page. just open th query page.
the vb6 application work very well.
when i closed the query page
then the vb6 application works very slow .
at 5 times slower.
this is the syptoms of the problem
i did not know what the connection between the ssms and the performance of the application
best regards and thank you
jaco
Jaco.R
December 28, 2009 at 12:34 pm
thenk you
the problem was true
i chenged to false and the problem was solved
Jaco.R
December 28, 2009 at 3:23 pm
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply