Depends on your thoughts is your db being shared by multiple apps or is your cfml app the app and db just the data store. If the former then store procedures may be the option in the db, if not there are some source control benefits of the logic being in the app as a Cfc dao layer.
My 2p A On Wednesday, 23 May 2012, Jason Allen <[email protected]> wrote: > Hi Guys, > I've ported my apps database from MS-SQL to mySQL and so far so good. > Since I've got most of my scripts working right, I'm now looking at the best way to create those scripts as a function. > ie createUser('username','firstname','lastname','email') rather than some spaghetti cfml that does it using 1,000 lines of code. > The adHoc scripts work fine, but I'm certain there is some performance to gain by building many of these functions into a CFC, or building it directly into the mySQL DBMS. > What's the best way? My first guess is that there's more to gain by doing it directly in the DBMS. Just call the db user defined function via CFQUERY and rather than spelling the sql code out, use the function. And I also wonder, that in the case of creating an API, having the functions directly in the DBMS might allow the API in some instances to bypass OpenBD altogether? > > Thoughts? > -Jason > > -- > online documentation: http://openbd.org/manual/ > http://groups.google.com/group/openbd?hl=en > -- Alex Skinner Managing Director Pixl8 Interactive Tel: +448452600726 Email: [email protected] Web: pixl8.co.uk -- online documentation: http://openbd.org/manual/ http://groups.google.com/group/openbd?hl=en
