by Hello,
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.