Best Way to Handle Millions of Rows in MySQL – Indexing vs Partitioning?

[helen9k]

Hi everyone,

I’m working with a MySQL table that already has several million rows, and performance is starting to slow down (queries and joins take noticeably longer).

• Should I focus more on creating proper indexes, or would partitioning be a better solution?
• Has anyone here tried sharding or splitting tables across multiple databases in a PHP project?
• Any practical tips for balancing performance vs maintainability?

Not sure if I’m asking in the right place, but I’d really appreciate your thoughts and experiences.
Thanks a lot!

Chiikawa Puzzle