-
1. Re: Performance issue with SQLServer
febbraro Mar 17, 2003 5:44 PM (in response to thl-mot)This depends on what driver you are using.
If using the M$ driver, they execute all statements via the stored prpocedure, but that is not the problem usually.
Problems happen when you have varchar fields but the driver wants to deal with all strings as unicode, which is why you see the N' before all of your strings.
The way to turn this off is to specify your ConnectionURL as such
jdbc:microsoft:sqlserver://servername:1433;DatabaseName=DBNAME;SelectMethod=cursor;sendStringParametersAsUnicode=false
I never tried the opposite though, making all of your fields nvarchar instead of varchar. That may work too.
I hope this helps... -
2. Re: Performance issue with SQLServer
thl-mot Mar 17, 2003 6:35 PM (in response to thl-mot)Yes thats it, I could reproduce it. As you can see in the attached screen shot.
Statement 1 was executed with the parameter
"sendStringParametersAsUnicode=false".
Statement 2 was executed without that parameter.