Could a guru of networking and databases please help me with this problems please?
I need to know which of the following methods is better, ie less network pounding....
Situation:
A sql server database running on a host 25 miles away.
two maybe three queries need to be run to import very large data into a local c: drive database.
Option 1:
An MS Access database application with the required make table queries
Option 2:
A VB.NET application importing the data into a mdf file using sql server datasource
Is my thoughts that option 2 would be more efficient and less network hungry?
Thanks for any advice on offer....
Edit/Delete Message
I need to know which of the following methods is better, ie less network pounding....
Situation:
A sql server database running on a host 25 miles away.
two maybe three queries need to be run to import very large data into a local c: drive database.
Option 1:
An MS Access database application with the required make table queries
Option 2:
A VB.NET application importing the data into a mdf file using sql server datasource
Is my thoughts that option 2 would be more efficient and less network hungry?
Thanks for any advice on offer....
Edit/Delete Message