Hi,
I've just ran a benchmark test to compare Innodb and MyISAM, and I just want some
input from you guys which already using Innodb ;-)
I have two tables : same definition and same records
Innodb table name : CUSTOMER
MyISAM table name : CUSTOMER2
and this is what I found on my queries :
- select * from CUSTOMER where CUST_ID like "%bing";
294 rows in set (56.46 sec)
select * from CUSTOMER2 where CUST_ID like "%bing";
294 rows in set (18.99 sec)
-
mysql> select count(*) from CUSTOMER;
+----------+
| count(*) |
+----------+
| 1673406 |
+----------+
1 row in set (7.37 sec)
mysql> select count(*) from CUSTOMER2;
+----------+
| count(*) |
+----------+
| 1673406 |
+----------+
1 row in set (0.01 sec)
-
mysql> update CUSTOMER set CUST_VALID_HP=1 where CUST_COUNTRY_CODE="ID";
Query OK, 228323 rows affected (1 min 11.72 sec)
Rows matched: 718424 Changed: 228323 Warnings: 0
mysql> update CUSTOMER2 set CUST_VALID_HP=1 where CUST_COUNTRY_CODE="ID";
Query OK, 228323 rows affected (1 min 49.11 sec)
Rows matched: 718424 Changed: 228323 Warnings: 0
Are these results normal ???? Is it true that "select" query on Innodb slower than on
MyISAM ?
What are the reasons ?
Thanks.
--
Don't patch bad code - rewrite it.
- The Elements of Programming Style (Kernighan & Plaugher)
MySQL 3.23.51 : up 74 days, Queries : 357.886 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan 12790
Phone : +62 21 79199577 - HP : +62 8551044244 - Web : http://www.1rstwap.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
