MSDE vs JET 4.0 Multi User et al... 
Author Message
 MSDE vs JET 4.0 Multi User et al...

I have been reading the tech mags and have heard:
    MSDE is single user, optimized for 3 users, 5 users, can handle up to 10
users, only should be used in win98, if using 95 use jet, NT use SQL.

What is the story hear, anyone, anyone......

Is the MSDE engine going to operate faster than Jet, I have read that the
MSDE processes data on the server side, a huge benefit over jet, but Stephen
Forte only recommends one scenario to use MSDE(June advisor)

I am confused.  Please help or direct me to some good articles so I can
figure this out.



Mon, 03 Dec 2001 03:00:00 GMT  
 MSDE vs JET 4.0 Multi User et al...
Um, in almost cases MSDE is being run locally, and in those
cases, the server *is* your machine and therefore there is
no special benefit to running it on the server.

Stephen's article is right on the money so if you read it
you will not be confused. The only thing that contradicts
his article is marketing nonsense that you should ignore if
possible.

--

Michael

-------------------------------
random junk of dubious value is at:
http://www.trigeminal.com



Quote:
> I have been reading the tech mags and have heard:
>     MSDE is single user, optimized for 3 users, 5 users,
can handle up to 10
> users, only should be used in win98, if using 95 use jet,
NT use SQL.

> What is the story hear, anyone, anyone......

> Is the MSDE engine going to operate faster than Jet, I
have read that the
> MSDE processes data on the server side, a huge benefit

over jet, but Stephen
Quote:
> Forte only recommends one scenario to use MSDE(June
advisor)

> I am confused.  Please help or direct me to some good
articles so I can
> figure this out.



Mon, 03 Dec 2001 03:00:00 GMT  
 MSDE vs JET 4.0 Multi User et al...
Richard,
MSDE is optimized for 5 users but has no user limit and runs on 95/98/NT.
Here is a good white paper on Jet and MSDE:
http://www.microsoft.com/office/enterprise/prodinfo/MSDtaEng.htm

---
Mike S.
Optimal Systems Corp.  www.oscorp.com
---

Quote:

>I have been reading the tech mags and have heard:
>    MSDE is single user, optimized for 3 users, 5 users, can handle up to
10
>users, only should be used in win98, if using 95 use jet, NT use SQL.

>What is the story hear, anyone, anyone......

>Is the MSDE engine going to operate faster than Jet, I have read that the
>MSDE processes data on the server side, a huge benefit over jet, but
Stephen
>Forte only recommends one scenario to use MSDE(June advisor)

>I am confused.  Please help or direct me to some good articles so I can
>figure this out.



Mon, 03 Dec 2001 03:00:00 GMT  
 MSDE vs JET 4.0 Multi User et al...
The reason to use MSDE is that your database will be easily scalable.
If your database will always only be used by a small (say, 3) number
of users, then Jet is probably just as good, but MSDE will work. If
you will always only have 5 to 30 or so users, then MSDE will break
down, but Jet will do fine.

For more users, you will probably need to upsize to something like SQL
Server. This is where the advantages of MSDE become clear. Because
MSDE is just a somewhat crippled version of SQL Server, upsizing to
full SQL Server is trivial. Upsizing a Jet database is not.

Apart from the scalability, there are a bunch of things that SQL
Server (and MSDE) can do that Jet cannot -- stored procedures and
triggers written in T-SQL, better security, transaction logs and
disaster recovery, etc. If your application needs any of that, then
look at MSDE.

Also, Microsoft has made it clear that they have a whole lot more
interest in promoting and developing uses for SQL Server than for Jet.
So getting familiar with it by working with MSDE is a good idea.

The operating system isn't a factor, since both engines run on all
32-bit versions of Windows.

 -- Andy

Quote:

>I have been reading the tech mags and have heard:
>    MSDE is single user, optimized for 3 users, 5 users, can handle up to 10
>users, only should be used in win98, if using 95 use jet, NT use SQL.

