slow global search

[LucianaCabrera]

Code of Conduct

• I agree to follow this project's Code of Conduct

Is there an existing issue for this?

• I have searched the existing issues

Version

10.0.16 - 10.0.17

Bug description

Every time a global search is done at the beginning it loads and a white screen appears, if I disconnect from the glpi the page reloads

Relevant log output

Page URL

No response

Steps To reproduce

No response

Your GLPI setup information

No response

Anything else?

No response

[LucianaCabrera]

CREATE INDEX idx_softwareversions_join_columns ON glpi_softwareversions (arch, name, softwares_id, operatingsystems_id, id);

apply this and it could make it a lot easier

[stonebuzz]

Hi @LucianaCabrera

During our discussions, we noticed that this query took 6.428 seconds to execute. We are currently evaluating the integration of this index and would appreciate your feedback on this matter. However, we have some concerns regarding the time required to apply it across various GLPI installations worldwide.

To better analyze the impact of this integration, could you please provide details about your infrastructure, including:

• Hosting type: VM, physical server, cloud, etc.
• Storage: SSD or HDD
• Hardware configuration: number of processors, RAM
• Available disk space for the operating system and database
• Database version: MariaDB or MySQL
• Any other relevant information that could assist in this analysis.

Thank you again for your feedback, which is helping us with this part.

[LucianaCabrera]

Hi pierre @stonebuzz , of course here i leave you the data:

Server physical
SSD
12cpus
ram 15gb
mariadb 10.11.6
debia 12
UEFI

[stonebuzz]

Thank you for your feedback👍 stay tuned , thanks again for your feedback, this is how the word 'community' comes into its own .

Best regards