by Chri » Wed, 31 May 2000 04:00:00
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
by George Poulos » Wed, 31 May 2000 04:00:00
Query Tool (using ADO) from:
http://gpoulose.home.att.net/
George
> 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
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