offtopic: Problem initialize MySQL DataSource for WebSphere App. Server 6

Hello, I have problem to configure MySQL datasource for WebSphere Application Server 6 (WAS6) from admin console. 1.) I have configured new JDBC Provider for MySQL (4.0.20a) as following: Name: MySQL JDBC Provider Class path:

Re[2]: Poor performance for SELECT from 50.000 records - MySQL PERFORMANCE TEST

Hello Brent, Thanks for your answer, I have try to use clause SQL_CALC_FOUND_ROWS within my SELECT query (and I also didn't use SELECT COUNT(*) ... query). But when I used SQL_CALC_FOUND_ROWS and then I retrieved number of all columns using SELECT FOUND_ROWS(), the performance was worse

Re[2]: Poor performance for SELECT from 50.000 records - MySQL PERFORMANCE TEST

Hello Mark, Thanks for your short response. I have checked it again. I have restarted MySQL first. When I executed command select SQL_CALC_FOUND_ROWS BF_USER.LOGIN_NAME, BF_USER.EMAIL, BF_USER.ID, BF_USER.MODIFICATION_DATE, BF_USER.SUPER_USER, BF_USER.GUEST_ACCESS_ENABLED,