Re: PostgreSQL, JDBC and BObj

On 10 September 2015 at 15:22, Keith Fisher <
keith(dot)fisher(at)edenhousesolutions(dot)co(dot)uk> wrote:

> Hi,
>
>
>
> 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.

--
regards Szymon Lipiński