Re:ODBC and Large Results?

djm@primenet.com (Dan Marshall) writes: > How does ODBC handle large result sets? For example, if an SQL query on > a server requires a large answer set to be materialized (e.g., a sort > required), where is the "set" housed while the app is FETCHing? Depends on the driver. If you use MS SQL Server 6 this kind of data will be kept on the server as true client / server tech (if wanted). If the server and the server driver doesn't support this, all data will be transported to the client and stored in local memory. It works but will require a large swapfile though ... // JTN <jtn@jd.se> --- * Thomas Nimstad * #pragma message("Standard disclaimer in use") * Juristdata AB, SWEDEN * Professional development for Win32 * Phone +46-500-412150 * Fax +46-500-412848 * CompuServe 72670,125