dev Posted July 20, 2008 Share Posted July 20, 2008 hi,i need experts openion. i am creating an online english to my language dictionary and i am using mysql to store all my data. for this i have created a table which contains over 9850 entries and there are 2000 more to be added later. i am using "Microsoft.XMLDOM" parser to collect data.everything is working fine however data collection has gone very slow.if i divide my database table and just enter 1000 entries per table than how will be the performance. or will it be the same as 9850 entries? how can i extract data faster?with thanksdev Link to comment Share on other sites More sharing options...
Synook Posted July 20, 2008 Share Posted July 20, 2008 Do you have an index defined?The way you structure your queries can also affect performance. Link to comment Share on other sites More sharing options...
dev Posted July 20, 2008 Author Share Posted July 20, 2008 Do you have an index defined?The way you structure your queries can also affect performance.i am using MySQL query browser v 1.2.8 beta provided by MySQL AB. from there i can see Indices = PRIMARY; Index type: BTREE and index column: IDID is set to auto inc. i am not that good in interpretating languages because i learn coding asp and designing database without theory class but from internet and books and examples. please elaborate a bit :)this is the sql structure:CREATE TABLE `com_dict`.`data` ( `ID` int(11) NOT NULL auto_increment, `english` varchar(200) default NULL, `abbr` varchar(100) default NULL, `kokborok` varchar(200) default NULL, `k_note` longtext, `e_note` longtext, `status` varchar(10) default '0', PRIMARY KEY (`ID`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;------------- running cmd -----mysql>EXPLAIN SELECT * FROM twipra_dict.data WHERE english='come';id | select_type | table | type | possible_keys | key | key_len | ref | rows | extra---------------------------------------------------1 | SIMPLE | data | ALL | NULL |NULL| NULL |NULL| 9619| Using where---------1 row in set (0.03 sec)----------- end run cmd -----this is the test result. is it ok? Link to comment Share on other sites More sharing options...
dev Posted July 20, 2008 Author Share Posted July 20, 2008 ah! i've index to english and see what happened---------mysql>EXPLAIN SELECT * FROM twipra_dict.data WHERE english='come';id | select_type | table | type | possible_keys | key | key_len | ref | rows | extra---------------------------------------------------1 | SIMPLE | data | ref | english | english | 203 | const | 1 | Using where---------1 row in set (0.00 sec)--------------bullseye Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.