[teiid-issues] [JBoss JIRA] (TEIID-3796) It is much more slow to get the table record through TEIID from postgresql DB

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-3796?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-3796.
-----------------------------------
    Resolution: Cannot Reproduce Bug


Tried a similar scenario locally and did not see the same behavior.  At the least you should try this without the fetchsize setting.  You could also try the select without fetching the text columns.  Please reopen if needed.

> It is much more slow to get the table record through TEIID from postgresql DB
> -----------------------------------------------------------------------------
>
>                 Key: TEIID-3796
>                 URL: https://issues.jboss.org/browse/TEIID-3796
>             Project: Teiid
>          Issue Type: Bug
>            Reporter: Xian Liu
>            Assignee: Steven Hawkins
>
> There is a table about 1000K+ record
> Postgresql Version: server 9.2.7
> Postgresql DB JDBC Driver Version: postgresql-9.3-1103.jdbc4.jar
> The table definition:
> {code}
>  |            Type             |                         Modifiers                          
> ------------+-----------------------------+------------------------------------------------------------
> | integer                     | not null
> | integer                     | 
> | integer                     | not null
> | timestamp without time zone | not null
> | integer                     | not null
> | text                        | 
> | text                        | 
> | bigint                      | 
> | bigint                      | not null 
> | integer                     | 
> {code}
> I set driver connection parameter to disableLocalTxn=true;FetchSize=10;
> 1. When I make this table available in Mysql, and select * from it in Teiid, It will quickly get the data stream after around 30s.
> 2. But when I make this table in Postgresql DB, and query through Teiid, it is so slow and will get about 8min+ client can not get the data stream, 
>  when I try to directly connect this table in Postgresql table, it is much more faster, I do not know the reason.



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)