[teiid-issues] [JBoss JIRA] (TEIID-3796) It is much more slow to get the table record through TEIID from postgresql DB
Xian Liu (JIRA)
issues at jboss.org
Fri Oct 30 05:15:00 EDT 2015
[ https://issues.jboss.org/browse/TEIID-3796?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Xian Liu updated TEIID-3796:
----------------------------
Description:
There is a table about 1000K+ record
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}
When I make it available in Teiid, and set driver connection parameter to disableLocalTxn=true;FetchSize=10; It will quickly get the data stream.
But when I make this in Postgresql DB, and query through Teiid, it is so slow and will get about 8min+, the client can not get the data stream, what's reason, when I try to directly connect postgresql, it is much more faster.
was:
There is a table about 1000K+ record
The table definition:
{code}
{code}
When I make it available in Teiid, and set driver connection parameter to disableLocalTxn=true;FetchSize=10; It will quickly get the data stream.
But when I make this in Postgresql DB, and query through Teiid, it is so slow and will get about 8min+, the client can not get the data stream, what's reason, when I try to directly connect postgresql, it is much more faster.
> 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: Feature Request
> Reporter: Xian Liu
> Assignee: Steven Hawkins
>
> There is a table about 1000K+ record
> 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}
> When I make it available in Teiid, and set driver connection parameter to disableLocalTxn=true;FetchSize=10; It will quickly get the data stream.
> But when I make this in Postgresql DB, and query through Teiid, it is so slow and will get about 8min+, the client can not get the data stream, what's reason, when I try to directly connect postgresql, it is much more faster.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
More information about the teiid-issues
mailing list