Pagination with sorting

Pagination with sorting

El Forum
Guest

#26

02-27-2009, 07:29 PM

[eluser]spyro[/eluser]
[quote author="dmorin" date="1235805055"]Glad to see you got it working, but I would be VERY careful with the one that did work for you. Doing a query in the select means you're doing individual queries for each record returned. While it might work and be sufficient with a minimal number of rows, it almost certainly won't scale to larger data sets.

If it's good for now, then good, but definitely keep that in the back of your mind if/when you run into performance issues.[/quote]

If that is the case then I would also like to see it work with the join instead of the subquery. That way I can run some queries and see the performance difference. I just couldn't get the join to give me the correct number of rows and wasn't sure why.

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