|
|
|
Forum Newbie
Group: Forum Members
Last Login: 3/5/2004 9:39:00 AM
Posts: 1,
Visits: 1
|
|
I am sill setting up my site and have read about the limits for an Access database compared to a SQL database. I know enough about MS Access & ASP to get by, but I have no real experience with SQL and how it uses and or sets up databases. I do have the software "MS SQL Server 2000" I guess I could do some reading and get it setup as a Client, right? I can only estimate the site hits and use of the database. I just want to make the 1st setup the best one. What do you suggest? Right now I'm using Access, but have not uploaded a lot of info to it. What would be the best books or articles to get me going with SQL? Thanks ahead of time for any help.
Woodworks
woodworks-enterprises.com
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 12/23/2004 10:49:00 AM
Posts: 4,
Visits: 1
|
|
| I used Access during my first few websites that didn't see much traffic and even one that did see quite a bit of traffic and several simultanious sessions. It worked well. But I have since made the jump over to MySQL which I like much better. It's a real database without all teh overhead that Access has with it. If you are going to use Access with quite a bit of traffic and over 10-15 simultanious sessions I would be sure that you're coding is first rate. Get in and out of the databse as quickly as possible. Access works great as a stepping stone in smaller websites.
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 7/24/2004 2:39:00 AM
Posts: 2,
Visits: 1
|
|
Yep, we're running a MySQL setup with well over a million members - we're starting to hit the limits of it now, but apparently someone is working on 'optimising' MySQL. My feeling is we should be investigating how to move to SQL Server in a hurry if we need to!
Mark Vickers Partner Marketing Manager
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 12/23/2004 10:49:00 AM
Posts: 4,
Visits: 1
|
|
| What version are you running. I was recently upgraded to 4.0 and I hear it's much more diverse. I don't have a site that would puch it to it's limits though. It has had a lot of bad press with UNION attacks.
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 9/22/2004 9:41:00 AM
Posts: 2,
Visits: 1
|
|
I am getting a bit confused here. The query seemed to be re Microsoft (MS) SQL, yet the reply seems to be MySQL related. They are not the same now, are they? I have My SQL, which am still trying to figure out how to connect to website; I also hav a few prepackaged Microsoft packages eg InfoPath, which seem to be very MS SQL biased. I would welcome any ideas on optimising My SQL, especially re creating a registration form in SharePoint services.
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 7/24/2004 2:39:00 AM
Posts: 2,
Visits: 1
|
|
Ah! Sorry to confuse you!
No, you don't want to mess with MySQL if you're settled on the Microsoft suite, expecially with Sharepoint. Stick to MS Access - you can upscale to SQL Server later if you want, but you'll only need to if you're building a pretty serious application.
Cheers,
Mark
Mark Vickers Partner Marketing Manager
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 9/22/2004 9:41:00 AM
Posts: 2,
Visits: 1
|
|
| Thanks for this. Sounds very reasonable, I will start of and stick to Access, until there is need to upgrade to MS SQL.
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 12/23/2004 10:49:00 AM
Posts: 4,
Visits: 1
|
|
| Sorry if my reply confused anyone. I took the question to mean Access vs. A full on DB solution (MySQL or MS SQL). My expierence is with MySQL so that's where I was coming from.
|
|
|
|
|
|
| | |