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/
