Should I use ODBC cursors or Server cursors? 
Author Message
 Should I use ODBC cursors or Server cursors?

I'm looking for input regarding the ODBC cursor library, and if it is
something I should consider using instead of native SQLServer cursors.
Does performance suffer?  What native features do I lose (transactions,
etc.)?

The reason I am considering the cursor library is that I can't create an
MFC
CRecordset on the following stored procedure unless I use the cursor
library:

insert into someTable values(1, 2, 3)

--
Note:  Remove the .NOSPAM from my email address to reply!



Sun, 17 Oct 1999 03:00:00 GMT
 Should I use ODBC cursors or Server cursors?

I am not sure of the difference in performance, but I have found that you
cannot execute a stored procedure which does just about anything if you
use server cursors (any select other than the final one causes problems).
Of course, I have found that non-server cursors do not allow a cursor in
your stored procedure (for temporary manipulation of data)!  

These days, I usually use temp tables to hold the results of any
complicated procedure.  This allows the results to be fetched sequentially
only however as
using EXECUTE("") requires the temp name to be built using SELECT causing
server side cursors to fail.  The solution here is to have _another_ stored
procedure
select a subset of the results as needed.

Greg



Quote:
> I'm looking for input regarding the ODBC cursor library, and if it is
> something I should consider using instead of native SQLServer cursors.
> Does performance suffer?  What native features do I lose (transactions,
> etc.)?

> The reason I am considering the cursor library is that I can't create an
> MFC
> CRecordset on the following stored procedure unless I use the cursor
> library:

> insert into someTable values(1, 2, 3)

> --
> Note:  Remove the .NOSPAM from my email address to reply!



Tue, 19 Oct 1999 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Cursor Cursor Cursor

2. client side cursor vs. server side cursor

3. SQL Server Cursors vs. Oracle Cursors

4. Different error for client cursor and server cursor

5. SQL Server Cursors va Oracle Cursors

6. Client Side Cursors vs Server Side Cursors

7. Please explain server side cursor vs client side cursor and CacheSize=1

8. Server Side Cursor - ClientBatch Cursor

9. Unix forked server-process doesn't free all cursor-resources?(No free Cursors left)

10. Disabling server-side cursors with ODBC and SQL server 6.x


 
Powered by phpBB® Forum Software