You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2021/03/09 11:29:51 UTC
[GitHub] [shardingsphere] terrymanu opened a new issue #9617: Load columns for all tables into metadata
terrymanu opened a new issue #9617:
URL: https://github.com/apache/shardingsphere/issues/9617
We load rules configured tables into metadata with columns and table name only for un-configured tables now.
By product design, it is necessary to load all columns for every table.
Load all columns are too slow if using raw JDBC interface. We should create a new SPI for quickly load columns via raw database way, such as load metadata via `information_schema` for MySQL.
The tasks are: #9615
- [ ] Create SPI for load metadata with native database dialect
- [ ] Load all columns for default JDBC loader
- [ ] Add MySQL dialect
- [ ] Add PostgreSQL dialect
- [ ] Add SQLServer dialect
- [ ] Add Oracle dialect
Some issues are related with imperfect metadata, there are: #
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] totalo commented on issue #9617: Load columns for all tables into metadata
Posted by GitBox <gi...@apache.org>.
totalo commented on issue #9617:
URL: https://github.com/apache/shardingsphere/issues/9617#issuecomment-800192509
Hi, I'd like to try SQLServer dialect.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] terrymanu closed issue #9617: Load columns for all tables into metadata
Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #9617:
URL: https://github.com/apache/shardingsphere/issues/9617
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] sandynz commented on issue #9617: Load columns for all tables into metadata
Posted by GitBox <gi...@apache.org>.
sandynz commented on issue #9617:
URL: https://github.com/apache/shardingsphere/issues/9617#issuecomment-797383146
Hi, I'd like to try PostgreSQL dialect.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] wordKuaiLei commented on issue #9617: Load columns for all tables into metadata
Posted by GitBox <gi...@apache.org>.
wordKuaiLei commented on issue #9617:
URL: https://github.com/apache/shardingsphere/issues/9617#issuecomment-797563972
Hi, I'd like to try index metadata loading for MySQL dialect.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] neil4dong commented on issue #9617: Load columns for all tables into metadata
Posted by GitBox <gi...@apache.org>.
neil4dong commented on issue #9617:
URL: https://github.com/apache/shardingsphere/issues/9617#issuecomment-799059251
Is it possible to load metadata concurrently? when the amount of table is huge ex. 1000+ tables, loading meatedata
be come really slow. @terrymanu
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] zhujunxxxxx commented on issue #9617: Load columns for all tables into metadata
Posted by GitBox <gi...@apache.org>.
zhujunxxxxx commented on issue #9617:
URL: https://github.com/apache/shardingsphere/issues/9617#issuecomment-799899612
Hi, I'd like to try H2 dialect.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] Liangda-w commented on issue #9617: Load columns for all tables into metadata
Posted by GitBox <gi...@apache.org>.
Liangda-w commented on issue #9617:
URL: https://github.com/apache/shardingsphere/issues/9617#issuecomment-803211938
Hi, I would like to try add Oracle dialect:)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] zhujunxxxxx commented on issue #9617: Load columns for all tables into metadata
Posted by GitBox <gi...@apache.org>.
zhujunxxxxx commented on issue #9617:
URL: https://github.com/apache/shardingsphere/issues/9617#issuecomment-799900587
I just finished optimizing this metadata load and you raised an ISSUE
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] terrymanu commented on issue #9617: Load columns for all tables into metadata
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #9617:
URL: https://github.com/apache/shardingsphere/issues/9617#issuecomment-799079372
> Is it possible to load metadata concurrently? when the amount of table is huge ex. 1000+ tables, loading meatedata
> be come really slow. @terrymanu
It has already load meta data concurrently
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] terrymanu commented on issue #9617: Load columns for all tables into metadata
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #9617:
URL: https://github.com/apache/shardingsphere/issues/9617#issuecomment-800808149
Cool,I just assign to you
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org