Greetings gurus,
I need a database solution that satisfies: 1: Custom-formated output from queries. 2: Custom functions integrated into queries.
Some implementations of XQuery with update facility might suite my needs. However, I'm unsure of their performance when it comes to thousands (and maybe millions) of records of various nesting depths.
Q1: How do they compare to SQL solutions in this matter ? Q2: Are there any relational/object-oriented database solutions that does 1 & 2 ?
Note: I don't want to iterate over SQL result sets and apply my custom formating and functions because that's two-phase process and very inefficient, i think.
What do you think ? Thank you !