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
