Skip to Main Content

Java SE (Java Platform, Standard Edition)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Need to extend ListView into a GridView

242977c8-2f73-42e0-b282-1039cc5e47eaJan 29 2020 — edited Jan 29 2020

To display thousands of thumbnails efficiently, you can't use TilePane, because it is way too slow. You need to use a virtualized control like ListView, which displays very fast and supports multi-select, which is great. But it only displays in one column or one row rather than in a grid. What is needed is a GridView that wraps like TilePane, but is a virtualized control that is fast like ListView.

There is an open source GridView at https://controlsfx.bitbucket.io/org/controlsfx/control/GridView.html , but this is such a common need that it would be good for this to be part of the core JavaFX. Also, that open-source version doesn't support multi-select the way ListView does.

See a discussion on StackExchange for working code examples to demonstrate the slowness of TilePane, the speed of ListView, and a working GridView.

Comments

Gaz in Oz

Why are you using such an old version of mysql?

Why are you reading 5.7 documentation that may not be relevant to your old 5.1 db?

Are you using

. MyISAM

. InnoDB

Why don't you try it for yourself on a small table first and see how long it takes, what actions are carried out to rename it?

Alexandre Almeida
Answer

Hi there,

Actually, it depends on the table's storage engine. Renaming a MyISAM table is quite simple, the files (.frm, .MYI and .MYD) are simple renamed. Now, if your tables are innodb, it's a little bit more complex because data dictionary must be changed also. Starting MySQL 5.1 we got the variable innodb_file_per_table. If this variable is set as 0 your data resides inside shared table space (aka ibdata) and renaming table will cause no pages move. If innodb_file_per_table is set to 1, the your_file_table.ibd and your_file_table.frm will be renamed.

Anyways, renaming table won't copy table and won't cause any panic I/O.

Cheers,

Marked as Answer by 3410558 · Sep 27 2020
1 - 2

Post Details

Added on Jan 29 2020
0 comments
209 views