Which is faster? ADO or SP?

[Alibaba2003]

In MS-Access Project. Which one is faster?
Using the add method:
r0.Add
r0!field1= 'blah'
:
:
:
r0!fieldn= 'blue'
r0!update

or calling a stored procedure that is built in SQL Server
that is doing the same thing. Given that mutliples insertions are done for different tables for lots of records. Thanks

Alibaba


It's Nice to Be Important But It's more Important to BE Nice

 

[alvechurchdata]

Which one is faster?

Much depends on the client and server hardware and the network. You might run comparisons on your development system and find different answers on the users' system.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[markgrizzle]

I'd imagine th stored procedure's faster, since only the text is travelling over the network, and the code's running on the server.

Contrast that with Access looping all the records in, at the client's speed.

Testing is best though. You should also (if possible) have a system that's similar to what your users are running on, so you can get an idea of what they're experiencing.