> > Consider sending queries to your middleware and having it respond in
> > XML for a great way to do better-than-SQL responses in some cases
> > (such as making 'group by' return every result, grouped into XML
> > sub-sections by the relevant field).
>
> Unless you care about performance.
We've actually had good success with this. Building an XML result
is not any (in terms of milliseconds) slower than sending the results raw
and compression on the line allows for fast transmission of the data
results. We had to design our own SQL-like query language to be
able to take advantage of some extras we wanted, like bringing down
the sub-values of various items, etc -- giving us multi-value results
from a relational set of tables ...
... I'm waiting to see if anyone else sees enough value in a generic
middleware system for it to get started as a project.
--
Michael T. Babcock
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php