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 |
|
hog
Constraint Violating Yak Guru
284 Posts |
 Posted - 2007-11-05 : 18:54:35
|
| 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 queriesOption 2:A VB.NET application importing the data into a mdf file using sql server datasourceIs my thoughts that option 2 would be more efficient and less network hungry?Thanks for any advice on offer....Edit/Delete Message |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-11-05 : 18:56:21
|
| This is not something that can be answered without you testing it.It really doesn't matter what IDE you choose for your application though. It depends on how you design and code them.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2007-11-06 : 19:30:29
|
| I agree, the distance is irrelevant without testing. The server my analysts use is 30 miles away, and they connect to it via SAS, Access, excel..no issues. All kind of depends on how things are set up, how many users, frequency of needed updates to the client side.etc |
|
|
|
bogus
Starting Member
41 Posts |
Posted - 2007-11-08 : 19:17:45
|
| I would think the issue would be the amount of data as much as anything else. I mean, the queries you design will determine the speed of this, not the source code it's written in. |
|
|
|
hog
Constraint Violating Yak Guru
284 Posts |
Posted - 2008-02-01 : 07:42:47
|
| Hi, I guess my main problem was confusing SQL Server mdf files with that of Access.I connected to the mdf file on my hard disk within VB.NET and all was well. Until I copied the mdf file to a file server. DOH no can do.Plonker, it is not Access.I have no control or experience of a true SQL Server so was scuppered until I realised after much forum around the world asking that I could setup SQL Express on another PC in my office and use that.Hey presto it works :)I have set it up so only users in my local site can see it, no one elsewhere in the company off site can see it.Locally there will only be 5 if that light users and maybe 4-6 read only users so hopefully all will be well. |
|
|
|
|
|
|
|
|
sql server vs ms access