Hey Fred,
I was thinking about if may be a stored procedure or trigger can help me to prepare the tables a little bit so that the selects will become faster/simpler.
Am I right that the way to access the database for a stored procedure is with a normal JDBC connection?
The second thing, are you handling each connection in it's own thread?
So may be if I can process some queries in different threads each with it's own connection I can gain a little bit performance.
Last but not least.
In your last response to the documentation issuse you said something about the TestSelf files. I want just write a small test to show how the union and other special selects working. From your point, is it good to write it as a TestSelf script or you would preffer it as a Java code?
Alex
