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 |
|
1fred
Posting Yak Master
158 Posts |
 Posted - 2002-07-22 : 14:24:19
|
| I have an application design in VB that scans the hard Drive of my file server and retrieve the information of each file to store them in my mssql server. I'd like to know where is the best place to run this application. On my sql server to maximize my access to the DB or on my file server to maximize the access to the file.BTW it will runs at night so there should be no traffic on the network and almost nothing on the server.Thanks |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2002-07-22 : 16:21:39
|
| I would think the file server. Methinks the SQL connection is faster than the Windows File stuff.I bet it's going to be nearly as fast either way.Michael<Yoda>Use the Search page you must. Find the answer you will. |
 |
|
|
|
|
|
Where to execute