Re: BDL Performance on SQL Server

Maybe it is related to scroll cursors:

When using scroll cursors, the SQL Server driver creates an ODBC 
scroll cursor by using the SQL_ATTR_CURSOR_SCROLLABLE statement option.

On the SQL Server side, scroll cursors are probably implemented with 
an internal temporary table...

Just guessing, check the MSDN (search SQL_ATTR_CURSOR_SCROLLABLE).

Seb

Richard Turner wrote:
> Hi all,
> 
> We've been trying to tune a few 4GL applications so they can run
> effectively against a SQL Server database.  Certain programs seem to
> cause problems where they are generating thousands of extent locks on
> the tempdb database.  When the locks get high enough, the whole system
> seems to grind to a halt.  
> 
> I've been looking at areas in the code where temp tables are used but
> have not had success pinpointing the issue.  There are a few places
> where temp tables are being used in cursors so maybe this is related??
> Would indexes on my temp tables help decrease these extent locks?
> 
> Any ideas would be very appreciated.
> 
> Thanks,
> 
> 
> Richard
>