[Troy Pearse]

Updated to the latest version and trying the interactive search but seems to be an issue with the search function or we are using it incorrectly. If I enter 3 letters of a keyword its almost instant, however If I enter a 4th letter it resets and takes over 2 minutes.

 

Also is there anyway to know if the asset cache has been fully updated to the new search system?

 

Kind Regards

 

Plugin version: 3.40.28
3ds Max version: 3dsmax 2023.3
Renderer: Corona

[Oleksandr Kramer]

Hello
Please generate the support request.
You can find this option in the main 3ds max menu “Project Manager” ⇒ Create Support Request.

[Oleksandr Kramer]

Thanks for data, that you sent.
Version 3.40.28 requires MySQL version 9.1.0. You currently use version 8.0.28. Using not recommended version may extremely slow down searching. Please update MySQL to the latest version.

Also, regex searching might be a bit slowly than other searching methods.
Just switch to another search method


…error when accidently entering incorrect characters into the searchbar…

This will be fixed soon.

Could you, please, also send the latest database dump from this directory
C:\Program Files\Autodesk\3ds Max 2023\scripts\Kstudio\ProjectManager_3\temp\databaseBackup

[Oleksandr Kramer]

Thanks for the dump! I hope that upgrading to the new MySQL version and switching to non-regex searching has already helped.

After upgrading, please double-check your MySQL settings.
For some reason, your current configuration deviates significantly from the defaults, and that can have a huge impact on search performance.
As a rule of thumb, you should leave settings at their defaults unless you truly need to change them—and understand exactly why.

Below is the recommended [mysqld] block you should apply:

[mysqld]
# InnoDB buffer — set to (128M):
innodb_buffer_pool_size = 128M

# Open table cache:
table_open_cache = 4000

# Read buffer size (if needed):
read_buffer_size = 131072

# Open file limit (will be read by the system):
open_files_limit = 10209

# InnoDB I/O bandwidth:
innodb_io_capacity = 10000
innodb_io_capacity_max = 20000

———–
Restart MySQL after changing settings