Database Management
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesDatabase Management

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
SlickEdit: Code in over 40 languages across 7 platforms. SlickEdit’s unmatched power, speed, and flexibility allows even the most accomplished developers to write better code faster. Download a free trial today!
  #1  
Old February 20th, 2003, 11:36 AM
fishbulb fishbulb is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Feb 2003
Location: Ocean State
Posts: 6 fishbulb User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Database advice

Hey all, new to this forum...

Spent the past year or so developing small web apps for small businesses using ColdFusion and MSAccess. Recently got a contract for a much bigger job, and I'm looking for some friendly advice.

The job is for a website with a reasonable amount of database work, not too many records for Access to handle. My concern is that the number of users is expected to be very high. I haven't had any problems with this with the apps I've developed, however they've been very small, for no more than 10 users at a time.

In developing for this type of site, what method would give me less headaches? I have no experience with MySQL, XML, or much else, but I'm sure as heck willing to learn whatever I need. Is there a language/DB system that's well-suited for this type of work?

Reply With Quote
  #2  
Old February 20th, 2003, 12:20 PM
pabloj's Avatar
pabloj pabloj is offline
Modding: Oracle MsSQL Firebird
Dev Shed God 6th Plane (7500 - 7999 posts)
 
Join Date: Jun 2001
Location: Outside US
Posts: 7,620 pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level) 
Time spent in forums: 2 Months 2 Weeks 3 Days 23 h 47 m 19 sec
Reputation Power: 259
Anything but Access.
I'd go for Firebird or MySQL as you seem to be working on M$ platform, SAPDB is a bit tough for a beginner (don't get me wrong, what I mean is that Access behaves differently from standard dbs, and if you are used to it only, you would face a steeper learning curve) and PostgreSQL support for Windows is beta quality.
Notice that MySQL lacks some sql features that Access has (subqueries and views to name a few), this is not the case for Firebird, SAPDB or PostgreSQL.

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesDatabase Management > Database advice


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 4 hosted by Hostway