>What is the story hear, anyone, anyone......

>Is the MSDE engine going to operate faster than Jet, I have read that the
>MSDE processes data on the server side, a huge benefit over jet, but Stephen
>Forte only recommends one scenario to use MSDE(June advisor)

>I am confused.  Please help or direct me to some good articles so I can
>figure this out.



Tue, 04 Dec 2001 03:00:00 GMT  
 MSDE vs JET 4.0 Multi User et al...
In reference to MSDE running locally, what about the backend on the network
and the front on the client...


Quote:
> Um, in almost cases MSDE is being run locally, and in those
> cases, the server *is* your machine and therefore there is
> no special benefit to running it on the server.

> Stephen's article is right on the money so if you read it
> you will not be confused. The only thing that contradicts
> his article is marketing nonsense that you should ignore if
> possible.

> --

> Michael

> -------------------------------
> random junk of dubious value is at:
> http://www.trigeminal.com



> > I have been reading the tech mags and have heard:
> >     MSDE is single user, optimized for 3 users, 5 users,
> can handle up to 10
> > users, only should be used in win98, if using 95 use jet,
> NT use SQL.

> > What is the story hear, anyone, anyone......

> > Is the MSDE engine going to operate faster than Jet, I
> have read that the
> > MSDE processes data on the server side, a huge benefit
> over jet, but Stephen
> > Forte only recommends one scenario to use MSDE(June
> advisor)

> > I am confused.  Please help or direct me to some good
> articles so I can
> > figure this out.



Tue, 04 Dec 2001 03:00:00 GMT  
 MSDE vs JET 4.0 Multi User et al...
Whoopie! You can connect to a SQL Server junior, up to three
people without perf dropoff, all of which is slower than a
Jet backend.

Sorry, only stupid people will believe that this a good
thing.

--

Michael

-------------------------------
random junk of dubious value is at:
http://www.trigeminal.com



Quote:
> In reference to MSDE running locally, what about the

backend on the network
Quote:
> and the front on the client...


in message

> > Um, in almost cases MSDE is being run locally, and in
those
> > cases, the server *is* your machine and therefore there
is
> > no special benefit to running it on the server.

> > Stephen's article is right on the money so if you read
it
> > you will not be confused. The only thing that
contradicts
> > his article is marketing nonsense that you should ignore
if
> > possible.

> > --

> > Michael

> > -------------------------------
> > random junk of dubious value is at:
> > http://www.trigeminal.com


> > message


- Show quoted text -

Quote:
> > > I have been reading the tech mags and have heard:
> > >     MSDE is single user, optimized for 3 users, 5
users,
> > can handle up to 10
> > > users, only should be used in win98, if using 95 use
jet,
> > NT use SQL.

> > > What is the story hear, anyone, anyone......

> > > Is the MSDE engine going to operate faster than Jet, I
> > have read that the
> > > MSDE processes data on the server side, a huge benefit
> > over jet, but Stephen
> > > Forte only recommends one scenario to use MSDE(June
> > advisor)

> > > I am confused.  Please help or direct me to some good
> > articles so I can
> > > figure this out.



Tue, 04 Dec 2001 03:00:00 GMT  
 MSDE vs JET 4.0 Multi User et al...
