A couple of ideas for you:
Experiment with doing the GROUP BY within your code.
Depending on a number of factors, it's sometimes faster.
Experiment with doing the ORDER BY within your code.
I've seen several cases where pulling the data into
memory and sorting there was much, much faster than
Christian Fritze [EMAIL PROTECTED] writes:
I'm working on a web based application (using gnuJSP / JDBC)
that needs to do queries like
SELECT count(textattrib1), text_cat(textattrib1 || ' '), func1(textattrib2)
FROM table1 WHERE textattrib2 = 'foo' GROUP BY textattrib2 ORDER BY