Is it REALLY bad tho Neven? i.e. Client sits twiddling their thumbs for a simple query with maybe one or at the most 2 joins?
The app. That I am looking at converting has as a minimum of about 1900 entries made into the DB every day, so the DB will be a res. Size. Would this count against my idea of using MSDE? Jeremy -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Neven MacEwan Sent: Tuesday, 7 October 2003 11:34 To: Multiple recipients of list delphi 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/
