[JBoss JIRA] (ISPN-2454) The current SQL query that checks table existence is under optimized on big database
10:39 a.m.
Nicolas Filotto created ISPN-2454:
-------------------------------------
Summary: The current SQL query that checks table existence is under optimized
on big database
Key: ISPN-2454
URL: https://issues.jboss.org/browse/ISPN-2454
Project: Infinispan
Issue Type: Enhancement
Components: Loaders and Stores
Affects Versions: 5.1.0.FINAL
Reporter: Nicolas Filotto
Assignee: Mircea Markus
Last year I proposed an enhancement allowing to use the implicit db schema to ease life of
end-user, unfortunately it seems that it affects the startup time of the product when the
tables contain a lot of rows. Indeed the query can take several seconds to return a
result.
The idea of this task would be to optimize this query for all supported databases in order
to avoid this drawback.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:57 a.m.
[
https://issues.jboss.org/browse/ISPN-2454?page=com.atlassian.jira.plugin....
]
Nicolas Filotto updated ISPN-2454:
----------------------------------
Git Pull Request: https://github.com/infinispan/infinispan/pull/1439
The current SQL query that checks table existence is under optimized
on big database
------------------------------------------------------------------------------------
Key: ISPN-2454
URL: https://issues.jboss.org/browse/ISPN-2454
Project: Infinispan
Issue Type: Enhancement
Components: Loaders and Stores
Affects Versions: 5.1.0.FINAL
Reporter: Nicolas Filotto
Assignee: Mircea Markus
Last year I proposed an enhancement allowing to use the implicit db schema to ease life
of end-user, unfortunately it seems that it affects the startup time of the product when
the tables contain a lot of rows. Indeed the query can take several seconds to return a
result.
The idea of this task would be to optimize this query for all supported databases in
order to avoid this drawback.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
6:19 a.m.
[
https://issues.jboss.org/browse/ISPN-2454?page=com.atlassian.jira.plugin....
]
Mircea Markus updated ISPN-2454:
--------------------------------
Fix Version/s: 6.0.0.Final
The current SQL query that checks table existence is under optimized
on big database
------------------------------------------------------------------------------------
Key: ISPN-2454
URL: https://issues.jboss.org/browse/ISPN-2454
Project: Infinispan
Issue Type: Enhancement
Components: Loaders and Stores
Affects Versions: 5.1.0.FINAL
Reporter: Nicolas Filotto
Assignee: Mircea Markus
Fix For: 6.0.0.Final
Last year I proposed an enhancement allowing to use the implicit db schema to ease life
of end-user, unfortunately it seems that it affects the startup time of the product when
the tables contain a lot of rows. Indeed the query can take several seconds to return a
result.
The idea of this task would be to optimize this query for all supported databases in
order to avoid this drawback.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
6:02 a.m.
[
https://issues.jboss.org/browse/ISPN-2454?page=com.atlassian.jira.plugin....
]
Tristan Tarrant updated ISPN-2454:
----------------------------------
Fix Version/s: 5.2.0.CR1
(was: 6.0.0.Final)
The current SQL query that checks table existence is under optimized
on big database
------------------------------------------------------------------------------------
Key: ISPN-2454
URL: https://issues.jboss.org/browse/ISPN-2454
Project: Infinispan
Issue Type: Enhancement
Components: Loaders and Stores
Affects Versions: 5.1.0.FINAL
Reporter: Nicolas Filotto
Assignee: Mircea Markus
Fix For: 5.2.0.CR1
Last year I proposed an enhancement allowing to use the implicit db schema to ease life
of end-user, unfortunately it seems that it affects the startup time of the product when
the tables contain a lot of rows. Indeed the query can take several seconds to return a
result.
The idea of this task would be to optimize this query for all supported databases in
order to avoid this drawback.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
6:02 a.m.
[
https://issues.jboss.org/browse/ISPN-2454?page=com.atlassian.jira.plugin....
]
Tristan Tarrant updated ISPN-2454:
----------------------------------
Fix Version/s: 5.1.9.Final
The current SQL query that checks table existence is under optimized
on big database
------------------------------------------------------------------------------------
Key: ISPN-2454
URL: https://issues.jboss.org/browse/ISPN-2454
Project: Infinispan
Issue Type: Enhancement
Components: Loaders and Stores
Affects Versions: 5.1.0.FINAL
Reporter: Nicolas Filotto
Assignee: Mircea Markus
Fix For: 5.2.0.CR1, 5.1.9.Final
Last year I proposed an enhancement allowing to use the implicit db schema to ease life
of end-user, unfortunately it seems that it affects the startup time of the product when
the tables contain a lot of rows. Indeed the query can take several seconds to return a
result.
The idea of this task would be to optimize this query for all supported databases in
order to avoid this drawback.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
6:04 a.m.
[
https://issues.jboss.org/browse/ISPN-2454?page=com.atlassian.jira.plugin....
]
Tristan Tarrant updated ISPN-2454:
----------------------------------
Labels: jdg jdg6 (was: )
The current SQL query that checks table existence is under optimized
on big database
------------------------------------------------------------------------------------
Key: ISPN-2454
URL: https://issues.jboss.org/browse/ISPN-2454
Project: Infinispan
Issue Type: Enhancement
Components: Loaders and Stores
Affects Versions: 5.1.0.FINAL
Reporter: Nicolas Filotto
Assignee: Mircea Markus
Labels: jdg, jdg6
Fix For: 5.2.0.CR1, 5.1.9.Final
Last year I proposed an enhancement allowing to use the implicit db schema to ease life
of end-user, unfortunately it seems that it affects the startup time of the product when
the tables contain a lot of rows. Indeed the query can take several seconds to return a
result.
The idea of this task would be to optimize this query for all supported databases in
order to avoid this drawback.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
2:36 a.m.
[
https://issues.jboss.org/browse/ISPN-2454?page=com.atlassian.jira.plugin....
]
Mircea Markus updated ISPN-2454:
--------------------------------
Fix Version/s: 6.0.0.Final
(was: 5.1.9.Final)
(was: 5.2.0.CR1)
The current SQL query that checks table existence is under optimized
on big database
------------------------------------------------------------------------------------
Key: ISPN-2454
URL: https://issues.jboss.org/browse/ISPN-2454
Project: Infinispan
Issue Type: Enhancement
Components: Loaders and Stores
Affects Versions: 5.1.0.FINAL
Reporter: Nicolas Filotto
Assignee: Mircea Markus
Labels: jdg, jdg6
Fix For: 6.0.0.Final
Last year I proposed an enhancement allowing to use the implicit db schema to ease life
of end-user, unfortunately it seems that it affects the startup time of the product when
the tables contain a lot of rows. Indeed the query can take several seconds to return a
result.
The idea of this task would be to optimize this query for all supported databases in
order to avoid this drawback.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:20 a.m.
[
https://issues.jboss.org/browse/ISPN-2454?page=com.atlassian.jira.plugin....
]
Nicolas Filotto commented on ISPN-2454:
---------------------------------------
It seems that the Query for MS SQL doesn't work on MS SQL 2008 R2, it should be
{code}
SELECT count(*) from (SELECT TOP (1) 1 as C FROM " + tableName + ") T
{code}
The current SQL query that checks table existence is under optimized
on big database
------------------------------------------------------------------------------------
Key: ISPN-2454
URL: https://issues.jboss.org/browse/ISPN-2454
Project: Infinispan
Issue Type: Enhancement
Components: Loaders and Stores
Affects Versions: 5.1.0.FINAL
Reporter: Nicolas Filotto
Assignee: Mircea Markus
Labels: jdg, jdg6
Fix For: 6.0.0.Final
Last year I proposed an enhancement allowing to use the implicit db schema to ease life
of end-user, unfortunately it seems that it affects the startup time of the product when
the tables contain a lot of rows. Indeed the query can take several seconds to return a
result.
The idea of this task would be to optimize this query for all supported databases in
order to avoid this drawback.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
4420
days inactive
4440
days old
infinispan-issues@lists.jboss.org
7 comments
3 participants
participants (3)
-
Mircea Markus (JIRA) -
Nicolas Filotto (JIRA)
-
Tristan Tarrant (JIRA)