Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - DB Questions
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

DB Questions
 Post Reply Post Reply Page  123>
Author
  Topic Search Topic Search  Topic Options Topic Options
Amateur View Drop Down
Senior Member
Senior Member
Avatar

Joined: 22 July 2004
Location: Ireland
Status: Offline
Points: 210 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Amateur Quote  Post ReplyReply Direct Link To This Post Topic: DB Questions
    Posted: 17 July 2005 at 4:29pm
Hi all,

I need yer opinion on 4 different matters.

1--
I am currently creating some ASP.NET c# applications with a db back end. Anywhere on the internet where I could read about performace issues in connecting to a db, be it access or sql server?

2--
I am considering using MS Access for my apps. I am aware when a connection is opened to connect to the db, the db is loaded into memorary. I am wondering if each sql command applied to the opened connection is a performance hit or is it just the opening of the connection that the performace hit is with?
How would using SQL Server improve performance?

3--
If I decide to use SQL Server, is there anywhere in the internet that I could download a copy of it or something similar that I could use?

4--
Also, is it better to have a number of medium sized Access dbs or one large one? Its just easier to have the one db but performance is a big issue for me.

Any help would be great.
Back to Top
dfrancis View Drop Down
Senior Member
Senior Member


Joined: 16 March 2005
Location: United States
Status: Offline
Points: 442 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dfrancis Quote  Post ReplyReply Direct Link To This Post Posted: 17 July 2005 at 6:06pm
Just my opinion...
 
1 ) Don't use access
2) Don't use access
3) Microsoft website free download and $50 (US) for full version (developers)
4) Don't use access.
 
=============
I've developed with Access for years, I had to rewrite everything to upgrade to SQL. Access will cause more problems than it's worth on a production server. Well there is one exception... if you are going to have less that 8 people on your website at any given time, then okay.  LOL
 
http://http://www.ASP.NET  is the place for the good info.
 
RE: your db connection questions, http://www.aspfaq.com is priceless. (And he will validate my access opinion too.)
Back to Top
Amateur View Drop Down
Senior Member
Senior Member
Avatar

Joined: 22 July 2004
Location: Ireland
Status: Offline
Points: 210 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Amateur Quote  Post ReplyReply Direct Link To This Post Posted: 17 July 2005 at 6:27pm
Originally posted by dfrancis dfrancis wrote:

Just my opinion...
 
1 ) Don't use access
2) Don't use access
3) Microsoft website free download and $50 (US) for full version (developers)
4) Don't use access.
 
=============
I've developed with Access for years, I had to rewrite everything to upgrade to SQL. Access will cause more problems than it's worth on a production server. Well there is one exception... if you are going to have less that 8 people on your website at any given time, then okay.  LOL
 
http://http://www.ASP.NET  is the place for the good info.
 
RE: your db connection questions, http://www.aspfaq.com is priceless. (And he will validate my access opinion too.)
 
Couple questions.
 
I have finished one particular with access backend. Is there alot of work in recoding it for sql server?
 
Is there a big difference from using access to sql server in coding etc? I ask this as you have made the change. What did you find as the hardest change to make between the two? Do i need to create procedures etc?
 
I already downladed that copy of sql server from ms website, can i download it again or do i have to pay up??
 
Thanks very much for your help.
Back to Top
dpyers View Drop Down
Senior Member
Senior Member


Joined: 12 May 2003
Status: Offline
Points: 3937 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dpyers Quote  Post ReplyReply Direct Link To This Post Posted: 17 July 2005 at 7:43pm
Biggest issues I've had is converting data types for those fields that are different between access and mssql - one of the reasons I don'y use autonumber - lol. Access 2003 contains a pretty good upsizing wizard, and mssql can import and access db's - usually take a little tweaking.

Most of your sql will remain the same, but check out true/false statements. You don't have to use stored procedures but as "compiled" sql statements, they run a lot faster.

The MSSQL 2002 download is a 90 day trial. The developer edition is well worth toh $50 - seen it for < $30.

If your host is offering .net 2.0 beta test machines, you might want to check out http://msdn.microsoft.com/getthebetas/

Lead me not into temptation... I know the short cut, follow me.
Back to Top
Mart View Drop Down
Senior Member
Senior Member
Avatar

Joined: 30 November 2002
Status: Offline
Points: 2304 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Mart Quote  Post ReplyReply Direct Link To This Post Posted: 18 July 2005 at 6:46am
You might also want to use MSDE for developing locally - the only difference is that less concurrent users are allowed and your not allowed to use it for production. MSDE is free from microsoft, theres a tutorial about how to set it up here http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmsde/html/msderoadmap.asp
Back to Top
Mart View Drop Down
Senior Member
Senior Member
Avatar

Joined: 30 November 2002
Status: Offline
Points: 2304 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Mart Quote  Post ReplyReply Direct Link To This Post Posted: 18 July 2005 at 6:48am
There's an upsizing tutorial also http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/odc_msdeintro.a sp
Back to Top
dfrancis View Drop Down
Senior Member
Senior Member


Joined: 16 March 2005
Location: United States
Status: Offline
Points: 442 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dfrancis Quote  Post ReplyReply Direct Link To This Post Posted: 18 July 2005 at 7:14am
DP and Mart offer some great advice!
 
Bottom line to me is, since you are a self proclaimed novice, why not go directly to the technology that you will end up in anyway? What I mean is, I can see no reason to learn Access if you are eventually going to dive into SQL anyway.
 
You are at the right place to learn the difference. Bruce has coded the WWforum for both SQL and Access, a quick look at the code can really tell you some of the differences.
 
Can you download the trial version again? Not likely. There are a few registry entries you'd have to find and remove. But from the MS website, you can register your trial as a developer for $50usd.
 
DP offered a great suggestion. The upsizing wizard in access works great and it will reveal any table structure issues. (because some query's or inserts will stop working.)
 
Also, re: MSDE - I have gone down that road but when MS came out with the dev price for full SQL, I stopped "playing" with it. It is a viable option.
 
(SideNote: You said you were developing a DOT NET / C# application. A great place to look is http://lab.msdn.microsoft.com/express/vwd/ because it will install a free version of SQL express. (grin) --- Caveat! The ASP.NET v2 is still in beta and most hosting companies won't support it. I've installed it locally, but won't even think of using v2 until it's been out for 6+ months. That gives the dev community enough time to poke holes in the release and find all the security and other bugs.)
 
Like DP said... true/false (Yes/No) is a big issue as are dates. I've had to wrestle with a few null issues in conversions as well.
 
If it were me... if the access backend is working for you then use it. Try the upsizing wizard in a development environment and then use it as an object lesson. While you're fixing the SQL statements and fields, you should also consider investing time into stored procedures. The whole process of upsizing is a great way of learning the difference. (Well, I'm speaking from experience with Access 2000, I have no idea about 2003... sorry.)
 
 
Back to Top
Mart View Drop Down
Senior Member
Senior Member
Avatar

Joined: 30 November 2002
Status: Offline
Points: 2304 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Mart Quote  Post ReplyReply Direct Link To This Post Posted: 18 July 2005 at 7:32am
But if you do want to go down the Beta 2 route, here is a list of hosters that support it: http://msdn.microsoft.com/asp.net/beta2/hosters/default.aspx

Some of those hosters offer free playground accounts to test asp.net 2.0 out on
Back to Top
 Post Reply Post Reply Page  123>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.