|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
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
|
|||
|
|||
|
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? |
|
#2
|
||||
|
||||
|
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.
__________________
My blog about OpenSource Databases PDF tutorials about OSS databases, DBMonster ... Please contribute to Open Source Development, fill bug reports!!! Developer Shed eSupport Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins |
![]() |
| Viewing: Dev Shed Forums > Databases > Database Management > Database advice |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|