I have just checked the Microsoft site for information and spotted the following.
"MSDE 2000 is a local data engine that can be shared. It has a managed concurrency workload governor that limits up to five concurrent batch workloads for optimal performance. Commands and log entries are available to monitor instances where more than five workloads are executed concurrently, a situation that can cause slower performance even on well-tuned systems. As more batch workloads are submitted beyond the five-workload limit, the concurrency governor continues to slow down the system. These workloads are not dropped or lost; they are still processed, but in an increasingly degraded performance mode. If your solution must support more than five concurrent workloads, it is highly recommended that you migrate to SQL Server 2000 or SQL Server 2000 Enterprise Edition for optimal performance at this higher level of scalability." I had taken 'five concurrent batch workloads' to mean users but it might be concurrent queries or maybe complex queries count as multiple batches? Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com ----- Original Message ----- From: "Neven MacEwan" <[EMAIL PROTECTED]> To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]> Sent: Tuesday, October 07, 2003 11:33 AM Subject: Re: [DUG]: Fw: MSDE tool > Robert > > As I said I've not experianced this (and i have > a site running 10+ users on MSDE with a financials package) > The only performance hit I've had is on joined queries > > N > ----- Original Message ----- > From: "Robert martin" <[EMAIL PROTECTED]> > To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]> > Sent: Tuesday, October 07, 2003 11:12 AM > Subject: Re: [DUG]: Fw: MSDE tool > > > > I believe the deal with MSDE is that it IS throttled to give very poor > > performance with more than 5 connections. I heard it was something like a > > 50% drop for each user over 5. > > > > Rob Martin > > Software Engineer > > > > phone 03 377 0495 > > fax 03 377 0496 > > web www.chreos.com > > ----- Original Message ----- > > From: "Neven MacEwan" <[EMAIL PROTECTED]> > > To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]> > > Sent: Tuesday, October 07, 2003 10:45 AM > > Subject: [DUG]: Fw: MSDE tool > > > > > > > Alan > > > > > > Yeah, i'm happy for it to go into the public domain > > > (We don't realy want to support it), It uses virtualtreeview > > > and is a warpper for the SQL-DMO Objects > > > > > > I'd prefer to keep it under subversion (so everyone > > > benfits from changes) so if anyone else would like access to it I'll set > > up > > > a public domain repository (email me off list) > > > > > > Re the licencing, I think its pretty loose (I've not > > > worried to much) from what I've read on ADO > > > newgroup M$ just want it out there as a launching pad > > > for full SQL, AFAIK its NOT user limitied but the only > > > problems I've had have been performance on relatively > > > simple queries over multiple tables (3 to 4) on large > > > databases, 1 query ran 32 seconds on SQL 7, 20+ minutes on > > > MSDE (same database, same memory and CPU), > > > Almost as if the thing was throttled (do do do do <spooky noise>) > > > My theory is that M$ made it this way because when it > > > is backended to Access the query opt would be done by > > > Jet (and MSDE would act as a glorified ISAM) but it > > > prevents you from using it in serious DB applications > > > > > > HTH > > > > > > Neven > > > > > > > > > > > > ----- Original Message ----- > > > From: "Allan, Samuel" <[EMAIL PROTECTED]> > > > To: <[EMAIL PROTECTED]> > > > Sent: Tuesday, October 07, 2003 10:27 AM > > > Subject: MSDE tool > > > > > > > > > > Hi Neven, > > > > > > > > I am interested in your MSDE tool because I am also looking at using > > > > MSDE. Is it free? Can I have it? > > > > > > > > On another note, I have been looking at the licensing guff on the > > > > Micrsoft website, and I am confused. Perhaps you know off the top of > > > > your head what I have to buy to be able to re-distribute MSDE as part > of > > > > my software, and if I can then develop in Delphi instead of whatever I > > > > bought? > > > > > > > > Thanks, > > > > Samuel Allan > > > > > > > > > > > > -------------------------------------------------------------------------- > > - > > > New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] > > > Website: http://www.delphi.org.nz > > > To UnSub, send email to: [EMAIL PROTECTED] > > > with body of "unsubscribe delphi" > > > Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ > > > > > > > > > > -------------------------------------------------------------------------- > - > > New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] > > Website: http://www.delphi.org.nz > > To UnSub, send email to: [EMAIL PROTECTED] > > with body of "unsubscribe delphi" > > Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ > > > > > > -------------------------------------------------------------------------- - > New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] > Website: http://www.delphi.org.nz > To UnSub, send email to: [EMAIL PROTECTED] > with body of "unsubscribe delphi" > Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ > > --------------------------------------------------------------------------- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of "unsubscribe delphi" Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
