rails3 - 这是更好的code性能 [英] rails3 - which is better code for performance

问题描述

这是最好的做法，给了我更好的性能？

Which is the best practise and gives me better performance ?

例如：

我的状态表，它有5个记录，每个记录必须在不同的变量存储区。

I have statuses table which have 5 records and each record need to be store on separate variable.

方法一：

@new_status = Status.find_by_status("NEW")
@inprocess_status = Status.find_by_status("InProcess")
@completed_status = Status.find_by_status("Completed")
@occupied_status = Status.find_by_status("Occupied")
@success_status = Status.find_by_status("Success")

方法二：

statuses = Status.all
@new_status = statuses.find {|status| status.status == "NEW"}
@inprocess_status = statuses.find {|status| status.status == "InProcess"}
@completed_status = statuses.find {|status| status.status == "Completed"}
@occupied_status = statuses.find {|status| status.status == "Occupied"}
@success_status = statuses.find {|status| status.status == "Success"}

或者电气特性的好方法？

Or anyother good way ?

推荐答案

这将更加高性能的，因为它不仅使一个查询到数据库并获取数据，只有必要的量。这是假设状态域是唯一的。

This will be even more performant, as it only makes one query to the db and gets only the necessary amount of data. This is assuming status field is unique.

statuses = Status.where(
  status: ['NEW', 'InProcess', 'Completed', 'Occupied', 'Success']
).order(:status)

@new_status, @completed_status, @inprocess_status, @occupied_status, @success_status = statuses

这篇关于rails3 - 这是更好的code性能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！