MSDE vs JET 4.0 Multi User et al...
Author |
Message |
Richard Sbragi #1 / 9
|
 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 |
|
 |
Michael Kapla #2 / 9
|
 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 |
|
 |
Mike S #3 / 9
|
 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 |
|
 |
Andy Bar #4 / 9
|
 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 |
|
 |
Richard Sbragi #5 / 9
|
 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 |
|
 |
Michael Kapla #6 / 9
|
 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
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 |
|
 |
Michael Kapla #7 / 9
|
 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 |
|
 |
Mike S #8 / 9
|
 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 |
|
 |
mich #9 / 9
|
 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 |
|
|
|