Re: why excute query through JDBC much slow than query analyzer?

From: Frank Brouwer (frank.brouwer_nospam_at_trimergo.nl)
Date: 11/19/04

  • Next message: Andrew: "Re: why excute query through JDBC much slow than query analyzer?" 
    Date: Sat, 20 Nov 2004 00:48:54 +0100

    If you use that be aware of the fact that language specific characters (like
    the Euro sign) are not stored in the database because they are unicode.
    Either do not use language specific characters or use nvarchar for your
    strings (ntext).

    Regards,

    Frank.

    "Pete Loveall" <psl@ametx.com.NO_SPAM> wrote in message
    news:eYCEgTnxEHA.3908@TK2MSFTNGP12.phx.gbl...
    > Set SendStringParametersAsUnicode=false This defaults to true which
    causes
    > searches to be done as N'text on non-unicode keys. This can cause massive
    > slow downs in execution.
    >
    > Pete Loveall
    > AME Corp.
    >
    > "Andrew" <Andrew@discussions.microsoft.com> wrote in message
    > news:C14CE83B-A2A2-4DEB-9E03-00F9893458C8@microsoft.com...
    > >
    > > I run a query through JDBC driver, it takes me about 60 seconds. But I
    > > simpy
    > > cut/paste the query to the query analyzer (on the same machine), I got
    > > less
    > > than 1 second. Why got so big difference?
    >
    >

  • Next message: Andrew: "Re: why excute query through JDBC much slow than query analyzer?"

    Relevant Pages

    • =?windows-1252?Q?Encrypting_Unicode_=96_Using_ASCII_as_a_Surrogate_Al?= =?windows-1252?Q?pha
      ... characters of an exotic eastern language using an ASCII keyboard. ... It is true to say that any keyboard of any language can be simulated ... communicate in large volume with China or Japan using CJK from Unicode ... by the computer as an external file and enciphered by a stream cipher ...
      (sci.crypt)
    • RE: VBA question: How to extract cell values in different language
      ... language is entered, but it seems like all that data is lost when the VBA ... about having binary data and not unicode data confirms my suspicions. ... You are have 256 binary characters. ... First column has the string IDs ...
      (microsoft.public.excel.programming)
    • Re: DB2 UTF-8 ODBC double conversion
      ... Unicode considers the various UTFs flavors completely equivalent. ... Just various encoding forms for the same thing. ... this means that everyone who is using that database has ... they can't use your database to represent as many characters as ...
      (microsoft.public.vc.mfc)
    • Re: Help! Unicode data types in OLAP databases
      ... The database is correctly showing the characters but as ... soon I browse say the dimension in the OLAP database, ... >SSAS is natively Unicode there is nothing special you ...
      (microsoft.public.sqlserver.olap)
    • Re: font/unicode question
      ... Do you have the Japanese language installed? ... Do you have the Japanese keyboard layout or Input Method Editor ... characters or spelling checkers designed for different languages. ... They appear to be solely Unicode. ...
      (microsoft.public.windowsxp.general)
    Loading