Performance issues

[acroporax]

Hi All,
I have performace issues. When logging in and querying forms.How can i solve?

[kev1n]

Performance issues can depend on various factors, so we'll need more details to help. Right now, it's a bit like saying, *"My car is slow, tell me why,"* without knowing the brand, engine, or any details.

Could you provide more information? For example:
- Does this happen for all forms or specific ones?
- How much data is being loaded?
- What MySQL and PHP versions are you using?
- Did the issue just start after a recent change?

With more details, we can better identify potential causes and solutions.

[acroporax]

ok,
1- User logon time 14 second.(For All Standart Users) GlobeAdmin logon time 1 second.
2- problem applied for all users,As the number of records increases, queries become slow. In MSSQL, I used to do something like index updates. I think something similar is needed for MySQL."

[kev1n]

Indexes in MySQL are essential for improving the performance of queries, particularly when working with large datasets. They are most beneficial in scenarios involving joins, WHERE conditions, ORDER BY, and GROUP BY clauses, as they allow MySQL to quickly locate the relevant rows without scanning the entire table. For instance, indexing columns involved in joins (e.g., user_id) or columns frequently queried (e.g., logon_time) can drastically reduce query times, especially as the number of records grows.