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,
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 than