Database : SQL Server Take more time to insert data

[Amit Dhaduk]

Hi All,

I am developing an application on the base of SQL
Server for BackUp/Resotre for personal database.

This utility will take back up between

1. .MDB ---> .MDB (On Same PC)
2. .MDB---> SQL Server (On Network)
3. .MDB---> .MDB(On Network)

While I am taking backup for about 120 records the time
is as below

case one :: 50 Seconds (.MDB ---> .MDB)
case TWO :: 250 Seconds(.MDB---> SQL Server (On Network))

For all cases query will remain same ..
Why Backup on SQL Server taking huge time??

Question 2:::
At Present I am using Addnew function for adding new
record.. If I will used "Insert Into" Query rather than
Addnew function then it will take less time????

Question 3:::
Any idea for improving speed on (network /SQL Server)..

Plz correct me regarding all these issues
...

Thanks in Advance.

regards,
Vipul & Amit

[Russ Gray [MS]]

Hi Guys

All other things being equal, Access is faster than SQLServer. This is
because Access works entirely in RAM, which is as fast as you can get.
That's probably the difference that you're seeing.

There are a lot of ways to do these things faster in SQLServer, BCP, DTS,
batching the statements, etc, but it's hard to know what might work best
for you in your particlar situation. You might look into BCP tho.

Thanks,

Russ Gray
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.