Re: [Hibernate] MS SQL performance and Unicode

2003-08-26 Thread Gary Evesson
Serge Knystautas wrote: Eric Pugh wrote: No, I can chime in, that I as well didn't know this. Out of curiosity, has anyone put together a unit test that I could run to demo the differences? Would this be something to add to hibernate, or is it too random? What kind of difference are you look

Re: [Hibernate] MS SQL performance and Unicode

2003-08-26 Thread Gary Evesson
Eric Pugh wrote: Also, I am working on this little issue, and I wanted to verify that the sendStringParametersAsUnicode=false string goes into the URL that you use to connect to the database, correct? jdbc:microsoft:sqlserver://[server]:1433;DatabaseName=[database name;SelectMethod=cursor;sendStri

RE: [Hibernate] MS SQL performance and Unicode

2003-08-25 Thread Eric Pugh
[mailto:[EMAIL PROTECTED] Behalf Of Serge > Knystautas > Sent: Sunday, August 24, 2003 4:48 AM > To: Hibernat-Dev > Subject: Re: [Hibernate] MS SQL performance and Unicode > > > Gary Evesson wrote: > > Am I the only person in the world who didn't know what > happens

Re: [Hibernate] MS SQL performance and Unicode

2003-08-25 Thread Serge Knystautas
Patrick Burleson wrote: Even more fun info here, is that if your JDBC driver (like say the DataDirect driver) uses NVARCHAR parameters with maximum widths (4000), SQL Server 7.0 will take forever to give you results. In our case, from 1 second using a VARCHAR (or even a shorter NVARCHAR) to 18 seco

Re: [Hibernate] MS SQL performance and Unicode

2003-08-25 Thread Patrick Burleson
Even more fun info here, is that if your JDBC driver (like say the DataDirect driver) uses NVARCHAR parameters with maximum widths (4000), SQL Server 7.0 will take forever to give you results. In our case, from 1 second using a VARCHAR (or even a shorter NVARCHAR) to 18 seconds. This problem doe

Re: [Hibernate] MS SQL performance and Unicode

2003-08-24 Thread Serge Knystautas
Eric Pugh wrote: No, I can chime in, that I as well didn't know this. Out of curiosity, has anyone put together a unit test that I could run to demo the differences? Would this be something to add to hibernate, or is it too random? What kind of difference are you looking to demonstrate? I don't t

RE: [Hibernate] MS SQL performance and Unicode

2003-08-24 Thread Eric Pugh
;sendStringParametersAsUnicode=false Eric > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Serge > Knystautas > Sent: Sunday, August 24, 2003 4:48 AM > To: Hibernat-Dev > Subject: Re: [Hibernate] MS SQL performance and Unicode > > > Gary Evesson w

Re: [Hibernate] MS SQL performance and Unicode

2003-08-24 Thread Serge Knystautas
Gary Evesson wrote: Am I the only person in the world who didn't know what happens if you use VARCHAR's with Java and the MS SQL JDBC driver? It seems unlikely because I can find no mention of this in the list archives or the like. It's not just the MS SQL JDBC Driver... we use the Inet Software

Re: [Hibernate] MS SQL performance and Unicode

2003-08-20 Thread Christian Bauer
On 20 Aug (09:08), Gary Evesson wrote: > Am I the only person in the world who didn't know what happens if you > use VARCHAR's with Java and the MS SQL JDBC driver? It seems unlikely > because I can find no mention of this in the list archives or the like. I've added this to the community area

[Hibernate] MS SQL performance and Unicode

2003-08-20 Thread Gary Evesson
Am I the only person in the world who didn't know what happens if you use VARCHAR's with Java and the MS SQL JDBC driver? It seems unlikely because I can find no mention of this in the list archives or the like. If you use VARCHARs for database tables and index those columns either (as a primar