paginate中count自定义
Posted
WillPaginate
数据量一大起来 select count(*)as count_all from TABLE 查询真耗性能。
mysql是一个好东西啊，有些业辑项还是用nosql跑起才行。
User.paginate :page=>1这么一句话将产生两条
User Load (1.5ms) SELECT * FROM users LIMIT 0, 30
SQL (56.3ms) SELECT count(*) AS count_all FROM users
自定义下count的sql吧。 count = User.find(:first,:select=>"count(id)as count").count
d=User.paginate :page=>1,:total_entries=> count
User Load (0.9ms) SELECT * FROM users LIMIT 0, 30
User Load (72.9ms) SELECT count(id)as count FROM users LIMIT 1
或者你又知道总数的话直接写一个30吧，当然非除你是佛主，把所有的问题想明白了。
d=User.paginate :page=>1,:total_entries=> 30
User Load (0.9ms) SELECT * FROM users LIMIT 0, 30
此文章 短链接: http://dlj.bz/Kzp3P1
Tag Cloud
AFNetworking(1)
AngularJS(2)
Devise(1)
Devops(1)
Homebrew(1)
MacOSX(11)
Rails4(2)
TTS(1)
Unauthorized(1)
analysis(1)
android(1)
apache(2)
api(1)
assets(5)
backup(3)
blog(1)
bower(1)
bundle(2)
cache(1)
capistrano(2)
capistrano3(2)
centos(4)
chrome-extension(1)
crontab(1)
css(1)
curl(1)
data(2)
deploy(2)
dlj(1)
dropbox(3)
elasticsearch(1)
fqa(1)
gem(7)
geobean(1)
gfw(1)
gis(1)
git(4)
github(2)
gitlib(1)
google(1)
httpd(1)
iOS(2)
java(1)
javascript(2)
jekyll(1)
js(2)
letsencrypt(1)
linode(2)
linux(16)
memcached(1)
mongodb(5)
mongoid(2)
mongomapper(1)
mtr(1)
mysql(2)
newrelic(1)
nginx(7)
nodejs(1)
notejs(1)
observer(1)
octopress(1)
omniauth-oauth(1)
openlayers(1)
paginate(2)
passenger(2)
pipeline(1)
plugin(2)
production(1)
proxy(3)
rails(23)
rails3(4)
rake(1)
restful_authentication(1)
ruby(28)
rvm(6)
search(1)
siege(1)
sinatra(2)
skill(7)
socks(1)
solr(1)
sql(2)
sqlserver(1)
ssh(6)
ssl(1)
story(4)
sublime-text(3)
sunspot(1)
sweeper(1)
theme(1)
tile(1)
tools(1)
ubuntu(19)
vagrantbox(2)
vps(2)
web(1)
webkit(1)
webpack(1)
win(3)
xcode(2)
yarn(1)
yum(1)
佛(3)
创业(1)
压力测试(2)
正则(1)
转载(7)