ColComboList slow under Windows 10

Posted by: bbunter on 16 September 2017, 8:35 am EST

  • Posted 16 September 2017, 8:35 am EST

    I have a ColComboList on my VSFleGrid (Version 8.0.20161.305) with 37,000 entries which is very responsive under windows 7.

    As the user types the correct item is selected almost instantly.

    The exact same code under windows 10 (I have tried several machines) gives a 3 or 4 second delay on the selection as the user is typing.

    For testing, if I reduce the number of entries the responsiveness gets better.

    37,000 entries - 3.5 seconds

    25,000 entries - 2.5 seconds

    15,000 entries - 2.0 seconds

    10,000 entries - 1.0 seconds

    5,000 entries - Almost instant

    I have tried light and DAO versions.

    I have also isolated the code in a new project with nothing else and it is still slow.

    What I don’t understand is why it worked great under windows 7.

    Any ideas?

    Mike

  • Posted 16 September 2017, 8:35 am EST

    I have done some more testing.

    On windows 7 with the full 37,000 entries it is instantaneous. As soon as you type anything the combo box displays the closest entry with zero delay.

    On windows 10 the delay is up to 4 seconds in the development environment and 2 seconds when compiled.

    However - if I click the drop down arrow, wait the 2-4 seconds for the data to appear and then start typing the selection is instantaneous as it was in windows 7.

    The same thing happens if I type the first character of the data, wait for it to appear, once is has appeared everything I then type is instantaneous.

    For completeness I have tried versions :

    8.0.20161.305

    8.0.20141.302

    8.0.20141.303

    8.0.20141.304

    8.0.20132.297

    8.0.20073.240

  • Posted 16 September 2017, 8:35 am EST

    Hi Mike,

    Thank you for sharing the detailed description of your problem. I understand that you are facing performance issue when it comes to adding 37000 entries in the ColComboList of VSFlexGrid. Please note, the latest version of VSFlexGrid, 8.0.20161.305, is compatible in Windows 10 environment. Therefore, you should not face any such problems.

    Can you please share the isolated project in which you were able to reproduce the problem? This would help me in escalating the problem to the concerned team, if needed.

    Thanks and Regards,

    Pragati Kaushik

  • Posted 16 September 2017, 8:36 am EST

    Hi,

    I have attached a very simple VB6 project connecting to MS SQL to get the records.

    Source and Catalog in the connection string will have to be changed.

    table.sql is the table design

    data.csv is obviously the data which can be imported into mssql via the import/export wizard - or you could bypass it all and just link the file.

    Mike

    2016/05/SampleCode.zip

  • Posted 16 September 2017, 8:36 am EST

    Hi Mike,

    I could see the problem using the application you shared. I will forward it to the concerned team and will let you know once they come back with any information on this.

    Thanks and Regards,

    Pragati Kaushik

  • Posted 3 May 2019, 9:02 pm EST - Updated 29 September 2022, 2:48 am EST

    Did this ever get resolved?

    Windows 10 is now the default windows operating system and I would like to move over to it.

    Mike

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels