Rob, You as a programmer decide what is a batch. Every time you execute a query against SQL server, it is one batch - within reason, size does not matter - it can be one simple statement, one complex statement or multiple statements. The only limitations are stored procedure and function creation / alter statements must be the first in the batch.
If you use query analyser, anything between GO statements is a batch. Internally, it splits the query on the GO statements into multiple queries and issues each query in sequence to SQL server. I cannot comment on 100 users using MSDE because you shouldn't be using it for anything other than a few concurrent users. With that sort of a number, you should be using SQL server instead. I suspect internally, the thread manager only allows 5 threads, so if you already have 5 batches running, the other will have to wait until a thread is free. Its only a suspicion though - I have no concrete proof. Regards, Dennis. ----- Original Message ----- From: "Robert martin" <[EMAIL PROTECTED]> To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]> Sent: Wednesday, October 08, 2003 2:02 PM Subject: Re: [DUG]: Fw: MSDE tool > Thanks Dennis > > Any idea how big a gap between the SQL is required for it to count as a new > batch? So I can have 100 users each doing and Query every now and then > without any performance hit? > > > Rob Martin > Software Engineer > > phone 03 377 0495 > fax 03 377 0496 > web www.chreos.com > ----- Original Message ----- > From: "Dennis Chuah" <[EMAIL PROTECTED]> > To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]> > Sent: Wednesday, October 08, 2003 1:41 PM > Subject: Re: [DUG]: Fw: MSDE tool > > > > > > 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/ > > > > -------------------------------------------------------------------------- - > 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/