Pagination with sorting

Pagination with sorting

El Forum
Guest

#11

02-27-2009, 02:52 PM

[eluser]dmorin[/eluser]
Not sure I understand. Your query includes the join condition "LEFT JOIN `mech_reviews_cstm` mrc ON `mrc`.`userid_c` = `a`.`id` AND mrc.inactive_c = 1" so it should only be counting where mrc.userid_c = a.id already.

If MySQL is becoming unresponsive, it probably means that you're missing indexes on some columns that should have them.

Messages In This Thread

Pagination with sorting - by El Forum - 02-27-2009, 11:21 AM

Pagination with sorting - by El Forum - 02-27-2009, 11:39 AM

Pagination with sorting - by El Forum - 02-27-2009, 12:26 PM

Pagination with sorting - by El Forum - 02-27-2009, 12:48 PM

Pagination with sorting - by El Forum - 02-27-2009, 01:39 PM

Pagination with sorting - by El Forum - 02-27-2009, 01:54 PM

Pagination with sorting - by El Forum - 02-27-2009, 02:10 PM

Pagination with sorting - by El Forum - 02-27-2009, 02:19 PM

Pagination with sorting - by El Forum - 02-27-2009, 02:36 PM

Pagination with sorting - by El Forum - 02-27-2009, 02:47 PM

Pagination with sorting - by El Forum - 02-27-2009, 02:52 PM

Pagination with sorting - by El Forum - 02-27-2009, 02:58 PM

Pagination with sorting - by El Forum - 02-27-2009, 03:08 PM

Pagination with sorting - by El Forum - 02-27-2009, 03:16 PM

Pagination with sorting - by El Forum - 02-27-2009, 03:27 PM

Pagination with sorting - by El Forum - 02-27-2009, 03:28 PM

Pagination with sorting - by El Forum - 02-27-2009, 03:34 PM

Pagination with sorting - by El Forum - 02-27-2009, 03:40 PM

Pagination with sorting - by El Forum - 02-27-2009, 03:42 PM

Pagination with sorting - by El Forum - 02-27-2009, 03:52 PM

Pagination with sorting - by El Forum - 02-27-2009, 03:56 PM

Pagination with sorting - by El Forum - 02-27-2009, 03:58 PM

Pagination with sorting - by El Forum - 02-27-2009, 04:09 PM

Pagination with sorting - by El Forum - 02-27-2009, 04:43 PM

Pagination with sorting - by El Forum - 02-27-2009, 07:10 PM

Pagination with sorting - by El Forum - 02-27-2009, 07:29 PM

Pagination with sorting - by El Forum - 02-27-2009, 07:52 PM

Pagination with sorting - by El Forum - 02-27-2009, 08:00 PM

Pagination with sorting - by El Forum - 02-27-2009, 10:20 PM

Pagination with sorting - by El Forum - 02-28-2009, 09:38 AM