Hi Maria, I just did a test with 50.000 records and 12 columns (data that comes from the server side) - no way standard DataGrid can handle this. It took about 2 seconds to load the data on Apache Royale and loaded in the VirtualDataGrid instantly.
For this test I used: 1. SimpleRemoteObject (I don't use the mx version); 2. Standard VirtualDataGrid and DataGridColumn from the SDK (without any customization on my side); 3. No special beads. The changes/new beads that I made in the DataGrid this weekend were not tested yet with VirtualDataGrid. Check if it is a server side issue and test without any customization of the DataGrid or columns on your side or special beads. Regards, Hugo. Hugo Ferreira <[email protected]> escreveu no dia segunda, 22/11/2021 à(s) 12:26: > Hi Maria, > > I understand. > Languages it's also difficult for me. > First I write in English and then translate to my language on google > translator (if the translation it's not acceptable, I try to fix or change > the sentence). > > I also tested in 2020 (my first real contact with Apache Royale with > Jewel). > I tested every component that I need and exists in the Tour de Jewel to > see if Royale it's in a state to start with. > > The DataGrid totally failed because it took minutes to render a medium > size ArrayList. > Most of my DataGrids are small and a normal DataGrid it's OK however I > have a few use cases with giant DataGrids and changing to pagination would > be a step back. > > I saw the VirtualList and started (with Carlos help) the VirtualDataGrid > version. > When finished, I tested with a huge ArrayList and the render > was instantaneous no matter the size of the ArrayList (by the way, I tested > with ArrayListView). > > Since then I was away for other priorities with my Flex application and > now I'm back for good. > I started with something that not requires a VirtualDataGrid but I can do > a new test, however if you see the Tour de Jewel, you have a living sample > with only 2 columns but 2000 records that loads instantly: > https://royale.apache.org/tourdejewel/#!virtual_lists_panel > > For 2000 records and 2 columns, must work otherwise there is a new bug or > you could have a performance issue before the DataGrid. > > Maria Jose Esteve <[email protected]> escreveu no dia segunda, 22/11/2021 > à(s) 11:58: > >> I have not explained myself well... forgive me because I translate with >> the deepltranslate ☹. >> I did a whole battery of tests with the DataGrid, VirtualDataGrid, >> ComoboBox, VirtualComboBox, List and VirtualList. Indeed with the "Virtual" >> there is no problem with the number of records but "at that time", when I >> tested them, there were other added problems that prevented me from using >> them. I also recognize you that "I have learned something in almost two >> years working with Royale-Jewel" and, perhaps, if I would try it again >> now.... 😝 >> >> Hiedra. >> >> -----Mensaje original----- >> De: Hugo Ferreira <[email protected]> >> Enviado el: lunes, 22 de noviembre de 2021 11:51 >> Para: Apache Royale Development <[email protected]> >> Asunto: Re: New bead to allow Jewel DataGrid to have locked columns >> >> Maria, >> >> This is with the standard DataGrid. >> Try the VirtualDataGrid version (there is a visual issue with the scroll >> that we should address later) and you will see the difference. >> The size of the ArrayList does not matter anymore. >> >> >> >> Maria Jose Esteve <[email protected]> escreveu no dia segunda, 22/11/2021 >> à(s) 10:42: >> >> > Jajajjaj "1000 records and 70 columns"????????? the DataGrid??????? >> > Well, I must have done something very wrong, because for me 100 >> > registrations took me 6 seconds... 😝 >> > >> > >> > >> > >> > >> > -----Mensaje original----- >> > De: Hugo Ferreira >> > <[email protected]<mailto:[email protected]>> >> > Enviado el: lunes, 22 de noviembre de 2021 11:04 >> > Para: Apache Royale Development <[email protected]<mailto: >> > [email protected]>> >> > Asunto: Re: New bead to allow Jewel DataGrid to have locked columns >> > >> > >> > >> > The VirtualList exists and VirtualDataGrid also already exists: >> > >> > https://royale.apache.org/tourdejewel/#!virtual_lists_panel >> > >> > Before that, I also did a test and normal DataGrid it's not up to big >> data. >> > >> > Now you can use 1000 records and 70 column without pagination. >> > >> > >> > >> > Maria Jose Esteve <[email protected]<mailto:[email protected]>> >> > escreveu no dia segunda, 22/11/2021 >> > >> > à(s) 09:58: >> > >> > >> > >> > > The VirtualDataGrid would be the best option because in the battery >> > > of >> > >> > > tests that I did the DataGrid, with 7 columns and 100 records took a >> > >> > > long time to render. This also happens with the Jewel List, to >> > >> > > minimize the impact I paginated the results and so everything works >> > > as >> > expected. >> > >> > > >> > >> > > DevExpress DataGrid has a good front-end, I have not worked with it, >> > >> > > but from my experience with other JS components (Virtual-Select or >> > > the >> > >> > > Inspire-Tree) it is usually complicated to customize the renderers, >> > >> > > although I am convinced that with extensive knowledge in JS this >> > > could >> > >> > > be saved. >> > >> > > >> > >> > > Thanks for sharing your work Hugo. >> > >> > > If I can help you with the examples let me know. >> > >> > > >> > >> > > Hiedra. >> > >> > > >> > >> > > -----Mensaje original----- >> > >> > > De: Hugo Ferreira >> > > <[email protected]<mailto:[email protected]>> >> > Enviado el: lunes, 22 de >> > >> > > noviembre de 2021 10:41 >> > >> > > Para: Apache Royale Development <[email protected]<mailto: >> > [email protected]>> >> > >> > > Asunto: Re: New bead to allow Jewel DataGrid to have locked columns >> > >> > > >> > >> > > Hi Hiedra, >> > >> > > >> > >> > > Yes, a DataGrid is always the most complex and features demanding on >> > >> > > any "layout language". >> > >> > > As we came from Flex to Royale we are specially demanding on these >> > >> > > little but important features. >> > >> > > When I first seriously tested Royale, it was with Jewel and DataGrid >> > >> > > seems to be basic. >> > >> > > Since then it has grown with the VirtualDataGrid variant (we still >> > >> > > have a scrollbar bar visibility issue but I will try to fix when I >> > >> > > will use it) and now a few new beads this weekend. >> > >> > > My DataGrid also is hardcoded with code for an easier edit mode that >> > > I >> > >> > > hope to delegate and commit as a bead. >> > >> > > >> > >> > > I don't see how to replace a DataGrid that requires editing with a >> > >> > > simple List. >> > >> > > >> > >> > > On the other hand, I saw recently here in the mailing list a >> > >> > > possibility (in progress) to use DevExpress DataGrid and seems a >> > >> > > fantastic advanced DataGrid. >> > >> > > I just don't know if it is easier to implement item renderer with >> > >> > > Royale components that we can control. Let's find out later. >> > >> > > >> > >> > > I didn't thought about TDJ examples. >> > >> > > I will try to find time to do that. >> > >> > > >> > >> > > Maria Jose Esteve <[email protected]<mailto:[email protected]>> >> > escreveu no dia segunda, >> > >> > > 22/11/2021 >> > >> > > à(s) 09:18: >> > >> > > >> > >> > > > Hi, >> > >> > > > I don't use Jewel DataGrid, I use Jewel List because until not >> > > > long >> > >> > > > ago the DataGrid didn't work as I required. Do you plan to set up >> > >> > > > some example in TDJ of all these modifications? >> > >> > > > >> > >> > > > Thx. >> > >> > > > Hiedra >> > >> > > > >> > >> > > > -----Mensaje original----- >> > >> > > > De: Hugo Ferreira <[email protected]<mailto: >> > [email protected]>> Enviado el: domingo, 21 >> > >> > > > de noviembre de 2021 12:08 >> > >> > > > Para: Apache Royale Development <[email protected]<mailto: >> > [email protected]>> >> > >> > > > Asunto: New bead to allow Jewel DataGrid to have locked columns >> > >> > > > >> > >> > > > Hi, >> > >> > > > >> > >> > > > I just commited a new bead to Jewel DataGrid, to work similar to >> > >> > > > lockedColumnCount property of Flex DataGrid. >> > >> > > > This new bead was tested in combination with the recent bead to >> > > > lock >> > >> > > > the entire header (when it is inside of a group with scroll), so >> > > > we >> > >> > > > can have a full floating grid with the entire locked header on top >> > >> > > > and a portion of columns (and header) fixed on the left side. >> > >> > > > >> > >> > > > Regards, >> > >> > > > Hugo. >> > >> > > > >> > >> > > >> > >> >
