>>|-----Original Message----- >>|From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] >>| >>|Have some free time on my hands ands as I've never used mySQL >>|before I was considering having a look at it and playing around a bit. Now >>|apart from it being free is there any benefit to actually using mySQL over access? SOme >>|people swear its much faster than access but I'm also aware >>|thats it lacks a lot features.
*** WARNING: Longish-type email to follow ... *** WHAT!? You have FREE TIME??!!! *** get's out muffin pan *** BAP! BAP! BAP! <harumph> *** muttering about deadlines and moving and packing ... wishes Kola were here to help ... *** <grin> I haven't used mySQL, but I've researched it a bit just for curiosity's sake, so here are some of the goodies I've come across. In my opinion, if you already use SQL Server .. stick to it. Unless the client doesn't want to spring for it. Then mySQL seems like the most viable alternative, even though it's not feature-rich. With spare time on your hands, and the coming of NEO, why don't you dive into some Java? Unless of course you already do that! :) Anyways, hope the following points you in some kind of direction! :) Some pretty decent resources: http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html http://www.analysisandsolutions.com/code/mybasic.htm http://hotwired.lycos.com/webmonkey/programming/php/tutorials/tutorial4.html http://www.devshed.com/Server_Side/MySQL/MySQLWiz/page1.html http://www.devshed.com/Server_Side/MySQL/Access/page1.html http://www.devshed.com/Server_Side/MySQL/ODBC/page1.html mySQL Interface: http://www.dbtools.com.br/index.php ----------------------------------------- >From a previous posts on CF-Talk: >>|-----Original Message----- >>|From: Paris Lundis [mailto:[EMAIL PROTECTED]] >>|Sent: 10 November 2001 08:25 >>|To: CF-Talk >>|Subject: MySQL 4.0 >>| >>|".... >>|MySQL 4.0 further increases the speed of MySQL in a number of >>|areas, such as bulk INSERTs, searching on packed indices, creation of FULLTEXT >>|indices as well as COUNT(DISTINCT). >>| >>|The table handler InnoDB is now offered as a a feature of the >>|standard MySQL server, including full support for transactions and row-level >>|locking...." ------------------------------------------ >>|-----Original Message----- >>|From: Alex [mailto:[EMAIL PROTECTED]] >>|Sent: 31 July 2001 22:34 >>|To: CF-Talk >>|Subject: Re: [mySQL] >>| >>| >>|its free, fast, has hype. NO triggers, stored procs, sub >>|queries, row level locking. Pretty much any enterprise utilities that a DB has >>|MySQL doesn't. Nusphere makes a custom MySQL with some enterprise features at a >>|price. Also postgresql is free. If you already have SQLServer stick with it; >>|it's easier and better. I have MySQL and coldfusion working together fine. ----------------------------------------- >>|-----Original Message----- >>|From: Costas Piliotis [mailto:[EMAIL PROTECTED]] >>|Sent: 31 July 2001 23:31 >>|To: CF-Talk >>|Subject: RE: mySQL >>| >>| >>|First off, it's not fully ANSI-92 Compliant last I checked... >>|Here's your answers: >>| >>|a. will it support 4-5 and even 10 gig of data? >>|Sure. It indexes the data. Should be fine. >>|b. will it allow full-text indexing/searching? >>|Yes!: http://www.mysql.com/doc/F/u/Fulltext_Search.html >>| >>|c. does it allow replication between remote servers? >>|Yes!: http://www.mysql.com/doc/R/e/Replication_Options.html >>| >>| d. anyone know something about hebrew support? >>|Yes, but you need to reconfigure: >>| Her's what the manual says: >>| >>| By default, MySQL uses the ISO-8859-1 (Latin1) character set. To >>|change the default set, use the --with-charset option: >>|shell> ./configure --with-charset=CHARSET >>| >>|CHARSET may be one of big5, cp1251, cp1257, czech, danish, dec8, dos, >>|euc_kr, gb2312, gbk, german1, hebrew, hp8, hungarian, koi8_ru, koi8_ukr, >>|latin1, latin2, sjis, swe7, tis620, ujis, usa7, or win1251ukr. >>|See section 7.1.1 ----------------------------------------------------- Erika L. Walker-Arnold, VP, RUWebby, LLC ----------------------------------------------------- Macromedia ColdFusion Alliance Partner Macromedia ColdFusion 5.0 Certified Developer ----------------------------------------------------- ______________________________________________________________________ Macromedia ColdFusion 5 Training from the Source Step by Step ColdFusion http://www.amazon.com/exec/obidos/ASIN/0201758474/houseoffusion Archives: http://www.mail-archive.com/cf-community@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists