Q: Speed Up Recordet Fetch Ado+SqlSrv

Q: Speed Up Recordet Fetch Ado+SqlSrv

Post by Chri » Wed, 31 May 2000 04:00:00



Basically anyone know hot to speed up fetching data...

set rstemp = dataenvironment1.connection1.execute("StoredProc")
Takes A While On Larger Sets.....
In The Stored Procedure I HAve A Select Stmt Using
WITH(INDEX(ThisIndex),NOLOCK)

But I Find IT Takes A Bit For 5 Cols Numeric/Char(100) About 300 Rows

Server Runs On A Dual p3-500 w/1gb Ram Raid 5 10k

Thanks

 
 
 

Q: Speed Up Recordet Fetch Ado+SqlSrv

Post by George Poulos » Wed, 31 May 2000 04:00:00


Check out:

Query Tool (using ADO) from:

http://gpoulose.home.att.net/

George


> Basically anyone know hot to speed up fetching data...

> set rstemp = dataenvironment1.connection1.execute("StoredProc")
> Takes A While On Larger Sets.....
> In The Stored Procedure I HAve A Select Stmt Using
> WITH(INDEX(ThisIndex),NOLOCK)

> But I Find IT Takes A Bit For 5 Cols Numeric/Char(100) About 300 Rows

> Server Runs On A Dual p3-500 w/1gb Ram Raid 5 10k

> Thanks


 
 
 

1. Q: Speed Up Recordet Fetch Ado+SqlSrv

Basically anyone know hot to speed up fetching data...

set rstemp = dataenvironment1.connection1.execute("StoredProc")
Takes A While On Larger Sets.....
In The Stored Procedure I HAve A Select Stmt Using
WITH(INDEX(ThisIndex),NOLOCK)

But I Find IT Takes A Bit For 5 Cols Numeric/Char(100) About 300 Rows

Server Runs On A Dual p3-500 w/1gb Ram Raid 5 10k

Thanks

2. Red Brick Announces Arbor and other OLAP Partnerships

3. NT speeds-ups?

4. FORCE UK Distribution

5. ADO Recordet ODBC/OLEDB error

6. Stored procedures: Sybase vs OMNI

7. ADO 2.1 Disconnected Recordet

8. advice on software to learn on

9. ADO and SQLSrv: Recordset scrollable

10. ADO & SQLsrv: Recordset scrollable

11. ADO - 2 Qs

12. Speed, speed, speed, and Sybase disk limitations

13. Speed, speed, speed...