You might be able to use a stored procedure or a trigger for that but I think it would be far too complicated.
Database access from a stored procedure is done with a JDBC connection. We handle the execution of SQL from all connection in the same thread. Triggers use different threads. You should be aiming at very big performance improvements using UNION and other set queries, rather than small improvements. The easiest way to write SQL tests is via TestSelf files. Use one of the smaller files, such as TestSelfCreate.txt and write all your sql there. Each time you run the TestSelf, all the sql that you have added to that file will be executed and if you put the special markers at the beginning of the SQL commands that you want to verify, it will verify and print an error if the result doesn't match. The next step in improving the TestSelf framework is to allow new TestSelf*.txt files to be added, so that all the TestSelf*.txt files that are found are tested. Fred Toussi ------------- Alex wrote: 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 ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ hsqldb-developers mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
