hey friends...i request you all to pls help me out...im damn confused...

im planning to make a website by March,2011 in which i will be using HTML/JSP and Mysql as d/b. however, i have a few doubts abt. Mysql....

1) on the mysql site, there are many packages available to download. which one should i d/l. im using windows 7 and netbeans IDE?

2) im confused whether i should use only the essentials package or the complete package ? wats d difference between both as far as query processing time is considered. my web application needs lowest query response time.

3) any tutorial site covering all the queries of Mysql....???

4) is there any other d/b that i should use instead of Mysql ? im not willing to invest any money since im a student and i have previusly worked on oracle and sql.

thanx a lot in advance.
:)

Re: which mysql server to download?? 80 80

1) Choose the package for your SERVER's operating system.
2) Regarding processing time, there is no difference as far as I know. Use MyISAM tables for optimum speed and InnoDB for relational integrity (foreign keys).
3) The Mysql manual on their site is fairly complete regarding "all the queries." For a start see http://www.webdevelopersnotes.com/tutorials/sql/mysql_primer_creating_a_database.php3 which seems to be a decent primer.
4) Mysql is in my opinion the best for website programming. Very stable and performant. Get HeidiSQL or Navicat as a development interface.

Re: which mysql server to download?? 80 80

@ smantscheff : thanx a lot friend...!!!
if i use a development interface, will it have less query response time as compared to normal installer packages. and can i use the MYSQL GUI workbench packages instead of HeidiSQL or Navicat ?

:)

Re: which mysql server to download?? 80 80

Last time I tried the workbench it was for database administration (DDL) only, not for data input and editing. Heidi and Navicat are far beyond.
Don't worry about query time in development. MySQL is quite performant.

Re: which mysql server to download?? 80 80

If you want xampp (opensource apache mysql php and pearl) you can view my step by step tutorial:
http://codewall.blogspot.com/2011/01/how-to-install-xampp-step-by-step.html

or read my of my tutorials regarding mysql in xampp:
http://codewall.blogspot.com/p/my-tutorial.html

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.