| # |
Oct 22nd 2009, 14:21 |
nicoleG |
between* |
| # |
Oct 22nd 2009, 14:21 |
markstory |
I hope you're not using old mssql, there is no limit/offset. |
| # |
Oct 22nd 2009, 14:21 |
nicoleG |
er |
| # |
Oct 22nd 2009, 14:21 |
nicoleG |
? |
| # |
Oct 22nd 2009, 14:21 |
nicoleG |
then i will just need to create the links to paginate below my data chunks/ |
| # |
Oct 22nd 2009, 14:20 |
cpierce |
will do the offset for you |
| # |
Oct 22nd 2009, 14:20 |
cpierce |
LIMIT 3, 30 |
| # |
Oct 22nd 2009, 14:20 |
nicoleG |
thank you |
| # |
Oct 22nd 2009, 14:20 |
nicoleG |
i will look in to it :) |
| # |
Oct 22nd 2009, 14:20 |
markstory |
its good stuff. |
| # |
Oct 22nd 2009, 14:20 |
nicoleG |
never used OFFSET |
| # |
Oct 22nd 2009, 14:20 |
joeb |
nicoleG: LIMIT and OFFSET |
| # |
Oct 22nd 2009, 14:20 |
nicoleG |
yes joeb |
| # |
Oct 22nd 2009, 14:19 |
nicoleG |
yeah markstory, that makes sense |
| # |
Oct 22nd 2009, 14:19 |
joeb |
nicoleG: But, it's coming from ->query() ? |
| # |
Oct 22nd 2009, 14:19 |
nicoleG |
basically yes joeb, that's what i have |
| # |
Oct 22nd 2009, 14:19 |
markstory |
you are loading 10 million rows into memory and then showing 20. |
| # |
Oct 22nd 2009, 14:19 |
joeb |
nicoleG: I thought you meant that you had some big static array that you wanted to essentially paginate through. |
| # |
Oct 22nd 2009, 14:19 |
markstory |
nicoleG: just think if you have 10million rows. |
| # |
Oct 22nd 2009, 14:19 |
nicoleG |
damn |
| # |
Oct 22nd 2009, 14:19 |
markstory |
generating html is free most times incomparison to quering and processing. |
| # |
Oct 22nd 2009, 14:19 |
joeb |
nicoleG: Oh, then yeah, array_slice != what you want. |
| # |
Oct 22nd 2009, 14:19 |
alan|macbook |
okaaaay... Back on track... |
| # |
Oct 22nd 2009, 14:18 |
nicoleG |
but i need to paginate the data still |
| # |
Oct 22nd 2009, 14:18 |
joeb |
Oh, yeah. I thought they meant for just some big array, how to get a chunk out. |
| # |
Oct 22nd 2009, 14:18 |
nicoleG |
markstory, i have a query that's not using model relationships |
| # |
Oct 22nd 2009, 14:18 |
markstory |
pagination is supposed to make the server load lighter. |
| # |
Oct 22nd 2009, 14:18 |
joeb |
markstory: ? |
| # |
Oct 22nd 2009, 14:18 |
nicoleG |
ok, thanks |
| # |
Oct 22nd 2009, 14:18 |
markstory |
but you are kind of missing the train on pagination if you use array slice. |
| # |
Oct 22nd 2009, 14:17 |
joeb |
nicoleG: array_slice. |
| # |
Oct 22nd 2009, 14:17 |
markstory |
nicoleG: no |
| # |
Oct 22nd 2009, 14:17 |
nicoleG |
can i use the paginate method to paginate an array that's not a model? |
| # |
Oct 22nd 2009, 14:17 |
ADmad |
yup just the url is surely not enough |
| # |
Oct 22nd 2009, 14:17 |
markstory |
well part of the problem is its impossible to write a userland helper that does what cache helper does. |
| # |
Oct 22nd 2009, 14:17 |
joeb |
My patch attempts to create a directory for the HTTP_HOST to store the cache files in. If it can't it just prepends the HTTP_HOST after it has been passed through Inflector::slug |
| # |
Oct 22nd 2009, 14:16 |
markstory |
unless you are doing a multisite thing there isn't much in /posts/view/4 that indicates what theme/view file should be used. |
| # |
Oct 22nd 2009, 14:16 |
ADmad |
so i guess it needs more refactoring to support caching of themed views |
| # |
Oct 22nd 2009, 14:16 |
ADmad |
hmm |
| # |
Oct 22nd 2009, 14:15 |
markstory |
ADmad: that is after the cache file has been picked. |
| # |
Oct 22nd 2009, 14:15 |
ADmad |
markstory: you can choose to run beforeFilter for cached pages too |