Solved

Which database is fast sql server or Ms Access for my C#.net window application ??

Posted on 2011-02-18
6
904 Views
Last Modified: 2012-05-11
i want to know that which database is fast for accessing data for my window application ??
SQL server or Ms Access

give me some suggetions ...

Regards,
Parth
0
Comment
Question by:Parth48
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 37

Expert Comment

by:Neil Russell
ID: 34931670
If your talking about a networked, production application then put access away and forget about it. USE MSSQL
0
 
LVL 13

Accepted Solution

by:
lee555J5 earned 500 total points
ID: 34931698
Access is great for single users or small groups on a LAN where you can store the .mdb or .accdb file on a network share. A step up in performance is SQLite or MS SQL Server Compact Edition, both of which are single files on a network share - easy to administer. The next step up is MS SQL Server Express, but now you need a Windows Server to host it. Finally, as Neilsr has suggested, if you are running a networked, production application with more than 5-10 users, you need to go all the way to MS SQL Server, Oracle, MySQL, etc.

Lee
0
 
LVL 8

Expert Comment

by:jimsweb
ID: 34931699
0
Is Your DevOps Pipeline Leaking?

Is your CI/CD pipeline a hodge-podge of randomly connected tools? You’ve likely got a tool to fix one problem & then a different tool to fix another, resulting in a cluster of tools with overlapping functionality. Learn how to optimize your pipeline with Gartner's recommendations

 

Expert Comment

by:AshiqShaikh
ID: 34931707
SQL Server, even .NET studio provides SQL Server database file for attach by default
0
 
LVL 14

Expert Comment

by:quizwedge
ID: 34931712
I agree with Neilsr. Only reason to use Access would be if you were running something small on one computer and didn't want to mess with installing SQL Server.

Give Neilsr the points, but figured I'd add some additional info to the answer.
0
 
LVL 37

Expert Comment

by:Neil Russell
ID: 34931957
??
0

Featured Post

Is Your Team Achieving Their Full Potential?

74% of employees feel they are not achieving their full potential. With Linux Academy, not only will you strengthen your team's core competencies but also their knowledge of of the newest IT topics.

With new material every week, we'll make sure that you stay ahead of the game.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question