Support for MySQL; want you ?

Post Reply

Page <1 234 5 9 >

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Posted: 23 March 2005 at 5:44am
	I've just checked the latest version of mySQL and it doesn't support relationships between tables so isn't a Relational Database Management System (RDMS), but is does now support sub queries. Also it looks like the latest myODBC driver does support ADO updates, or to some extent. If so it should make using mySQL with Web Wiz Forums much simpler, so I may look again into making a mySQL version if the problems of the past have been overcome.
	Web Wiz Forums Hosting ASP.NET Web Hosting

RAVALON Members Profile Find Members Posts Groupie Joined: 31 December 2003 Location: Italy Status: Offline Points: 132	Posted: 23 March 2005 at 9:36am
	good.....if you try to convert this forum to Mysql i will be very happy.... For relationship....i confirm again that Mysql support relationship....maybe i just created 3 tables relationed...using DB Tool manager you can simply add relation....control if you want... i link a big italian site that expose a little description of Mysql where is wrote MySQL is a relational DB... http://corsi.html.it/iCorsi/Scheda.aspx?tipo=A&idcorso=41 or in egnlish for you....here http://acs.ucsd.edu/info/mysql.php or here http://onsol.com/mysql.html ...if you try a search with google...all link report MySQL is a relational DB However...i like to remain in contact with you for know if in next future you will try to make this conversion....is it possible ?

michael Members Profile Find Members Posts Senior Member Joined: 08 April 2002 Location: United States Status: Offline Points: 4670	Posted: 23 March 2005 at 12:33pm
	I don't know if I'd call mySQL fully relational. You basically just fake out FK's by referncing foreign columns. Their way of saying it: "It works just fine" does not sound very confident to have robust relationship management, thus I guess it's still better then access.....
	Blog \| MPG Tracker

RAVALON Members Profile Find Members Posts Groupie Joined: 31 December 2003 Location: Italy Status: Offline Points: 132	Posted: 23 March 2005 at 2:22pm
	the most interesting thing is mysql performance and capability for very low price on commercial server... World community which develop MySQL add day after day new features Some becnhmark developed by third part speack about mysql as the second DB in terms of speed... look at this http://www.mysql.com/it-resources/benchmarks/eweek.html in this graphic you can see how much better then SQL server is MySQL...SQL server is at last position...(i know is a good db but if this benchmark say true......beh...) For this and for many others thing that i don't say because of no annoyance someone, i think is good thing make support for this forum Ah...today i try to use ADO metod for add record....it run perfectly...and also subquery...i can confirm this...

RAVALON Members Profile Find Members Posts Groupie Joined: 31 December 2003 Location: Italy Status: Offline Points: 132	Posted: 23 March 2005 at 2:26pm
	for michael....it could be you are right to think this...i'm studing MySQL from 1 month ... i have not yet a perfect acquaintance of all MySQL world....

michael Members Profile Find Members Posts Senior Member Joined: 08 April 2002 Location: United States Status: Offline Points: 4670	Posted: 23 March 2005 at 6:00pm
	I think you are comparing apples with oranges. Sure under certain circumstances, mySQL can perform better. The advatage though of systems like MS SQL, Oracle and DB2 is that they are actually scalable. Frankly for a little forum DB, mySQL is generally fine. I do not put any weight into benchmark test from e-week, who I think are just a bunch of laid off Admins, results I trust are i.e. tpc.org, oh wait mySQL does not participate, but yet they provide their own results. To put this to an end, I am sure mySQL would be a good db for a forum in general and it may even outperform msSQL. Thus for me personally there are some downfalls to be using it for my application development, mostly because of the mySQL Dialect being inferior to T-SQL.
	Blog \| MPG Tracker

RAVALON Members Profile Find Members Posts Groupie Joined: 31 December 2003 Location: Italy Status: Offline Points: 132	Posted: 23 March 2005 at 6:17pm
	the benchmark is from third part....so.... maybe a compare apple with oranges...but surely you are downgrading MySQL capacity....

michael Members Profile Find Members Posts Senior Member Joined: 08 April 2002 Location: United States Status: Offline Points: 4670	Posted: 23 March 2005 at 9:57pm
	Well I am a third party so am I right no matter what? And like I said the benchmark was done by e-week who stinks. Anyway. I am not "downgrading" it, it has it's place just not for me at this point.
	Blog \| MPG Tracker

Post Reply	Page <1 234 5 9 >

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum