RE: [PHP-DB] ER Diagramming tool for MySQL

2007-10-22 Thread Instruct ICC
Maybe we should keep top posting for consistency in this particular thread? Case Studio 2 does not appear to be free. Toad seems to be Windows only and no ER Diagramming? I use dbdesigner, but manually draw the relations (I believe this is since MySQL <= 3.23.58; MySQL <= 4.0.17 did not have re

[PHP-DB] PHP and MySQL design question

2007-10-22 Thread Byte Smokers
Hello all I have a table like: CREATE TABLE `benchmarks` ( `name` varchar(50) NOT NULL default '', `logic` varchar(50) NOT NULL default '', `status` varchar(50) NOT NULL default '', `difficulty` int(11) NOT NULL default '0', `xmldata` longblob, PRIMARY KEY (`name`), KEY `logic` (`l

RE: [PHP-DB] ER Diagramming tool for MySQL

2007-10-22 Thread Lasitha Alawatta
Hi Instruct, Thankyou for your reply. You are correct "Case Studio 2" is not a free tool, but "Toad" have ER Diagramming feature. Same as "Dbdesigner" in Toad also need map the relations manually. Regards, lasitha -Original Message- From: Instruct ICC [mailto:[EMAIL PROTECTED]

Re: [PHP-DB] PHP and MySQL design question

2007-10-22 Thread Theodoros Goltsios
I guess EXPLAIN will do the job for you. First of all in order to ensure what is the index used by your queries and then how to improve performance by making the right indexes. Theodoros Goltsios Kinetix Tele.com Support Center email: [EMAIL PROTECTED], [EMAIL PROTECTED] Tel. & Fax: +30 2310556