Member Avatar for saadi06

Hi,
I have a very complex query that is using mysql functions and complex logic. I have done indexing of important fields that needs to be done but I am having issue that the records keep on duplicating and I am using group by to remove this issue but my query gets halted if I try to use group by. How can I optimize my query.
Thanks in advance.

  • 2 Contributors
  • 1 Reply
  • 107 Views
  • 36 Minutes Discussion Span
  • Latest Post Latest Post by veedeoo
Member Avatar for veedeoo

try testing it on MySQL workbench. From there, you can optimize your query.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.