Re: Efficient scanning of SQL Server 2005 tables?

Amos Shapira wrote:

Hi Amos

Our local SQL Server/Windows/C++ guru told me that the standard way we scan
tables causes the server to practically copy the entire result set into a
temporary table on the server before feeding it to the client.

I assume MS are so cynical they do this to deliberately slow down the process.

He found a way to avoid this in C++ by some clever direct ODBC hacks on
Windows which make the server practically stream the results to the client
without creating a temporary table.

Is there a way to achieve this with Perl on Linux too?

Well, if you can publish his code here it should be convertible in Perl (perhaps with a C++ component). But if the code remain secret, I can't see how it can be replicated without being independently created.

--
Ron Savage
ron@xxxxxxxxxxxxx
http://savage.net.au/
.

Relevant Pages

  • Re: What doesnt lend itself to OO?
    ... >> proxy and instructs the server to constuct the real object. ... rather than client code. ... If 'clock' is instantiated in the server, ... > for the server interface at the OOA level. ...
    (comp.object)
  • This is going straight to the pool room
    ... or not the client has privilege to do what they're trying to do, ... The server environment is this: ... 3GL User action Routines that Tier3 will execute on your behalf during the ... Routine Name: USER_INIT ...
    (comp.os.vms)
  • [Full-Disclosure] R: Full-Disclosure Digest, Vol 3, Issue 42
    ... Full-Disclosure Digest, Vol 3, Issue 42 ... SD Server 4.0.70 Directory Traversal Bug ... Arkeia Network Backup Client Remote Access ...
    (Full-Disclosure)
  • Re: What doesnt lend itself to OO?
    ... > rather than client code. ... no way to do that without also touching the object with clock semantics ... will not encapsulate both clock semantics and network semantics. ... The server can do whatever it wants ...
    (comp.object)
  • Re: Formatting ASCII to be read by Windows NotePad
    ... No need to shout - neither Perl nor Cisco are acronyms. ... I've had issues in the past uploading to a MacOS based ftp server ... I've been using a Mac for ten years, ... different ftp clients, including the command line ftp client, so I ...
    (comp.lang.perl.misc)