SQL Server 6.5 versus Access97

SQL Server 6.5 versus Access97

Post by Andrew Stifor » Thu, 19 Nov 1998 04:00:00

   I am working on a project with database connectivity from a web page.
We have everything setup and running using Access97.  The problem is lately
users have been getting error messages back instead of table output.  We
figure that Access97 is having problems keeping up with simultaneous hits
on the DB.
   So we installed the demo of SQL Server 6.5 to do some comparison testing
before buying SQL Server just to make sure we are not wasting money.  Well,
SQL Server 6.5 seems to take 4 times as long to bring back results when
compared to Access97.
   The machine we are testing on is not very spectacular, it is only a
Pentium 200MMX with 64 MB.

My questions are:
1) is it the slow machine with only 64 MB of ram that is causing the
sluggish performance of SQL Server as compared to Access97?

2) would adding more RAM alleviate the problem or does the whole machine
need an upgrade?

3) an lastly, are we barking up the right tree?  We do not seem to be
getting more than 100 simultaneous hits, is this more than Access 97 can
handle and should we be using SQL Server?

Thanx in advance for any help.


1. SQL Server 7.0 versus SQL Server 6.5


SQL Server 6.5 has a system table called SysProcedures. When programming in
Delphi using the component TStoredProc it is possible to select a stored
procedure. The component uses the system table SysProcedures to show all the
stored procedures.

On SQL Server 7.0 this system table SysProcedures no longer exists. This
causes an error with the component TStoredProc, this component can't show
all stored procedures and returns the error that de table SysProcedures
don't exists and therefore can't find the stored procedures.

Does someone know a solution to my problem ?

Thanx for your reactions,
    Richard Bergmans

2. D4GL Date display problem

3. Access97 / SQL Server 6.5: Linking to SQL Views Programatically

4. The recordset can't open

5. migrating sql databases sever 6.5 from sql server 6.5 to another sql server 6.5

6. Linked Server and unable to begin a distributed transaction error

7. Ap Pro Versus Microsoft SQL Server 6.5

8. float fields doing me crazy

9. Access97 <-> SQl Server 6.5 Locking Problem

10. Access97 to SQL Server 6.5 connectivity problem

11. Access97 to SQL Server 6.5

12. SQL Server 6.5 and Access97

13. ODBC timeout expiring (Access97 > SQL Server 6.5