Yeah, >From what i've seen whilst reading the documentation it simply writes all the laborious code for you, there is nothing to stop you modifying all those DAO's, Gateways and Stored Procs to optimize them afterwards, it just gives you a nice working model to start with. Like Terrence says, provided your database is built properly in the first place then I'm sure it'll run very efficiently. It doesnÂt look like the Reactor framework, its just a CFC generator by the look of things, I'll let you know how I get on with it.
Thanks, Rob -----Original Message----- From: Ryan, Terrence [mailto:[EMAIL PROTECTED] Sent: 04 June 2007 15:43 To: CF-Talk Subject: RE: Choosing an ORM Well.... When it generates the code it's not blazingly fast. A simple application takes about 5 seconds on my laptop, a more complicated one takes anywhere from 20 seconds to a minute. (On server class hardware it is obviously much faster.) But that's why it's a passive code generator, instead of an active one. However once the code is generated, it's executed pretty fast, assuming that the underlying table structures are properly indexed and whatnot. Even an improperly indexed table will be okay, at least for awhile. I typically see either 0 or 16ms for individual calls. Terrence Ryan Senior Systems Programmer Wharton Computing and Information Technology      E-mail:        [EMAIL PROTECTED] -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, June 04, 2007 10:08 AM To: CF-Talk Subject: RE: Choosing an ORM Certainly does look nifty..be good to see what kind of performance his it has though... -----Original Message----- From: Robert Rawlins - Think Blue [mailto:[EMAIL PROTECTED] Sent: 04 June 2007 14:40 To: CF-Talk Subject: RE: Choosing an ORM Thanks Terrance, I've not seen Squidhead before, but if it's as good as it sounds then It would be perfect for me, anything to avoid writing DAO code ;-) I'll have a look at it this afternoon, but it sounds fantastic, Rob -----Original Message----- From: Ryan, Terrence [mailto:[EMAIL PROTECTED] Sent: 04 June 2007 14:32 To: CF-Talk Subject: RE: Choosing an ORM I'm not going to jump in to Reactor vs Transfer. They're both great products. I wish I could use them. (We have a mandate for stored procs. ) But if you're looking to handle stored procedures, may I make a plug for my product, Squidhead (http://squidhead.riaforge.org/). It doesn't have hooks for any of the other frameworks yet, but it does implement the DAO and Gateway for a MSSQL database using stored procedures. And while it doesn't have any hooks for the frameworks, there's nothing to stop it from working with modelglue, or fusebox. In addition to writing its own CRUD in stored procs, it also reads in and makes available your stored procedures as CFC methods. It can handle multiple queries proc call, etc. Terrence Ryan Senior Systems Programmer Wharton Computing and Information Technology      E-mail:        [EMAIL PROTECTED] -----Original Message----- From: Robert Rawlins - Think Blue [mailto:[EMAIL PROTECTED] Sent: Monday, June 04, 2007 4:06 AM To: CF-Talk Subject: Choosing an ORM Hello Guys, I've just started work on a large scale rebuild of my core business application, and to aid me the gruelling task I'm toying with implementing MG, ColdSpring and one of the ORM's. I've done some small work with these in the past but used Reactor. Now, I'm sure I've read somewhere that Reactor and MG got a divorce, and that MG would most likely end up sleeping with Transfer, is this the case? Another thing to take into consideration is that I had planned to take all my queries and move them into stored procs on my SQL Server as some of them were getting pretty fat and needed a helping hand to keep performance where I want it, will I still be able to do this when working with an ORM? What are your thoughts on this stuff? What's hot? And what's not? Look forward to hearing from you guys, Rob ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280002 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
