| Author |
 Topic Search  Topic Options
|
faca5 
Mod Builder Group
Joined: 30 July 2003
Location: Slovenia
Status: Offline
Points: 187
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Database questions
Posted: 02 June 2004 at 4:20pm |
Hello.
I have some question about database.
1. How many users can access in the same time to the database?
When is used Access?
When is used SQL?
When is used Oracle?
When is used Ms SQL?
2. Which database is more useful for advance or professional used when is website writen on ASP?
3. If you use some database (which?) and you are great ful?
4. If you use on ASP website exp. access database and you will try with some SQL database, you need to modific the website or it is not nesesary because is used SQL?
Thank you.
|
|
|
 |
Semikolon
Senior Member
Joined: 09 September 2003
Location: Norway
Status: Offline
Points: 1718
|
Post Options
Thanks(0)
Quote Reply
Posted: 03 June 2004 at 12:23pm |
- Access: not many, but enough for a guestbook or small website
SQL is not a database, but a programming language used together with relational databases.
Oracle: have no idea
MS SQL Server: Probably more than enough
- Microsoft SQL Server 2000 (and soon maybe 2005)
- I use MS SQL Server 2000 and it's more than good enough
- Access is an SQL database, but it does not follow all the
standards, so some queries need to be changed if you move to MS SQL
Server.. have never used MySQL and Oracle, so I'm not sure about those,
but they do probably follow the standards, which means you may have to
edit some queries.
|
|
zaboss
Senior Member
Joined: 20 August 2002
Location: Romania
Status: Offline
Points: 454
|
Post Options
Thanks(0)
Quote Reply
Posted: 03 June 2004 at 12:46pm |
|
1. Access could handle in theory 255 simultaneous connections. It
depends on coding, on code... Anyway, it's not safe to use it with more
than 100 users on a site at any given time.
ORACLE, MySQL, SQL Server could handle enough connections to keep the busiest site up and running OK.
2. ASP works better with SQL server.
3. It depends on your application. You could use Access and be happy. I use Acces, MySQL and SQL Server.
4. From Access to SQL Server there are only few adjustments. If you
switch to mySQL or ORACLE, there are more changes to be done. But, it
depend on the applications. All the apps I have designed work with
MySQL, SQL Server and Access.
|
|
|
|
faca5
Mod Builder Group
Joined: 30 July 2003
Location: Slovenia
Status: Offline
Points: 187
|
Post Options
Thanks(0)
Quote Reply
Posted: 05 June 2004 at 5:49am |
Ok, thank for answer.
I now SQL is a "Standard Query Language", because is "standard" I supouse it don't need to be change all websites, if you need to use new database. Database like Access and Oracle it different. Access is like database for 1-10 users, Oracle is like for 100 and more users connected in the some time.
|
|
|
|
Mart
Senior Member
Joined: 30 November 2002
Status: Offline
Points: 2304
|
Post Options
Thanks(0)
Quote Reply
Posted: 05 June 2004 at 5:52am |
|
Actually it's Structured Query Language
|
|
faca5
Mod Builder Group
Joined: 30 July 2003
Location: Slovenia
Status: Offline
Points: 187
|
Post Options
Thanks(0)
Quote Reply
Posted: 05 June 2004 at 6:01am |
Ok. 
I write wrong.
|
|
|
|
Semikolon
Senior Member
Joined: 09 September 2003
Location: Norway
Status: Offline
Points: 1718
|
Post Options
Thanks(0)
Quote Reply
Posted: 05 June 2004 at 9:56am |
 faca5 wrote:
Ok, thank for answer.
I now SQL is a "Standard Query Language", because is "standard" I
supouse it don't need to be change all websites, if you need to
use new database. Database like Access and Oracle it different. Access
is like database for 1-10 users, Oracle is like for 100 and more users
connected in the some time. |
you don't need to change everything, but something has to be changed,
like stored procedures can't be used with Access and MySQL, the boolean
values in MSSQL server is 1/0 and in Acces it's True/False etc.. mostly
smaller things..
|
|
