|
|
Thanks, it's much as I figured but fwiw, with my (albeit limited) knowledge of
sql I'd rather write <cfqueries> and even stored procs. As you say, they are
more complex in theory but IMHO much better for implementing an MVC type of
architecture/organization (not that I am expert in either).
I did think that stored proc offer performance benefits vs. ad hoc sql but
perhaps this is more to do with the sql tranaction being pre-compiled vs it
being cached (now that I think about it -- though I might be mislabelling some
of the terms.)
Thanks again though
|
|