Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Read_only VS Fast_forward

Author  Topic 

cat_jesus
Aged Yak Warrior

547 Posts

Posted - 2001-08-29 : 16:13:36
Do any of you ave any experience with the fast_forward extended argument for declaring cursors? My client will not allow me to attempt removing the curses but I must bring this runtime down from 5+ hours. All the defined cursors are read only and only fetch next. Can I expect any performance gain at all by specifying fast_forward. I know BOL says it will, but I'd like to hear from someone before I commit to ten plus hours of testing.

Thanks.
Cat

   

- Advertisement -