(Rolling eyes, as I probably will for the balance of this
version's life).

This paper is marketing fluff. MSDE is not a realistic
business solution for CS apps that is even close to perf
parity with the older Jet/linked table approach.

The only useful thing that can be done with MSDE is
prototyping apps that will be going to a real SQL Server.

--

MichKa

-------------------------------
random junk of dubious value is at:
http://www.trigeminal.com


Quote:
> Richard,
> MSDE is optimized for 5 users but has no user limit and
runs on 95/98/NT.
> Here is a good white paper on Jet and MSDE:

http://www.microsoft.com/office/enterprise/prodinfo/MSDtaEng
.htm
Quote:

> ---
> Mike S.
> Optimal Systems Corp.  www.oscorp.com
> ---

> >I have been reading the tech mags and have heard:
> >    MSDE is single user, optimized for 3 users, 5 users,
can handle up to
> 10
> >users, only should be used in win98, if using 95 use jet,
NT use SQL.

> >What is the story hear, anyone, anyone......

> >Is the MSDE engine going to operate faster than Jet, I
have read that the
> >MSDE processes data on the server side, a huge benefit
over jet, but
> Stephen
> >Forte only recommends one scenario to use MSDE(June
advisor)

> >I am confused.  Please help or direct me to some good
articles so I can
> >figure this out.



Thu, 06 Dec 2001 03:00:00 GMT  
 MSDE vs JET 4.0 Multi User et al...
Michael,
I agree that MSDE in useful only for developing and testing SQL server apps.
Jet is still better especially in multi user handling.

After sorting through the new stuff, I am sticking with Acc97 over Acc2000
and with Jet over MSDE.  I will be testing Acc97 with Jet4 using ADO which I
think would the best combination in the bunch (if it works).  However, I
have a feeling that Jet4 is going to be slower that Jet3.x because of the
page size difference brought by unicde use.

What do you think?
---
Mike S.
Optimal Systems Corp.  www.oscorp.com
---

Quote:
>(Rolling eyes, as I probably will for the balance of this
>version's life).

>This paper is marketing fluff. MSDE is not a realistic
>business solution for CS apps that is even close to perf
>parity with the older Jet/linked table approach.

>The only useful thing that can be done with MSDE is
>prototyping apps that will be going to a real SQL Server.

>--

>MichKa

>-------------------------------
>random junk of dubious value is at:
>http://www.trigeminal.com



Fri, 07 Dec 2001 03:00:00 GMT  
 MSDE vs JET 4.0 Multi User et al...
Personally I am using VB and Jet 4.0 directly when possible
(a-la the TSI Synchronizer stuff) and via DAO 3.6 or
occasionally ADO when I have no choice. I am staying away
from Access, mostly.

--

MichKa

-------------------------------
random junk of dubious value is at:
http://www.trigeminal.com


Quote:
> Michael,
> I agree that MSDE in useful only for developing and

testing SQL server apps.
Quote:
> Jet is still better especially in multi user handling.

> After sorting through the new stuff, I am sticking with
Acc97 over Acc2000
> and with Jet over MSDE.  I will be testing Acc97 with Jet4
using ADO which I
> think would the best combination in the bunch (if it
works).  However, I
> have a feeling that Jet4 is going to be slower that Jet3.x
because of the
> page size difference brought by unicde use.

> What do you think?
> ---
> Mike S.
> Optimal Systems Corp.  www.oscorp.com
> ---
> >(Rolling eyes, as I probably will for the balance of this
> >version's life).

> >This paper is marketing fluff. MSDE is not a realistic
> >business solution for CS apps that is even close to perf
> >parity with the older Jet/linked table approach.

> >The only useful thing that can be done with MSDE is
> >prototyping apps that will be going to a real SQL Server.

> >--

> >MichKa

> >-------------------------------
> >random junk of dubious value is at:
> >http://www.trigeminal.com



Fri, 07 Dec 2001 03:00:00 GMT  
 
 [ 9 post ] 

 Relevant Pages 

1. Jet 3.51 vs Jet 4.0 vs MSDE

2. Jet DB Performance (Jet 3.51 vs. Jet 4.0)

3. Ms Jet 4.0 VS Jet 3.51 problem loading data

4. Jet 4.0 vs. Jet 3.51

5. MS Jet 3.51 vs Jet 4.0

6. Jet 3.51 vs JET 4.0

7. jet 3.5 vs jet 4.0

8. ADO Jet 4.0 performance problem vs Jet 3.51

9. Jet vs MSDE

10. MSDE vs Jet OLE DB

11. VB5 Access2000 MSDE Jet 4.0

12. It's that time Again (et al)

 

 
Powered by phpBB® Forum Software