Solved

Acess vs MS SQL? How to ... forum?

Posted on 1998-09-19
3
210 Views
Last Modified: 2011-09-20
For a web site to archive a large quantity of forum or some usenet articles, do I need to use database software like these?
Which one should I use? Acess or SQL server? I do expect many people will access this database.
0
Comment
Question by:moneypro
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 4

Expert Comment

by:mcix
ID: 1090195
If you are getting into a large multi-user application SQL Server would be a much better product.
0
 

Author Comment

by:moneypro
ID: 1090196
Should I use SQL to archive forum messages? or is there a better way, say, just store them on web pages and use Index Server to do the search?
0
 

Accepted Solution

by:
tommyq earned 10 total points
ID: 1090197
Please note that according to our tests and Microsoft's documentation, MSAccess' ODBC driver is not multi-htread safe. It might hang up when accessed via more than one thread. Therefor you may consider using something else. I am not sure SQL server is the most cost-effective for you..

Tommy
0

Featured Post

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how the fundamental information of how to create a table.

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question