I use the standard sybase repository database. I have something that I have to finish and release to production first, then I'll do the upgrade.
Is there a best practice for the ports for my second config? Currently I use 2638 for sybase, 8080 for the server and 1099 for the RMI. How about naming the databases? I remember that I read in the forum that the repository db can be named repository_server_1, repository_server_2, etc. is that just to avoid confusion or could it pose a problem if they are all named the same (my assumption is that there will be different sybase instances running with the different ports - as you can probably tell I'm far from being an expert DBA
)? Furthermore, I assume that I should do a clean import of the solution with a different name and create a separate workspace.
As to my original problem. I queried all MySQL tables with the query you pointed out. A union over all tables came back within a fraction of a second. Also I never noticed that the DB was slow at all, I'm doing quite a lot of data analysis on the main database. Well, probably I have to just live with it for now and hope that everything works out fine again after the upgrades...
Thanks!