I am trying to use a JDBC connection (driver version PostgreSQL 9.1 JDBC4 (build 903) to connect to a PostgreSQL 9 database. I am using SAP BusinessObjects 4.1 SP2 to build a universe over the database.
The connection is working ok but is really slow.
I don’t have any direct access to the database, but the developer who is supporting me says the sql run directly against the database is quick and has no issues.
The main table that seems to cause issues has 250+ columns, but only 52,400 rows.
Has anyone got experience of running BOBJ and PostgreSQL, and of tuning the connection for speed? I can add Java memory to the universe designer application and to the services that run SQL but so far this doesn’t seem to have helped.
Keith Fisher
Hi
What was run directly at the database server? The same query? Just explain? Or maybe explain analyze? If there was the same query, was it downloading exactly the same data from the database server, or there were just limits added?
Try running explain analyze to see what is the plan for executing the query.
Another problem could be that the query is rather fast, however downloading the data is slow. If each column has on average about 20B of data, then the whole table has about 250MB. Downloading all the data can be much slower than downloading just a couple of rows.