Any known weirdness with MySQL?

#1

Hi.

For a currently smallish asp.net site we are running currently SQL
Server Express.

But the 4GB limit will be a problem sooner or later, and the licensing
cost for a full blown SQL Server is just too high for such a small
site.

So, I am thinking about using MySQL for it (with the mysql .net
driver: http://www.mysql.com/products/connector/ )

So, is anyone using MySQL ado.net driver here too? Are there some
known problems? How is the performance, and how well does MySQL work
at all with .net?

#2

On Sep 3, 7:28 am, PSiegm... (AT) mail (DOT) nu wrote:

Quote:

Hi.

For a currently smallish asp.net site we are running currently SQL
Server Express.

But the 4GB limit will be a problem sooner or later, and the licensing
cost for a full blown SQL Server is just too high for such a small
site.

So, I am thinking about using MySQL for it (with the mysql .net
driver:http://www.mysql.com/products/connector/)

So, is anyone using MySQL ado.net driver here too? Are there some
known problems? How is the performance, and how well does MySQL work
at all with .net?

its great, try it

#3

Don't assume that an application written for SQL Express will work against
any other DBMS. If you consider that major corporation databases were kept
well under 4GB in the last 30 years I expect many website databases would
stay within this boundary. One approach to make this work is to keep BLOBs
in separate directories. Since many BLOBs are simply RO pictures, this makes
a lot of sense for a half-dozen reasons.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

<PSiegmann (AT) mail (DOT) nu> wrote

Quote:

Hi.

For a currently smallish asp.net site we are running currently SQL
Server Express.

But the 4GB limit will be a problem sooner or later, and the licensing
cost for a full blown SQL Server is just too high for such a small
site.

So, I am thinking about using MySQL for it (with the mysql .net
driver: http://www.mysql.com/products/connector/ )

So, is anyone using MySQL ado.net driver here too? Are there some
known problems? How is the performance, and how well does MySQL work
at all with .net?

#4

<PSiegmann (AT) mail (DOT) nu> wrote

Quote:

smallish asp.net site
4GB

4Gb of data is hardly "smallish", IMO...

Quote:

So, I am thinking about using MySQL for it (with the mysql .net
driver: http://www.mysql.com/products/connector/ )

So, is anyone using MySQL ado.net driver here too? Are there some
known problems? How is the performance, and how well does MySQL work
at all with .net?

I've not really had any problems with it...

--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Any known weirdness with MySQL?

Dotnet Framework (ADO.net) microsoft.public.dotnet.framework.adonet

Any known weirdness with MySQL? - 09-03-2007 , 12:28 AM

Re: Any known weirdness with MySQL? - 09-03-2007 , 04:24 AM

Re: Any known weirdness with MySQL? - 09-03-2007 , 12:44 PM

Re: Any known weirdness with MySQL? - 09-04-2007 , 10:43 AM