LearnItFirst User Forum

Welcome Guest

Search | New Posts | Members | Log In | Register

SQL Server Forum - LearnItFirst.com » SQL Server Database Administration » General SQL Database Question & Answer » Going from Access to SQL?

Going from Access to SQL?

Options

Previous Topic · Next Topic

MiniRamen

Posted: Monday, July 05, 2010 8:16:58 AM

Rank: Newbie

Joined: 7/5/2010
Posts: 1
Points: 3
Where do you live?: Montreal

Hello, I realized that I have to query 17 million of data on Access and I seriously think it gets too slow and it's complicated to obtain specific information without waiting a looong time.

So if I use install a SQL Server, how much faster would it be? I mean...I really lack the expertise on that level but I'm willing to try in order to get things done faster.

Thanks for reading Smile

Scott Whigham

Posted: Monday, July 05, 2010 8:54:30 AM

Rank: Super Mod

Joined: 3/20/2006
Posts: 476
Points: 1,053
Where do you live?: Dallas, TX

"How much faster" is dependent on many factors:

1) Will there be an upgrade in hardware as well? There usually is: most of the time, you move from someone's desktop computer hosting a shared Access file to a full-blown server for SQL Server.

2) Will the database design be revisited to ensure that it is fully normalized to 3rd normal form? If it already is in 3NF, then skip this step.

3) Will indexes be revisited to ensure coverage?

I'd assume you can get anywhere from worst performance to 10x faster on the same hardware - it just depends on many factors. One nice thing about SQL Server is that, once you port it to SQL Server, you can take advantage of things like the Database Engine Tuning Advisor and SQL Profiler to help you understand where the bottlenecks/problems are and how to fix them.

If you want the, "Don't make me think!" answer, then yes: it will be faster.

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.