| Author |
 Topic Search  Topic Options
|
PsYcHoCoP 
Groupie
Joined: 13 May 2002
Location: Denmark
Status: Offline
Points: 105
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: IIS vs. SQL
Posted: 10 February 2003 at 5:19pm |
Can some one tell me the different ?
if sql is better, is it harder to setup ?
if no, please link a easy guide ?
Currently im running IIS 5 with access
|
The spelling mistakes has been inserted automatically of consideration to the people who find a great pleasure to search for it 
|
 |
Bunce
Senior Member
Joined: 10 April 2002
Location: Australia
Status: Offline
Points: 846
|
Post Options
Thanks(0)
Quote Reply
Posted: 10 February 2003 at 5:45pm |
SQL is a database.
IIS is a web server.
They aren't alternatives.
Cheers,
Andrew
|
|
There have been many, many posts made throughout the world...
This was one of them.
|
|
PsYcHoCoP
Groupie
Joined: 13 May 2002
Location: Denmark
Status: Offline
Points: 105
|
Post Options
Thanks(0)
Quote Reply
Posted: 10 February 2003 at 6:04pm |
I know that dude :P
just a mistake in the first post :)
but i mean with the database connection using web wiz forum
SQL or ACCESS what is best ?
|
The spelling mistakes has been inserted automatically of consideration to the people who find a great pleasure to search for it
|
|
Hawkeye
Groupie
Joined: 05 January 2003
Status: Offline
Points: 56
|
Post Options
Thanks(0)
Quote Reply
Posted: 10 February 2003 at 6:11pm |
I posted a similiar question recently which basically said, "In what cases is SQL preferable over Access".
Here's the scoop: SQL is faster. If you're going to be running a large forum (many users, many daily posts), use SQL.
However, for a small forum with only around 15 daily posts or so, there isn't much difference (this is according to Borg).
Hope this helps.
|
|
Bunce
Senior Member
Joined: 10 April 2002
Location: Australia
Status: Offline
Points: 846
|
Post Options
Thanks(0)
Quote Reply
Posted: 10 February 2003 at 6:18pm |
SQL SERVER is obvisouly the best as is it a complete RDBMS, but Access is cheaper (free) and will handle A LOT MORE than 15 posts per day.
Unless you have a pretty busy site then Access is suitable, if not ideal...
Cheers,
Andrew
Edited by Bunce
|
|
There have been many, many posts made throughout the world...
This was one of them.
|
|
Anilx
Newbie
Joined: 28 January 2003
Location: United States
Status: Offline
Points: 24
|
Post Options
Thanks(0)
Quote Reply
Posted: 10 February 2003 at 8:56pm |
|
Accesss will handle like 100 posts a day..i think it's much more than that but a safe guess! Don't belittle access. Access is part of MS office and MS office ain't free. Access is not a very cheap database but very very very cheap compaared to MS sQl.
Edited by Anilx
|
|
michael
Senior Member
Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
|
Post Options
Thanks(0)
Quote Reply
Posted: 10 February 2003 at 10:13pm |
 Anilx wrote:
Accesss will handle like 100 posts a day..i think it's much more than that but a safe guess! Don't belittle access. Access is part of MS office and MS office ain't free. Access is not a very cheap database but very very very cheap compaared to MS sQl. |
K Access can handle way more posts then 100. My company uses Access for a General Ledger application where some customers easily have 15,000 transactions a day where each transaction has between 5-15 database hits. Access is part of office yes but Access is the application not the database to be exact. The database is Jet and IS free, you can create it with a simple sql statement or so.
|
|
Bunce
Senior Member
Joined: 10 April 2002
Location: Australia
Status: Offline
Points: 846
|
Post Options
Thanks(0)
Quote Reply
Posted: 10 February 2003 at 10:15pm |
|
Exactly. And it's STILL CHEAP even as part of Office.
|
|
There have been many, many posts made throughout the world...
This was one of them.
|
|
