Is ActiveRecord resource intensive?

[eluser]iamdadude[/eluser]
I'm coding an application with server resources in mind, so I don't want to use too much so that this application scales in the future. I don't mind writing my own queries. So, is ActiveRecord resource intensive for my application? Or does it not make a difference?

Thanks!