TDS and character encoding - Framework and Interface Programming
This is a discussion on TDS and character encoding - Framework and Interface Programming ; On Thu, 27 Sep 2007 08:54:30 -0700, bzh_29 <xiii29@free.Fr> wrote:
>I've exactly the same trouble ... My apps is responding fine on a LAN
>but when I goes on a WAN, getting horrible !
>
>>From 5 sec to 7 ...
-
Re: TDS and character encoding
On Thu, 27 Sep 2007 08:54:30 -0700, bzh_29 <xiii29@free.Fr> wrote:
>I've exactly the same trouble ... My apps is responding fine on a LAN
>but when I goes on a WAN, getting horrible !
>
>>From 5 sec to 7 min ... When I look SQL Time is the same so I look
>network usage with network ****yser and find the same result a you !
Just to make sure one basic point is covered, do all the stored
procedures have SET NOCOUNT ON right at the beginning? Leaving that
out can magnify network issues.
Roy Harvey
Beacon Falls, CT
-
Re: TDS and character encoding
On Thu, 27 Sep 2007 08:54:30 -0700, bzh_29 <xiii29@free.Fr> wrote:
>I've exactly the same trouble ... My apps is responding fine on a LAN
>but when I goes on a WAN, getting horrible !
>
>>From 5 sec to 7 min ... When I look SQL Time is the same so I look
>network usage with network ****yser and find the same result a you !
Just to make sure one basic point is covered, do all the stored
procedures have SET NOCOUNT ON right at the beginning? Leaving that
out can magnify network issues.
Roy Harvey
Beacon Falls, CT
-
I don't know your business, but even if you are not aiming at the Far Eastern market,
I don't know your business, but even if you are not aiming at the Far
Eastern market, you may expand into Poland or Hungary one day. That's
enough reason to use Unicode.
Developing for Unicode from the start is cheap. Changing to Unicode after
the fact is expensive.
And if you use varchar in your application, what is really your problem?
The only Unicode you need to send is the name of the stored procedures you
call? Or are you sending query batches from the application? Now, if you
do that, there are some bytes you can save by using stored procedures
instead.
Similar Threads
-
By Application Development in forum ADO DAO RDO RDS
Replies: 0
Last Post: 08-30-2007, 09:26 AM
-
By Application Development in forum C
Replies: 2
Last Post: 12-15-2006, 05:58 PM
-
By Application Development in forum XML SOAP
Replies: 1
Last Post: 09-13-2006, 01:37 AM
-
By Application Development in forum XML SOAP
Replies: 1
Last Post: 09-23-2004, 02:53 AM
-
By Application Development in forum Java
Replies: 0
Last Post: 12-01-2003, 08:39 PM