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?

On Sep 3, 7:28 am, PSiegm...@mail.nu wrote:
> 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

(E-Mail Removed) wrote:

> 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.

a 'smallish' website won't hit the 4GB boundary. So 'smallish' is
perhaps not the right indication or your data estimates are way too big


> 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 find MySql one of the most overrated databases on the planet. If you
want a free, solid database which really is a database, use PostgreSql.

FB

--
------------------------------------------------------------------------
Lead developer of LLBLGen Pro, the productive O/R mapper for .NET
LLBLGen Pro website: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------

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)
-----------------------------------------------------------------------------------------------------------------------

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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?
>

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...

> smallish asp.net site
> 4GB

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

> 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

On Sep 3, 11:29 am, "Frans Bouma [C# MVP]"
<perseus.usenetNOS...@xs4all.nl> wrote:
> PSiegm...@mail.nu wrote:
> > 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.
>
> a 'smallish' website won't hit the 4GB boundary. So 'smallish' is
> perhaps not the right indication or your data estimates are way too big
>
>
> > 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 find MySql one of the most overrated databases on the planet. If you
> want a free, solid database which really is a database, use PostgreSql.
>
> FB
>
> --
> ------------------------------------------------------------------------
> Lead developer of LLBLGen Pro, the productive O/R mapper for .NET
> LLBLGen Pro website:http://www.llblgen.com
> My .NET blog:http://weblogs.asp.net/fbouma
> Microsoft MVP (C#)
> ------------------------------------------------------------------------

Well, I thought about that too. Any experiences with postgres and .net
on your part?

Well, if you are just reading from it then it might be a safe option.

1/2 the people will say MySql will die on you, and 1/2 wont. I will, since
I can't count the number of times we have had to recover the damn thing from
corruption caused by load, bad weather, and gnomes. Never had a single problem
with PostgreSql, so I would say go with that if the site is actually intensive
and you have a little time to learn about it.

But then again, many people run MySqlhell w/o problems. I guess it all depends
on what exactly you are doing with it. The times I have used it from .net
it wasn't a big deal, or particularly difficult to deal with, and now that
v5 is out it's a bit better. There definitly are a lot more tools, and much
more help, our there for it. PG is better in most respects, and _never_
worse, but mysql may do it for you.

If you are generating your database/data layer, then make sure your tools
support it. Many do not, and will only support mysql.


> 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?
>

On Sep 4, 4:43 pm, "Mark Rae [MVP]" <m...@markNOSPAMrae.net> wrote:
> <PSiegm...@mail.nu> wrote in message
>
> news:(E-Mail Removed)...
>
> > smallish asp.net site
> > 4GB
>
> 4Gb of data is hardly "smallish", IMO...
>

Well, it is small. The DB size is at the moment 5 MB.
Most information in the DB is fairly small - ints, datetimes etc. the
only exception are ntext fields for the articles. But the text itself
is mostly small too - around 20 KB.

So, basicaly, all I store in the DB is text and and many ints,
varchars, and datetimes.

I know basicaly that such a setup will work for years before it hits
the 4GB limit. The point is, when it *does* hit it - what to do? Your
only option then is basicaly getting an expensive SQL Server version
without a db limit.

No personal experiences, but PostgreSQL is free under all circumstances
(MySQL is only free if you make your application Open Source, OR, you don't
distribute your application outside the company you own/work for). The only
bad thing I've heard about PostgreSQL is that it's not very fast, which may
be important to you. Bear in mind that this is what I've heard though,
rather than hard evidence.


<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
On Sep 3, 11:29 am, "Frans Bouma [C# MVP]"
<perseus.usenetNOS...@xs4all.nl> wrote:
> PSiegm...@mail.nu wrote:
> > 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.
>
> a 'smallish' website won't hit the 4GB boundary. So 'smallish' is
> perhaps not the right indication or your data estimates are way too big
>
>
> > 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 find MySql one of the most overrated databases on the planet. If
> you
> want a free, solid database which really is a database, use PostgreSql.
>
> FB
>
> --
> ------------------------------------------------------------------------
> Lead developer of LLBLGen Pro, the productive O/R mapper for .NET
> LLBLGen Pro website:http://www.llblgen.com
> My .NET blog:http://weblogs.asp.net/fbouma
> Microsoft MVP (C#)
> ------------------------------------------------------------------------

Well, I thought about that too. Any experiences with postgres and .net
on your part?

(E-Mail Removed) wrote:
> 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?
>

....performance...
MySql Vs. SQL Server
is something like bicycle Vs. F1 bolid

Regards,
Petar Atanasov
http://a-wake.net