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 [EMAIL PROTECTED] http://savage.net.au/
