All geek questions in one place

Is CodeIgniter ActiveRecord Intensive?

Im encoding the application with server resources, so I do not want to use too much for this application to scale in the future. I do not mind writing my own queries. So, is ActiveRecord active for my application? Or does it not matter?

Thanks!

+4
source share
2 answers

CI ActiveRecord is basically not ActiveRecord , but Query Builder. It allows you to form simple queries in an object-oriented way. As with any abstraction, building from the state of an object to an SQL query is slower than hardcoding, but I suspect that the performance impact is negligible.

+5
source
  • For the basics website (blog) I think Active CI entries are perfect. I think it is always important to have a good database schema (normalize tables).
  • I believe that you could view the debug info. You should look at the SQL query that creates and searches for the module at the time the query was executed. It is always important to profile your inquiries. Don't just make assumptions.
  • I think it is more important to have opcode -cache and cache your sql queries in memory like apc / memcached / redis if possible.
+2
source

Source: https://habr.com/ru/post/1304620/

More articles:


All Articles