Solved

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

Posted on 2011-02-18
6
898 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
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
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 

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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

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!
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

863 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now