Re: VB App fails when log reaches 65536

Tech-Archive recommends: Fix windows errors by optimizing your registry

=?Utf-8?B?Q3Jvd25NYW4=?= <CrownMan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
news:6C27011E-86F3-461E-BA12-90908DBD327B@xxxxxxxxxxxxx:

see, the SQL Server where we are trying to query against contains over
5 million records, but it is 7 years old...a pentium class old server
that does not perform very well. So...the app creates client side
cursors, goes on to do a lot of processing and finally, it begins to
spit out records and writes to the log. Well, it takes like 20
minutes to process the query...and when it finally does....it quits
at that number...

Are you sure it's creating a client-side cursor ?

I haven't done a database app in a while, but IIRC, when a client-side
cursor is used, the db server does nothing except hand off the entire db to
the client program and then the client app generates the query locally.

That means that if the query resultant set is let's say 10,000 records, the
client still gets handed all 5 million records over the network, which
could be a problem with a slow connection.

To the contrary, with a server-side cursor, the SQLServer will run the
query and hand over only the 10,000 records to the client.

Maybe it's time to spend $200 to update the SQL server's MB,CPU and RAM.
You can get a motherboard, near 3Ghz dual core AMD CPU, and 2 Gigs of RAM
for that much moolah.
.

Relevant Pages

  • RE: Using kerberosSecurity Throws Security Exception
    ... I am experiencing this error while trying to use a Windows XP client ... application to access a web service located on a W2k3 server. ... client app on the server, ... > Account with a Custom Principal Name using SetSPN.exe utility. ...
    (microsoft.public.dotnet.framework.webservices.enhancements)
  • Re: Questions about Remoting, objects, threading. lease lifetime and object cleanup, and a couple of
    ... so long as the Client app is ... always refering to the same server object. ... it sets its ClassOne object to nothing and goes away. ... >>The client app at some point is going to become an ASP.Net app also. ...
    (microsoft.public.dotnet.framework.remoting)
  • Re: Remoting or windows service
    ... Thanks for writing up such a decent overview of the remoting dev process ... the client and the server. ... > 2) Implement this class in the server app and say that it can be accessed ...
    (microsoft.public.dotnet.framework.remoting)
  • Re: Schannel and Session Renegotiation
    ... Schannel does not support the server sending app ... We are discussing the option of providing support for the client blowing off ...
    (microsoft.public.platformsdk.security)
  • Re: Getting Events, for Windows Service
    ... else tries to run my client app he gets an timeout error. ... The server application has a public object called logger, ... So it seems that the logger is properly instantiated and works. ...
    (microsoft.public.dotnet.framework.remoting)