Question about ColdFusion ORM
We have been using ColdFusion 9 for the last 6 months, and although we have used some of the new features, ORM is something we avoided because we usually run on one very large website. Over the years, we used Apache OBJ, but then we went back to CF and used our own DAO objects created from tables to handle basic CRUD. These objects are basic and must be regenerated manually to change the schema and not model relationships between tables at all. In addition to these, we have a set of gateway classes for queries with multiple tables. Although all this is very intrusive, these DAOs and gateways nevertheless give us excellent control over SQL, which we perform, for example, using hints for locking and hints of the optimizer. Our site is busy, but our database is very efficient.
So much for a history lesson: the bottom line is that we will soon have a new site that will be written from scratch to process financial transactions. Normally, we would use our aforementioned DAO objects to handle CRUD, and then a regular set of gateway objects for joining multiple tables, but I thought we could explore using baked CF ORM ...
Therefore, keeping in mind, I would like to hear about lessons, tips and tricks that others might have to divide by using ORM on a busy financial site. For instance:
What is the best way to clear your SQL? What tips do you have for transactional ORM? How do you set up development and live sites for ORM? What about HQL? When should we just do the SQL ourselves manually ?!
Thanks in advance!