Submitted by jimspoon on 2022/03/11 13:49

I tried to load a grid and got the message that it has around 40k items, do I want to load only the first 1,000? 

I think in this particular grid most of the 40000 items that meet the filter are subitems, and that far fewer are TLIs.  I was thinking that maybe IQ wouldn't freeze in this case, and that only the TLIs might be shown and this wouldn't make IQ go non-responsive.  So I took a chance and clicked on "Load All Items".  IQ went "not responding".  I guess IQ loads all the items meeting the filter regardless of level and IQ can't load that many.

If I Ioad only the first 1000 out of 40000, then I'm missing of TLIs I want to drill through.

Is there a way to add a filter to the grid so it would load only TLIs initially, to avoid overloading IQ?  I don't see anything like this in the Grid Properties pane in the Manage Grids dialog.

 

 

Comments

I've been experimenting.  I confirmed that when you load a limited number of items rather than all items that meet the filter (default 1000), and then change the filter, the filter is run against all items in the Source field - not just those that were previously loaded.  Very good.  Also, any filter that you specify in the Source Bar filter box (and presumably any other filter) persists if you close the grid and reopen it.  Also very good.  This makes up for the fact that you can't see or change the filter from the Manage Grids dialog before you open it.

I need to do some more experimenting, but it seems that IQ can load many more items than the default 1000 without choking.  Maybe hardware dependent; but 24GB of RAM did not prevent IQ from choking on the 40,000 item grid.  Also I wonder if it makes a difference if you choose Flat List view rather than Outline or Tree View.  Will keep experimenting.

I experimented on my database which is now 33,000 items. I have 32gb ram. I took my testing grid, and changed the source filter to all items. This took 6 min 45 seconds to show all the items (6648), then another 4 minutes 50 seconds for show levels, all items (33088), So these weren't hangs, but it sure looked like it.

My largest grid shows less 7000 items when fully expanded, so I set the 1000 limit to 7500.  It takes that size grid around 30 seconds to expand to all levels.

I suspect there is some threshold where it does hang, maybe 40,000. 

I would love to have a manage grid option to open all items at level 1 for specific grids.

How do I ?