Database choice?

[Ian]

Hi there,

I am currently writing an application for NNTP, the application requires
very FAST inserts, updates etc.

I started to write it with mySQL and I got good results, I was wondering if
anyone can confirm speed comparisions (and other comparisons) using MSDE
rather than mySQL.

As far as i know my app which runs on the desktop requires no special
licenses to use MSDE but mySQL does.

The application with only have 1 concurrent user and is being developed with
c# Visual Studio.net, although there will be only 1 user accessing the
database (desktop application) there could be around 10 connections to the
database..

Any help or information anybody can offer would be gratefully appreciated

Thanks in advance

Ian

 

[William Ryan eMVP]

Ian:

It's a hard thing to benchmark in 'general' terms b/c the hardware and way
you code the app will have a more profound impact. Furhtermore, in the
scenario that you mention, things should be damned fast either way - most
performance differences don't show themselves until there is some stress on
the app.

MSDE has many advantages though. 1) you can use the SQLClient library which
is going to be faster than ODBC. There are specific providers and they have
a huge impact on performance. 2) You get all of the featueres of SQLServer
NOW. I still don't think mySQL has Stored procs - but I haven't checked
recently.

I think you can probably rest assured that going forward MSDE will continue
to get support and features from MS that won't be available to other
providers too.

--
W.G. Ryan MVP Windows - Embedded

Have an opinion on the effectiveness of Microsoft Embedded newsgroups?
Let Microsoft know!
https://www.windowsembeddedeval.com/community/newsgroups

 

[William \(Bill\) Vaughn]

I'm with Mr. Ryan in this case (as usual). How you design the database is as
important as which interface you use to communicate with the DB engine. How
many indexes are being used? How many rows are you trying to add? Remember,
ADO is NOT a good bulk copy interface--not until ADO 2.0 which includes BCP
functionality. I always suggest DTS/BCP for importing lots of rows. When
adding a few rows (a dozen or so) a second ADO holds up just fine. More than
that you probably should consider a bulk insert strategy as you'll be
spending all of your time doing round trips to the server to add the rows
individually. ADO 2.0 also has smarter "batch" updates that can help as
well... but that won't be here until next year (sometime).

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

 

[WJ]

As far as i know my app which runs on the desktop requires no special
licenses to use MSDE but mySQL does.

However, to install MSDE on your clients, your clients must own MS/Office
suite in order to use MSDE free.

John

 

[William \(Bill\) Vaughn]

Ah no. Not any longer. There aren't any such restrictions.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

 

[WJ]

Ah no. Not any longer. There aren't any such restrictions.

Must be nice. Hail to MS

John