Great thanks Dennis. As you can see I am not an SQL Server expert (infect have never used it! Starting Friday). The 100 users was just an example.
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 3:00 PM Subject: Re: [DUG]: Fw: MSDE tool > > 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/ > --------------------------------------------------------------------------- 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/
