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.
Author |
Topic |
AskSQLTeam
Ask SQLTeam Question
0 Posts |
Posted - 2000-12-06 : 09:29:05
|
Zubi writes " First to confess I am new to SQL server. I have got two databases, A and B. A is an Access file and B is a SQL server database. I used ADO to connect to both and transfer data from Access mdb A to SQL server. It takes too much time in doing so. I used ADO Update and addnew methods to do so. I want to improve the performance of application. Can you guide me in this regard. also I want to know that what is typical time for an insert in SQL server on LAN (10/100 mbps) and WAN.
If I use client side cursors how many record will it fetch at a time from SQL server.
I hope you understood my position.
I am using SQL server 7, winNT 4 and Win 98 as client. Regards" |
|
|
|
|