Hello everyone.
I'm working on migrating Oracle to MySQL 4.0.3
MySQL works on Redhat 7.3 and Pentium IIII 550Mhz with 256 Mb RAM.
Our application need Transactions, so I decided to use InnoDB.
But, InnoDB is slower than I expected.
-------------------------------------------------
mysql> SELECT COUNT(*) FROM table_name ;
+----------+
| COUNT(*) |
+----------+
| 903097 |
+----------+
1 row in set (8.07 sec)
-------------------------------------------------
8.07 sec. took to retrieve 903,097 rows. That's OK, faster than Oracle.
But, LIMITing records make problem.
-------------------------------------------------
mysql> SELECT * FROM table_name LIMIT 100000, 10 ;
..
..
10 rows in set (3.95 sec)
--------------------------------------------------
This result is normal one? Is there any way to improve perfermance?
I thought one way.
--------------------------------------------------
ROW = SELECT Primary key FROM table_name LIMIT 100000, 10;
WHILE( ! no_more_row )
{
Fetch record WHERE Primary key = ROW.Primary key ;
}
--------------------------------------------------
This can help?
In Oracle
---------------------------------------------------
SQL> SELECT A.* FROM ( SELECT rownum as rnum, B.* FROM table_name B ) A
2 where rnum >= 100000 and rownum <= 10 ;
Elapsed: 00:00:01.20
----------------------------------------------------
Just 1.20 Sec. took.
Thank you for advanced Answer!
##########################
Heo, Jungsu Mr.
SimpleX Internet. http://www.simplexi.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 <mysql-unsubscribe-##L=##[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
