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/
