A batch in SQL server is basically one or more queries executed in series by one database connection.
----- Original Message ----- From: "Robert martin" <[EMAIL PROTECTED]> To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]> Sent: Tuesday, October 07, 2003 11:49 AM Subject: Re: [DUG]: Fw: MSDE tool > 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/ > --------------------------------------------------------------------------- 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/
