Any known weirdness with MySQL?

  • Thread starter Thread starter PSiegmann
  • Start date Start date
P

PSiegmann

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?
 
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?
Click to expand...

its great, try it
 
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.
Click to expand...

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?
Click to expand...

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



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#)
------------------------------------------------------------------------
Click to expand...

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.
 
4Gb of data is hardly "smallish", IMO...
Click to expand...

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.


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



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#)
------------------------------------------------------------------------
Click to expand...

Well, I thought about that too. Any experiences with postgres and .net
on your part?
 
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?
Click to expand...

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

Regards,
Petar Atanasov
http://a-wake.net
 
You could estimate when it will reach this limit (taking a rought estimate
per day). Also do you keep articles forever ? Depending on their nature they
may become outdated and if no more viewed they could perhaps be phased out
or archived (posisbly in another 4GB max limit DB) ?

So I would estimate first when it could happen and would deal with this now
or would let this for a not so near future depending on the result as anyway
available products will be different at this time...
 
If the database is that small and simple I would consider SQL Server Compact
edition as it is fully supported by the current (and future) Visual Studio
tools and has a lot more features (replication, full encryption and more)
than most other small databases. It's also easy to install (just include the
appropriate DLLs in your project), it can fit on a floppy and it's
integrated with the new ADO.NET sync services and local data caching
technology. It's also free.

See my eBook for more information.

--
____________________________________
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)
-----------------------------------------------------------------------------------------------------------------------
 
Back
Top