Current filter:
                                You should refresh the page.
                                Support Center
                                0
                                  • Hellow.

                                    I'm created a DomainObject (Patient) in the XAF 9.1.4 version.

                                    The table in the existing database have 20 columns (3 Primary Key and some unique indexs), this contain 3.567.000 rows.

                                    When the application is started, the listview of patient get blocked.

                                    After created a ViewController (Attachtment). this controller create a FalseCriteria when the view its loading for first time, but when i write someting in the filter row, blocked again the application.

                                    What it's the best way or the best practice to doing or controller this large data.

                                    Im read some post, but, anything cant help me.

                                    I appreciate your answers as soon as possible.

                                    Thanks

                                AutoFilterController.cs
                                0

                                Hello,

                                Thanks for contacting us. I have examined your controller, and I suggest you remove it at all. You should not apply the criteria from the ColumnView.ActiveFilter to the CollectionSource.
                                The ActiveFilter is used to filter retrieved data on the client, while the CollectionSource's Criteria property is used to filter data on the server.
                                Without your controller, the client filtering will work as your needs dictate. This is the default feature of the XtraGrid.

                                In addition, I suggest you enable the Server Mode in your list view. This will greatly increase performance when working with such large data sets like yours. To do this in XAF, set the UseServerMode attribute in the Model Editor.
                                Please let me know in case of any difficulty.

                                IMPORTANT NOTE
                                Please be aware of this bug: Server mode doesn't work in Windows Forms

                                Thanks,
                                Dennis

                                0

                                Thanks for your reply.

                                The problen in windows form persist.

                                First, I remove the controller from the project and change ServerMode attribute to True.
                                Then I update the version of XAF from http://downloads.devexpress.com/Share/XAF/090527/eXpressAppFramework-9.1.4.9147.exe
                                and I try again.

                                In Web, work perfect.
                                But in Windows Form, show an error (Attachtment-Pic ServerMode.jpg) and I don't know what can I do.

                                Thanks

                                Pic ServerMode.jpg
                                0

                                Hello Luz,

                                Thanks for the feedback. According to your picture, something went very wrong. Could you please prepare a small working sample containing the class for whose list view the error occurs. We will be glad to research it internally, and tell you what's wrong here.
                                I am looking forward to hearing from you.

                                Thanks,
                                Dennis

                                0

                                Hello. Thanks for your answer.

                                Look the attachtment.

                                Let me know if you need aditional information...

                                Thanks A lot.

                                IMPORTANT NOTE.
                                The DB Engine its Oracle.
                                The table, have 3.567.000 rows.
                                The files of the project, are read-Only, because the SorceSafe controller.

                                ConceptFacardet.zip
                                0

                                Hello,

                                Thanks for the sample. I have checked your IVDRO class and found the cause of the problem. The fact is that this class has a compound key, but according to the Server Mode Limitations document where the limitations of the Server Mode are described, the Server Mode doesn't work for such tables. This behavior is by design.

                                So, to avoid performance problems, we suggest you do not load all these millions of records at once. Filter your data source, and work with less data. Please let me know if I can help you further.

                                See Also:
                                Filter List Views

                                Thanks,
                                Dennis

                                0

                                Hello, thanks for your reply. But I have some questions.

                                The table belongs to the exist model. So, the primary key, is required to migration process, trying to don‘t doing any change in database, because I’m working in a concept test, to do a migration.

                                I'm creating another test, with another table design, where the primary key is not composed, its a OID generated by the BaseObject, the table have 2001 rows, and the time to load all data its approximately 20 sec (very slow). The Data Base is installed in the local machine in Sql Server 2008. So I try to work with another table that contains 570.000 rows, "the primary key it‘s a OID" and then retrieve data in 30 sec approximately. but the application don‘t response good, its so slow...

                                By the business rules, I need show all information, because, it‘s the history of multiple patients (Health Business), and its so much information.... So, the application of filters for the deployment of information in some cases is not appropriate.

                                ¿ Its possible include this support (Server Mode doesn't work for such tables) in features version or its required implement Filters always?

                                ¿ Can you please, Show any example where use dynamics filters or create criteria in Runtime with some rules. ?

                                Thanks for all ...

                                0

                                Hello,

                                Sorry for the delay in responding.
                                >>
                                I'm creating another test, with another table design, where the primary key is not composed, its a OID generated by the BaseObject, the table have 2001 rows, and the time to load all data its approximately 20 sec (very slow). The Data Base is installed in the local machine in Sql Server 2008. So I try to work with another table that contains 570.000 rows, "the primary key it‘s a OID" and then retrieve data in 30 sec approximately. but the application don‘t response good, its so slow...
                                <<
                                I cannot reproduce this problem in my tests. Attached is my test application, and if you run it, the list view will be opened in less than one second. Take special note of the WinSolution.Module\Updater.cs file.

                                1. No, it is not possible. We already discussed this with our XPO developers in the past.
                                2. Above, I gave you the link to the XAF documentation, showing how to filter list view at runtime.

                                Please let me know in case of any difficulty.

                                Thanks,
                                Dennis

                                dxSampleQ209179.zip

                                If you need additional product information, write to us at info@devexpress.com or call us at +1 (818) 844-3383

                                FOLLOW US

                                DevExpress engineers feature-complete Presentation Controls, IDE Productivity Tools, Business Application Frameworks, and Reporting Systems for Visual Studio, along with high-performance HTML JS Mobile Frameworks for developers targeting iOS, Android and Windows Phone. Whether using WPF, Silverlight, ASP.NET, WinForms, HTML5 or Windows 8, DevExpress tools help you build and deliver your best in the shortest time possible.

                                Copyright © 1998-2014 Developer Express Inc.
                                All trademarks or registered trademarks are property of their respective owners