Re: Benfits of SQL server

Dale E. Reed Jr. ( (no email) )
Sat, 01 Mar 1997 16:35:09 -0800

Christian Gatti wrote:
> This is possibily a little bit off topic but it would help me
> if I could find some answers to the following questions:
> I use ASP, IDC scripts in my WWW pages (over ODBC) without the
> SQL server installed on my NT 4.0 server and I can handle
> databases just fine. What can I do more if I would buy and use
> the SQL server 6.5 of microsoft. Only a performance issue?
> What is the difference between working with databses using the SQL server
> or databses not useing the SQL server but only a ODBC?
> Any help is welcome,

ODBC is just a connector. It connects you to a back end database
engine. MS pushes the JET (Access) engine in just about everything.
JET isn't multi-user scaleable (atleast not what most people would
accept as scaleable) since the engine runs on the same machine as
the ODBC driver.

SQL Server is client/server oriented. The DB engine runs remotely
on the SQL Server, therefore the client doesn't have the CPU processing
requirements. Now you might think: "wouldn't JET be faster because the
processing is spread across each client?". The simple answer is no.
Mainly because you have to traverse the indexes over the network,
the SQL Server traverses the indexes over (hopefully) a FAST SCSI-II/III
bus. Generally the data moving between the client/server is almost
nothing compared to what JET sends across the wire.

My experience with running RadiusNT against MS Access is nothing
short of disappointing. The intermitten 5-12 second delays of
"grindage" are unacceptable in an authentication environment. These
do NOT happen when you have RadiusNT up against SQL Server.

-- Dale E. Reed Jr.  (       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |