| # |
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 |
| # |
Oct 22nd 2009, 14:15 |
joeb |
I was just using the HTTP_HOST variable. |
| # |
Oct 22nd 2009, 14:15 |
joeb |
Well, the Dispatcher doesn't know the theme yet though. |
| # |
Oct 22nd 2009, 14:15 |
ADmad |
generate cache keys/filenames based on selected theme ? |
| # |
Oct 22nd 2009, 14:14 |
markstory |
when the cache is read the code has no access to theme information. |
| # |
Oct 22nd 2009, 14:14 |
markstory |
how is cached views supposed to work with themes? |